Stack Overflow
Stack Overflow

Questions tagged [azure-sql]

51 questions
1
vote
0 answers

running Add-AzSqlElasticJobStep errors referencing credential

I am trying to use powershell to create an Elastic Job. I can create the job using TSQL with no issues but when try to add a job step it gives error: 'Elastic jobs management operation failed. Cannot reference the credential 'JobExecuteUser',…
deannich
  • 11
  • 1
1
vote
1 answer

Is there a way to disable and re enable FOREIGN KEY constraints for a database Azure SQL

I'm trying to truncate some tables in a database. Some of these tables have foreign keys. So when I try to truncate them I get the following error. Cannot truncate table 'IDN_OAUTH2_ACCESS_TOKEN' because it is being referenced by a FOREIGN KEY…
Buddhima Udaranga
  • 943
  • 7
  • 10
1
vote
1 answer

How to import large column (>4000 characters) from a CSV into database table

We have a large CSV file with couple of columns. One of the column has a large data many times spanning more than 4000 characters and gets truncated when importing using data flow. ADF data type is String SQL data type is Nvarchar(max) What are…
DhruvJoshi
  • 17,041
  • 6
  • 41
  • 60
1
vote
1 answer

DML operations on Tables in Different databases of AzureSQL PaaS

All, We are migrating our database from SQLServer 2012 to AzureSQL PaaS DB. In lot of stored procedures, we have code as below: USE ClaimDB1 GO Delete ClaimDB2.dbo.Claims Where Claimdate < ‘12/01/2020’ The database ClaimDB1 and ClaimDB2 are in the…
Gopinath Rajee
  • 400
  • 5
  • 20
1
vote
0 answers

Best way to process 1400 million records in SQL

I humbly request you to help me with the below scenario, In my project I have to process time series data from a table. We are using Azure SQL Server. The table dbo.batch_events has 1400 million rows, please see the below screenshot for the table…
Gopinath
  • 51
  • 1
  • 6
1
vote
1 answer

Backup database with Entity Framework on ASP.Net

I have an interesting case. I lost access to an Azure subscription. However, I still have access to publishing an ASP.Net application, because I configured a publishing profile, which still works. Note, that this is nothing illegal - internal…
Spook
  • 25,318
  • 18
  • 90
  • 167
1
vote
0 answers

How do I upload Amazon Seller reports into a SQL database?

I tried to load a csv file (>50 MB) into Azure SQL Studio, but the upload never finished despite two attempts. Do you have any ideas on how to fix this? Alternatively, to avoid the manual uploading, is there a way to directly pipe files from…
user14419195
  • 11
  • 1
1
vote
1 answer

Azure SQL. Read-only replicas. Is there a way to manage how many replicas database and configure load balancing across them

What I'd like to achive is to be able to scale out Azure SQL Database. Business Critical tier has this feature to enable several read-only replicas. This is a great feature that would let me offload some traffic over to those replicas The problem…
Stanislav
  • 165
  • 1
  • 15
0
votes
1 answer

Azure web app connection to azure sql fails?

I Created a Web App, Ive setup a Azure sql server with a private endpoint Created a Azure SQL database on the above sql server Created an endpoint for SQL server database and added firewall rule to allow azure services through, also added vnet…
itye1970
  • 1,654
  • 7
  • 31
  • 62
0
votes
1 answer

Azure SQL Server BCP -

I have a csv file with 3 columns LastName FirstName EmpID I was SQLLDR to load the data into Oracle database however I opted to use BCP to load the data into Azure sqlserver after the database migration to Azure SQL Server. I am using the following…
One Developer
  • 99
  • 5
  • 43
  • 103
0
votes
1 answer

Azure Flask app | Azure SQL - pyodbc.OperationalError Timeout with load_dotenv()

I have a Flask app running on Azure with a connection to an Azure SQL db and after the below developments I can't access the database any longer. Here is what I recently added : created a .env file to secure the connection string added a…
ZaraThoustra
  • 85
  • 9
0
votes
1 answer

How to monitor if table is empty in Azure SQL?

I have Azure Dashboard visualizing metrics of Azure SQL And Azure Data Factory. I have Azure Alert and LogicApps sending alert. Now I would like to build monitoring report if table is empty or if there are data duplicates in Azure SQL. What is…
Kenny_I
  • 2,001
  • 5
  • 40
  • 94
0
votes
1 answer

Add Azure Blob Partitions to Azure SQL Table

I have partitioned parquet files in Azure Blob that I am copying to Azure SQL. How do I get the partition name into the SQL table? I've figured out how to get the full file path into the SQL table by adding an Additional Column in the source data…
Mariah Akinbi
  • 386
  • 1
  • 5
  • 19
0
votes
4 answers

How to store hot and cold data with Azure SQL

I have a huge order table in Azure SQL. I have one boolean field "IsOrderActive" to separate hot and cold orders. Is it possible to automatically transfer cold data to a separate database with Azure SQL?
Alexey Ryazhskikh
  • 2,458
  • 4
  • 32
  • 51
0
votes
1 answer

adf function to read only certain portion of filename based on pattern

I have file names as SMP_ACC_STG_20210987654.txt and another filename SMP_ACC_STG_BS_20210987654.txt. I can use @substring(item().name,0,11) and i get SMP_ACC_STG for first file which is correct but for second file I need to get filename as…
Nanda
  • 159
  • 1
  • 13
1
2
3 4