10,703 questions
Advice
0
votes
2
replies
59
views
Ways to Improve Bulk-Insert Throughput in Azure SQL
I’m attempting high-volume bulk inserts into Azure SQL, but the performance is lower than expected. One known factor is the Max Log Rate (MiB/s) limit, which depends on the service tier (see Microsoft’...
- 590
0
votes
1
answer
75
views
sp_delete_database_firewall_rule fails for greyed out firewall rules
I'm looking at the Networking settings for one or our Azure SQL servers, and I see some of them are greyed out.
Azure Portal shows a message "You can use TSQL to remove or modify greyed out rules....
- 976
0
votes
0
answers
53
views
Random Change tracking enabled error when deploying `DACPAC` using `DacFx`
We have a SQL Server Data Tools (SSDT) Visual Studio database project, and we deploy the DACPAC output using DacFx + PowerShell scripts.
In this project, we enable:
Database-level change tracking via ...
- 33.9k
0
votes
0
answers
45
views
How to wrap Azure SQL sp_execute_remote as a table function? [duplicate]
Having the SQL stored procedure remote_usp_test in the remote database, I can successfully call it using the sp_execute_remote from the local database like this:
EXEC sp_execute_remote N'xxxDataSrc', ...
- 21.1k
0
votes
0
answers
23
views
Azure Function SQL Output Binding hangs on insert (Node.js) + need APIM policy to match OIDC oid/sub
I’m trying to insert rows into Azure SQL Database using Azure Functions SQL Output Binding (Node.js).
const { app, output } = require('@azure/functions');
const { z } = require('zod');
// SQL Output ...
0
votes
0
answers
32
views
Can’t connect to Azure failover group listener endpoint
I configured a failover group with a SQL MI in West US and another SQL MI in West US 3. Each have their own VNET, subnets and NSG configured. The first SQL MI existed prior to creating the failover ...
- 691
0
votes
0
answers
101
views
Key column does not exist in mapped columns
I'm receiving this error when trying to test my data flow/pipeline
I've got a data flow where I'm querying a Cosmos DB and inserting some of that info into an Azure SQL DB table. I have auto mapping ...
- 687
1
vote
0
answers
106
views
Using msal token to authenticate towards Azure SQL database
I have a python based Docker container to be run on Azure Kubernetes and need to connect to an Azure SQL database. I previously used the adal package for Python, but due to security reasons, we want ...
0
votes
1
answer
105
views
How to dynamically generate SQL to Update/Insert a table in Azure Databricks Notebook
Its a sort of CDC ( Change Data Capture ) scenario in which I am trying to compare new data (in tblNewData) with old data (in tblOldData), and logging the changes into a log table (tblExpectedDataLog) ...
- 27
0
votes
1
answer
716
views
How to connect to Fabric SQL database from Notebook?
I'm trying to connect from a Fabric notebook using PySpark to a Fabric SQL Database via JDBC.
I have the connection code skeleton but I'm unsure where to find the correct JDBC hostname and database ...
- 53
0
votes
0
answers
110
views
Liquibase JDBC error with Azure SQL and managed identity
I am using Liquibase 4.32 for Azure SQL database deployment. I want to use user-assigned managed identities for deployment rather than specifying the username and password. For that, I followed this ...
- 705
0
votes
1
answer
547
views
ManagedIdentityCredential authentication failing
In our Azure Pipeline we add members to roles of a SQL Server database:
ALTER ROLE [db_datareader] ADD MEMBER [$(user)]
ALTER ROLE [db_datawriter] ADD MEMBER [$(user)]
This has worked years without ...
- 381
0
votes
1
answer
132
views
Unable to enable only Entra ID authentication for Azure SQL for app service slot
I have azure web app having system managed identity turned on.
I am trying to add this app(using identity) to the Azure SQL Server
CREATE USER [appname] FROM EXTERNAL PROVIDER;
This works fine but ...
- 1
0
votes
1
answer
50
views
Can't authenticate to Azure SQL instance from Azure VM, but can from external
I'm baffled. I'm trying to connect to an Azure SQL database (managed, not a VM) from an Azure VM running Ubuntu. I'm using python FreeTDS ODBC with a connection string that looks like:
Driver=...
- 368
0
votes
1
answer
139
views
SQLPackage adding REVOKE CONNECT to users - how to remove just the REVOKE CONNECT? (SDK-Style database project)
TLDR: running SQLPACKAGE /action:Scripts against my DACPAC results in users/logins created, but the create script runs a "CREATE USER FOR LOGIN X; REVOKE CONNECT TO X". I need it to not run ...
- 1,368
0
votes
2
answers
260
views
Azure DB paused and won't unpause
The Azure SQL database is designed to auto-pause when
a) it hasn't been active for a period of time,
b) when it reaches the limit of a resource.
For the first, you just attempt to connect again and it ...
- 883
0
votes
1
answer
90
views
Powershell runbook is giving timeout error while copying the Azure SQL database
I'm using a PowerShell script to create a copy of an Azure SQL Database (Database1) using the New-AzSqlDatabaseCopy command. However, the runbook times out during execution. I'd like to know:
Does the ...
0
votes
1
answer
110
views
Azure .NET web app is not connected to Azure SQL Server, but works fine on local
I'm trying to deploy my ASP.NET Web API to Azure.
Long story short - it works on local machine - Azure SQL, but not on the cloud app (HTTP ERROR 500) using the same AZURE_SQL_CONNECTIONSTRING.
Is ...
-1
votes
3
answers
209
views
Slow performance and timeout when writing 15GB of data from ADLS to Azure SQL DB using Databricks
We have a daily ETL process where we write Parquet data (~15GB) stored in Azure Data Lake Storage (ADLS) into a table in Azure SQL Database. The target table is truncated and reloaded each day.
...
- 166
0
votes
1
answer
75
views
I am not able to see any databases after connecting source SQL Server to Azure Data migration Service
enter image description here
During the POC, while I am trying to connect my source, source connection is established successfully, but I don't get any databases populated in the source.
I want to ...
0
votes
1
answer
263
views
Login failed for user '<token-identified principal>' when Service Principal is SQL Entra Admin
I have a problem to log in to Azure SQL with Service Principal using Powershell.
My Service Principal is an Admin on this Azure SQL.
Service Principal has Directory.Read.All Graph api permission and ...
- 5,435
-1
votes
1
answer
114
views
Does Glue connect to SQL Server? [closed]
I haven't found a single tutorial that shows how to connect Glue to a SQL Server or Azure DB instance, so that's why I'm here.
I'm having issues connecting AWS Glue to a SQL Server instance in a ...
- 3,346
0
votes
1
answer
203
views
Unable to Authenticate JDBC Connection to Azure SQL DB from Databricks - Must Use Multi-Factor Authentication
I'm trying to connect to our Azure SQL DB from Databricks configured with JDBC as follows:
DBUser = 'test2'
DBPword = 'xxxxxx'
DBServer = 'hst37dg5zxxxxxxy-exnwgcizvwnurfcoqllpyaj3q4'
DBDatabase = '...
- 3,011
0
votes
1
answer
203
views
Fetch data from EntraID into SQL MI table
We have a Azure environment and a SQL MI instance (with SSMS) and a Azure AD (EntraID) that is handled by the security team at our company.
Today we are reading Active Directory data via SQL Server ...
- 514
0
votes
1
answer
159
views
How to configure connection string in Azure web app in .NET 8?
I have a web application in .NET 8 hosted in an Azure web app.
I have added a connection string in environment variables and want to access it in the program.cs file when we normally pass the ...
- 1,093