10,703 questions
0
votes
0
answers
9
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....
- 866
0
votes
0
answers
67
views
How to get rid of $ShardName when using sp_execute_remote?
When using the sp_execute_remote to call the remote SQL command, the call adds the column $ShardName to the result data set.
Is there any way to suppress returning that extra column? Two reasons...
...
- 21k
0
votes
0
answers
48
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
-1
votes
2
answers
229
views
Azure SQL S0 Tier – Slow Update Performance During Peak IoT Data Processing
I'm using Azure SQL (Standard S0: 10 DTUs) to store data from various IoT devices.
Each IoT device sends messages to my Azure IoT Hub, which then triggers an Azure Function App. The Function App ...
- 773
0
votes
0
answers
43
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', ...
- 21k
0
votes
1
answer
55
views
Adding diagnosticSettings to Azure SQL Databases using Bicep loops
I am trying to set diagnosticSettings to an array of databases in bicep using for (db, i) in dataBaseArray.
At first I create the databases:
@batchSize(1)
resource sqlDatabases 'Microsoft.Sql/servers/...
- 119
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
60
views
Automatic tuning support at Azure SQL Database level via ARM template deployment
In my resource group I am trying to turn on auto-tuning via our ARM Template using this bit of JSON. What we'd like to know is, is if that restriction on PUT is from Org Policy and not just the fact ...
0
votes
0
answers
27
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
134
views
How to exclude all complex columns in an Azure Data Factory data flow
Alright so I was going to test my pipeline/data flow where I'm querying a cosmos DB and putting some of that data into an Azure SQL DB table. When trying to do so, I came across this validation error ...
- 687
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
0
votes
0
answers
91
views
How to send large JSON (15–20 MB) from Azure SQL to REST API using ADF + SHIR without escaping/wrapping?
Body:
I have an Azure Data Factory (ADF) pipeline running on a Self-Hosted Integration Runtime (SHIR).
In my SQL table, I have a column JsonData that stores large JSON objects (each 15–20 MB).
I need ...
- 85
1
vote
0
answers
95
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
104
views
Update Bicep File to Fix Azure SQL Database 2014-04-01 APIs will be retired?
My IT department is getting an e-mail "Azure SQL Database 2014-04-01 APIs will be retired on 31 October 2025". I use bicep and have never used any API's that are that old, they're all ...
- 8,925
0
votes
1
answer
100
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
63
views
Azure SQL Pricing Tiers - can we still reduce the Pricing Tier after creating a Memory Optimized Table? [closed]
One of our clients has a Azure SQL database running on a P1 Premium Pricing Tier.
I created a Memory Optimized table in this database, e.g.
CREATE
TABLE [dbo].[Foo]
([id] INT ...
- 866
0
votes
1
answer
630
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
42
views
Azure SQL Android Studio AssertionError: numMsgsRcvd:1 should be less than numMsgsSent:1
I'm trying to connect to my Azure SQL database via Android Studio, but keep getting an AssertionError while running the app. I'm using mssql-jdbc-12.10.1.jre11
Server.java
public static void ...
0
votes
0
answers
98
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
1
vote
1
answer
131
views
"Invalid use of a side-effecting operator 'DELETE' within a function" for the constructed result?
I have code that removes the records in the table variable @small_tab from another table variable @large_tab:
DELETE t1
FROM @large_tab AS t1
JOIN @small_tab AS t2 ON t1.[DBR Addition Cust Disc Group] ...
- 21k
0
votes
1
answer
494
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
2
answers
126
views
Delete query not working on Azure SQL Database
We have a query that creates a temporary table to store IDs for deletion and then deletes the corresponding records from a table in an Azure SQL database using transactions. The database is part of an ...
- 517
0
votes
1
answer
116
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
178
views
Issue with SQL Azure Secure Enclave: LIKE Clause Failing with Error
I am using Microsoft SQL Azure (RTM) - 12.0.2000.8, where I configured the secure enclave with VBS where I am using keyvalut for creating column master key. All the operators are working fine except ...
0
votes
1
answer
49
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
-4
votes
2
answers
102
views
select last non zero by SQL
Having large table T of dates, integers between 0 and 2, and isin strings like
date
V1
V2
V3
V4
isin
2015-01-01
0
1
0
2
a
2015-01-02
0
1
2
1
b
2015-01-05
1
2
0
1
c
2015-02-01
0
0
0
0
c
2015-02-02
1
2
...
0
votes
1
answer
137
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
1
answer
153
views
How can I fix/avoid exception saving entity in system-versioned table?
I'm encountering an issue when executing transactions on system-versioned tables (SQL Azure) in my ASPNET Core + Entity Framework app.
In my database, there are two system-versioned tables:
dbo....
- 2,019
0
votes
2
answers
229
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
1
vote
2
answers
249
views
JSON data type cannot be used in OpenJson function
I've been working on a solution in Azure SQL using the native JSON data type for the last month. Everything has been going well, but I've just run one of the functions that has been working ...
- 13
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
2
answers
168
views
How can I prevent SqlException (0x80131904): Login failed for user on .NET 8 Blazor Web App when deployed to Azure, with multiple connections at once?
I am using the .NET 8 Blazor web app template. I have been programming locally for a while with no issues. I recently tried to deploy my web app to azure, however I keep running into an error
...
0
votes
1
answer
108
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 ...
0
votes
1
answer
122
views
Unable to view tables after copying database to another Azure SQL Server
I have copied our database to another Azure SQL database, see the screenshot. However, when I access the database, I'm unable to view the tables. I can only view system tables. Can someone let me know ...
- 3,011
-1
votes
3
answers
202
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
0
answers
111
views
Why does my Azure Function app have latency?
I am experiencing an odd problem that I cannot find any solution for the last week.
Wednesday 16/4 ~17.00 suddenly my APIs deployed in an Azure Function app have become much slower.
The architecture ...
- 23
0
votes
1
answer
66
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 ...
-1
votes
2
answers
231
views
"You do not have permission to use the bulk load statement" error occurs when using managed identity
I'm migrating my application's data layer to using user-assigned managed identities to connect to SQL Server and other Azure services. While generally the migration went well, I get an error
You do ...
- 1,397
0
votes
1
answer
245
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
0
votes
2
answers
219
views
Apply Azure SQL database free offer via Terraform
Is it possible to apply the free offer via Terraform?
So far I can only apply it when I manually create the database and click on the "Apply offer" button.
I would expect that this is ...
- 9
-1
votes
1
answer
113
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,336
0
votes
1
answer
44
views
Monitor for changes in stored procedures or views in Azure SQL Server
We have an Azure SQL database that numerous people need to have access to. I would like an alert any time someone makes a change to a stored procedure or view.
0
votes
1
answer
197
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
299
views
Assign Azure Entra Group to Azure SQL Server Role
Azure SQL Server provides a set of Server Roles (https://learn.microsoft.com/en-us/azure/azure-sql/database/security-server-roles?view=azuresql#fixed-server-level-roles)
I want to assign a Azure Entra ...
- 2,605
0
votes
1
answer
185
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
2
answers
108
views
Same Table value selection from same clients
I need 1 record per Id and to achieve it I tried with self join, case statement as well tried using COALESCE function but I am still getting multiple records for same client.
Below approach is mostly ...
- 13
0
votes
1
answer
153
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
0
votes
1
answer
86
views
Managed identities in an ASP.NET Core Web API and Entity Framework Core code-first approach error
I have setup my system managed identity and my Web API as well as my Azure SQL Server and I figured I would give Entity Framework Core with a code-first approach a try but I am not able to get past ...
- 1,843
1
vote
1
answer
88
views
Bad Request on using New-AzSqlSyncMember powershell command
I am trying to set up a Sql Sync Member to a database in another tenant using the New-AzSqlSyncMember however whenever i run it get the error message
New-AzSqlSyncMember: Long running operation ...
- 11
0
votes
1
answer
110
views
Azure SQL SELECT columns INTO #Temp table very slow
Azure SQL SELECT of columns INTO #Temp table is executing very slowly. If I remove the INTO clause, it executes in 20 seconds instead on 10 minutes.
Kindly suggest, how do I optimize this query? ...
