Azure SQL Database
An Azure relational database service.
6,890 questions
1 answer
How to automate the rightsizing process of sql single db (DTU)?
I need to automate the process of rightsizing sql single db (DTU) based on the workloads to optimize the cost. And also need to check if there will be any downtime and how to handle it. And also this should be rightsized in the non usage hours only…
Azure SQL Database
asked 2026-06-16T05:04:21.3533333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 64%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPM%3C/text%3E%3C/svg%3E)
Padmanabhan M
220
Reputation points
commented 2026-06-19T08:56:21.09+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 24%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPP%3C/text%3E%3C/svg%3E)
Pilladi Padma Sai Manisha
10,190
Reputation points Microsoft External Staff
Moderator
1 answer
How to gain access for my subscription to make an sql database in the same region as my vnet
I'm trying to create an sql database and match the region to my vnet, which is in us east and it's saying my subscription doesn't have access to create a server in that region.
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,890 questions
asked 2026-06-18T22:09:37.2166667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(224.00000000000003, 74%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJC%3C/text%3E%3C/svg%3E)
Jack Callahan
0
Reputation points
edited the question 2026-06-19T08:13:34.07+00:00
Erland Sommarskog
134.7K
Reputation points MVP
Volunteer Moderator
2 answers
Issues executing bulk data transfers using the SQL Server bcp utility.
SQL Server Tools & Utilities (bcp utility) We attempted to use bcp out with the native format flag (-n) to stream data through a Linux named pipe (FIFO), the process encounters data corruption. This issue specifically triggers when the table…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,890 questions
asked 2026-06-15T06:46:25.35+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(272, 64%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJB%3C/text%3E%3C/svg%3E)
Juhi Bhatnagar
0
Reputation points
commented 2026-06-19T08:03:08.42+00:00
Erland Sommarskog
134.7K
Reputation points MVP
Volunteer Moderator
1 answer
How can I optimize a complex SQL reporting query with multiple joins, aggregations, and filters without changing existing business logic rules?
I am working on a production SQL report that joins eight tables, applies several date and status filters, and computes grouped totals for weekly dashboards. Query runtime increased from under one minute to nearly fifteen minutes after adding two new…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,890 questions
asked 2026-06-18T03:08:38.21+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 26%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)
HimanshuSinha
19,637
Reputation points Microsoft Employee
Moderator
commented 2026-06-19T03:31:35.34+00:00
Pilladi Padma Sai Manisha
10,190
Reputation points Microsoft External Staff
Moderator
3 answers
One of the answers was accepted by the question author.
Azure SQL Database Server - SQL Audit to Log Analytics Workspace - How can I view Failed Logins ?
I have Azure SQL Database server where I enabled SQL Audit. It writes to Log Analytics Workspace as audit destination. According to docs, it should capture FAILED_DATABASE_AUTHENTICATION_GROUP events. I have requirement to capture and view failed…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,890 questions
asked 2026-06-17T23:16:30.8266667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(297.6, 60%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAV%3C/text%3E%3C/svg%3E)
Aleksey Vitsko
25
Reputation points
commented 2026-06-19T00:28:34.7133333+00:00
Jose Benjamin Solis Nolasco
8,561
Reputation points
Volunteer Moderator
1 answer
Server identity does not have the Microsoft Entra Directory Readers permission.
I'm using a Service Principal that creates an SQL Server with an SMI (System-assigned managed identity) in an Azure DevOps pipeline, and then runs an .sql file with the SQL Server's SMI. I made sure that the SMI has the following permissions in Azure: I…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,890 questions
asked 2026-06-18T08:41:48.62+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(182.40000000000003, 83%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDM%3C/text%3E%3C/svg%3E)
Daniel Martinez
40
Reputation points
answered 2026-06-18T15:06:10.56+00:00
Erland Sommarskog
134.7K
Reputation points MVP
Volunteer Moderator
3 answers
One of the answers was accepted by the question author.
Data Sync has been failing for over a week
Data Sync Sync_To_Reporting_Database on Database SDPriceIT has been failing for over a week, I have tried increasing the DTU settings to 3000 and it has still failed. Please advise what Failure looks to be a timeout.. Check the inner exception for any…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,890 questions
asked 2026-06-08T14:52:49.0733333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(246.4, 40%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPQ%3C/text%3E%3C/svg%3E)
Peter Quinn
20
Reputation points
accepted 2026-06-18T10:24:50.9566667+00:00
Peter Quinn
20
Reputation points
3 answers
A vulnerability was detected on Azure SQL server on port 443 that tls1.0 and 1.1 are enabled. But we already disabled and configured a minimul TLS version in configuration
We disabled and configured a minimum TLS version of 1.2 in configuration of Azure SQL server. But a vulnerability was detected on Azure SQL server on port 443 that tls1.0 and 1.1 are enabled. The vulnerabilities were not detected on port 1433 but only…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,890 questions
asked 2026-05-19T12:28:31.8866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(92.8, 90%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESL%3C/text%3E%3C/svg%3E)
Singireddy Lohith Reddy
0
Reputation points
commented 2026-06-18T05:59:45.6866667+00:00
Pilladi Padma Sai Manisha
10,190
Reputation points Microsoft External Staff
Moderator
0 answers
Unable to Enable Zone Redundancy for Azure SQL Managed Instance in East US 2
Issue Summary We are attempting to enable Zone Redundancy for our Azure SQL Managed Instance deployed in the East US 2 region. According to Microsoft documentation and the Azure region availability information, East US 2 supports Zone Redundant…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,890 questions
asked 2026-06-17T20:43:26.9033333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(118.4, 77%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Ali Mehmood
0
Reputation points
commented 2026-06-17T21:30:36.72+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(208, 49%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESJ%3C/text%3E%3C/svg%3E)
SAI JAGADEESH KUDIPUDI
3,470
Reputation points Microsoft External Staff
Moderator
2 answers
One of the answers was accepted by the question author.
How to tell which resources are using Azure SQL Database 2014-04-01 APIs
I got the email that says I have resources using Azure SQL Database 2014-04-01 APIs and those APIs are retiring but it has no indication on how to find the resources that are using that API. How can I find the resources that are using Azure SQL Database…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,890 questions
asked 2026-06-09T16:07:45.8833333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(92.8, 43%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERB%3C/text%3E%3C/svg%3E)
Ryan Brown
40
Reputation points
accepted 2026-06-16T12:14:32.1633333+00:00
Ryan Brown
40
Reputation points
2 answers
Azure SQL Managed Instance and Express Vulnerability Assessment
Hi, I am using Azure SQL Managed Instance and have enabled Vulnerability Assessment Express recently. What is the recommended way to configure alerts and notifications for Vulnerability Assessment findings on Azure SQL Managed Instance? Before I got an…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,890 questions
asked 2026-06-15T07:48:02.4933333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(105.60000000000001, 56.00000000000001%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
Julie
220
Reputation points
commented 2026-06-16T07:21:22.33+00:00
Pilladi Padma Sai Manisha
10,190
Reputation points Microsoft External Staff
Moderator
2 answers
After I turn off the auto-pause delay for my azure sql database
I just created my first Azure SQL database. It is on the free tier. I want to reduce my auto-pause-delay, but I want to stay on the free tier. I read through some of the information on this site and found that if I turn off the free tier, I get the…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,890 questions
asked 2026-06-13T00:45:17.04+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(140.8, 0%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Steven Scearce IV
6
Reputation points
commented 2026-06-16T07:18:29.67+00:00
Pilladi Padma Sai Manisha
10,190
Reputation points Microsoft External Staff
Moderator
3 answers
Sql Server Billing is very incorrect
I have a resource group with a SQL Server and a SQL Server Database. For my SQL Server Database, I have selected general purpose (most budget friendly), serverless, 1 max vcore 8GB allocated space. Under compute + storage it has an estimated storage…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,890 questions
asked 2026-06-05T21:35:58.08+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(99.2, 89%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDP%3C/text%3E%3C/svg%3E)
Dejan Popovic
0
Reputation points
edited an answer 2026-06-15T09:55:01.0133333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(316.8, 22%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELR%3C/text%3E%3C/svg%3E)
Lakshma Reddy Vattijonnala
920
Reputation points Microsoft External Staff
Moderator
0 answers
Elastic pool stuck in “Provisioning” after failed scale to 800 DTU — cannot revert to 50 DTU
I have an Azure SQL Elastic Pool that became stuck in a “Provisioning” state after a failed scale-up operation to a higher DTU level. The scale operation did not complete, and now the pool cannot be scaled up or down. Symptoms: The elastic pool shows…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,890 questions
asked 2026-06-15T04:13:21.3366667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(41.6, 77%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
JohnCz
0
Reputation points
commented 2026-06-15T04:45:46.03+00:00
Pilladi Padma Sai Manisha
10,190
Reputation points Microsoft External Staff
Moderator
1 answer
Trying to add new card to purchase database
Hi all, I'm hoping someone here has hit this and can point me in the right direction, because a week with support hasn't resolved it. In fact i don't even seem to care with level of comms and questions in the last 8 days. The problem: I'm trying to add a…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,890 questions
asked 2026-06-08T20:21:56.41+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(201.6, 60%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
Simon Drayton
0
Reputation points
commented 2026-06-12T02:18:34.63+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 68%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBY%3C/text%3E%3C/svg%3E)
Bharath Y P
9,730
Reputation points Microsoft External Staff
Moderator
2 answers
Run away process
Bad while loop on site cause it to keep writing to SQL, will not stop even after server stopped....NEED IMMEDIATE HELP
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,890 questions
asked 2026-06-08T17:03:45.0266667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(179.20000000000002, 20%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERS%3C/text%3E%3C/svg%3E)
Rich Simpson
20
Reputation points
answered 2026-06-11T19:02:48.5466667+00:00
SAI JAGADEESH KUDIPUDI
3,470
Reputation points Microsoft External Staff
Moderator
0 answers
How to resolve Databases inaccessible due to CMK TDE key access lost, configuration now correct but databases not recovering
Trying to raise a support ticket but it sent me here. Issue type: Technical Service: SQL Database Environment: Production Severity: Critical (users unable to access production system) Problem type: Security, Private and Compliance Summary:…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,890 questions
asked 2026-06-08T22:30:26.14+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 23%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKW%3C/text%3E%3C/svg%3E)
Kevin Whitmore
0
Reputation points
commented 2026-06-10T21:21:13.06+00:00
SAI JAGADEESH KUDIPUDI
3,470
Reputation points Microsoft External Staff
Moderator
2 answers
Production database connectivity issues starting at 10:22am today
Our production database has connectivity issues for ~30 mins staring approx 10:22am today. I've run the diagnostic suggested by Critical insight - no issues found. I need to know what caused the issues so any underlying problems can be resolved.
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,890 questions
asked 2026-05-13T10:26:21.9466667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(48, 18%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
RJT72
0
Reputation points
commented 2026-06-10T18:19:21.6+00:00
SAI JAGADEESH KUDIPUDI
3,470
Reputation points Microsoft External Staff
Moderator
1 answer
One of the answers was accepted by the question author.
How does SQL Server licensing under the IaaS model work for end-of-life versions ?
Specifically, if I have SQL Server 2016 or 2019 running on Azure virtual machines (IaaS) with different licensing models - such as with Azure Hybrid Benefit enabled and without it (using pay-as-you-go for Standard or Enterprise editions) - how is…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,890 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(131.20000000000002, 4%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
8 answers
Retirement notice: Azure SQL Database 2014-04-01 APIs will be retired on 30 June 2026
We’re constantly making updates to Azure SQL Database APIs to ensure optimal security and performance. As part of these updates, we’ll retire Azure SQL Database API version 2014-04-01 on 30 June 2026. See our documentation for a detailed list of all…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,890 questions
asked 2022-11-02T22:58:09.407+00:00
GeethaThatipatri-MSFT
29,597
Reputation points Microsoft Employee
Moderator
commented 2026-06-10T09:28:11.2633333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(179.20000000000002, 7.000000000000001%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDS%3C/text%3E%3C/svg%3E)
Dadi, SM (Samba)
0
Reputation points