10,706 questions
0
votes
0
answers
25
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
1
answer
67
views
Azure SQL S0 Tier – Slow Update Performance During Peak IoT Data Processing [closed]
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 ...
- 763
0
votes
0
answers
30
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
88
views
How do I get a T-SQL view based on a JSON_OBJECT to output data? [closed]
My view that puts out a JSON object:
SELECT JSON_OBJECT(
/*StaticDataStart*/
'currencyCode': 'GBP',
/*StaticDataEnd*/
'phoneNumber':dbassyOrderio.Telephone,
'email':...
0
votes
0
answers
84
views
Connection MSSql using Azure AAD - Service Principal Auth [closed]
Issue
I am facing trouble connecting to an MS SQL Database hosted on Azure SQL Server.
Dependencies
[email protected]
[email protected]
[email protected]
Other details
In the Azure environment:
I have ...
0
votes
1
answer
43
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
20
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
48
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
20
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
125
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
93
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
89
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
74
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
95
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
96
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