close
Skip to main content
The 2026 Annual Developer Survey is live— take the Survey today!
10,700 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
Filter by Employee ID
Score of 0
0 answers
47 views

We have an Azure Functions (.NET 8 Isolated) application connecting to Azure SQL Database using Microsoft Entra authentication via Managed Identity. For the last couple of months we have been seeing ...
Advice
0 votes
0 replies
36 views

I’m trying to derive a daily snapshot table from a fact table that tracks file storage metadata. In production this table can contain tens of millions of rows, and its structure cannot be changed. To ...
Advice
0 votes
6 replies
110 views

I'm testing with a mobile app and webapp that both currently communicate through a local API with my local SQL Server database. There are three tabels and these all have less than 100 rows and about 6 ...
Score of 2
0 answers
324 views

We have a Visual Studio solution, written to run on .NET Framework 4.8 and mostly in VB.NET. Part of this is a mechanism to run SQL scripts stored in .sql files. This has worked fine for years, ...
Score of 0
0 answers
53 views

I created an Azure Data Factory and configured a new Azure-SSIS Integration Runtime (IR) using an existing Azure SQL Managed Instance that already contains an SSISDB catalog. When I try to start the ...
Score of 0
0 answers
69 views

I have an Azure Data Factory (ADF) Copy Activity that periodically copies a large volume of data from an Azure Synapse table into an Azure SQL database. Whenever the copy activity runs, the IO ...
Score of 0
0 answers
114 views

I’m trying to design a low-cost automated process for refreshing an Azure SQL database from backups that are delivered to an SFTP server. I receive either .bak or .bacpac files via SFTP. I want to ...
Score of 0
0 answers
58 views

I am loading data from Parquet into Azure SQL Database using this pipeline: Parquet → PyArrow → CSV (Azure Blob) → BULK INSERT One column in the Parquet file is binary (hashed passwords). PyArrow CSV ...
Advice
0 votes
4 replies
188 views

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’...
Score of 0
1 answer
135 views

I have a web app using code-first EF Core. One of the controllers needs to run what should be a simple query (basically SELECT TOP 1 * FROM companies WHERE id = @id; in EF terms, var data = await ...
Score of 1
1 answer
492 views

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....
Score of 0
0 answers
105 views

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... ...
Score of 0
0 answers
110 views

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 ...
Score of -1
2 answers
267 views

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 ...
Score of 0
1 answer
128 views

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/...

15 30 50 per page
1
2 3 4 5
…
714