6,889 questions with Azure SQL Database tags
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…
Why does my SQL query slow down dramatically with additional joins and grouped calculations despite indexes on key columns everywhere?
I maintain a SQL Server reporting query that combines order, customer, payment, shipment, and product tables for monthly operational metrics. After adding two business-required joins and several CASE-based aggregate calculations, runtime increased from…
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 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…
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…
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…
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 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…
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…
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…
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…
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…
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…
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
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:…
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.
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…
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…
Users connecting over Always On VPN using split tunnel for user and device are unable to connect to Azure SQL Managed Instance using Windows Authentication with Kerberos protocol enabled
Users connecting remotely over Always On VPN(split tunnel for user and device) are unable to connect to our Azure SQL Managed Instance using Windows Authentication with the kerberos protocol enabled. It's working ok from on premise servers and over…
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…