Azure PostgreSQL server unreachable – app failing with OperationalError (Tracking ID: e521870a-a610-410d-a970-b5b3e05e6e50)
Summary: My Django web app hosted on Azure App Service has worked flawlessly for months but suddenly started returning 500 errors on login. I have made no code changes. On investigation, I've confirmed the app can no longer connect to the Azure…
Azure SQL Database
Unable to Reclaim Allocated Space After Shrinking Azure SQL Database
We are experiencing an issue with reclaiming allocated space from our Azure SQL Database (Pass Service)despite running DBCC SHRINKDATABASE. The database in question (db_name) currently shows approximately 300 GB of used space but over 1 TB of allocated…
Azure SQL Database

Can't create a SQL Database server in East US region.
Hello Team, We would like to create a SQL Database server in East US region. But we see the following error - "Your subscription does not have access to create a server in the selected region. For the latest information about region…
Azure SQL Database

How to connect from an azure VPN to an azure SQL server from my PC?
We want from our work computers using an azure VPN to be able to connect/access the databases we have in azure SQL/MySQL. I have read the documentation but I don't understand how it is possible to do this without having to connect from a virtual machine.…
Azure SQL Database
Azure VPN Gateway
Azure Virtual Network
Azure Database for MySQL
How to resolve the "Incorrect syntax near 'FORMAT'" with Parquet file
I'm working with Azure Sql connected to an Azure Storage account. I want to read a Parquet file from a Azure Storage account. This code works with a CSV, so I know the connection is good, but when I set the Format to Parquet I get Incorrect syntax…
Azure SQL Database
What are the cost impact of increasing storage for databases in Azure SQL Elastic Pool
We’re using Azure SQL Databases in an Elastic Pool configuration with General Purpose: Standard-series (Gen5), 6 vCores, and I’m trying to understand how the cost is calculated for the elastic pool, especially regarding storage usage. My current…
Azure SQL Database
Azure SQL - High CPU usage - Wait type: SOS Wait Dispatch
I have a current Azure SQL database running high CPU utilization. running sp_who2 shows task: SUSPENDED DB000013 programname: tdService. Can this be turned off or adjusted. maxdop adjusted index fragmentation - resolved
Azure SQL Database
"DBCC SHRINKFILE for data files is not supported in a Hyperscale database" error trying to shrink db
I get the following when attempting to use either SHRINKFILE or SHRINKDATABASE: "DBCC SHRINKFILE for data files is not supported in a Hyperscale database when the database is not encrypted or protector change is in progress. Enable transparent…
Azure SQL Database
Azure Data Sync to on-prem SQL succeeded but the destination table has old and new records
We have an Azure Data sync group to sync multiple tables from an Azure SQL database to SQL on-premises database. The sync group has been setup for a while, however, yesterday we noticed that in one of the tables we had data that should have been deleted…
Azure SQL Database
Azure SQL Managed Instance - A disconnect event was raised when server is waiting for Federated Authentication token
We are running Production workloads on Azure SQL Managed Instance, and periodically we see errors: A disconnect event was raised when server is waiting for Federated Authentication token. This could be due to client close or server timeout…
Azure SQL Database
Azure SQL PaaS Failover Scenario and Cost
Hi, I have a few questions regarding Azure SQL PaaS failover, pricing, and integration with private endpoint: If I configure a Failover Group that contains 10 SQL databases, will the entire failover group automatically failover if only one of the…
Azure SQL Database
Azure, Export Hyperscale Database to BacPac failed due to Vector datatype column in a table.
Trying to export a Hyperscale SQL database to Blob storage BacPac. I did som laborations with VECTOR datatype in one table an left it there for later laborations. The export fails due to the Vector column. ErrorMessage: "The ImportExport…
Azure SQL Database
Data factory fails to run Stored Procedure when SSMS succeeds
I have a nightly job that generates an email via a stored procedure run through azure data factory. It has been in use for about 2 years with no problem. Yesterday it failed without any changes to the SQL A database operation failed with the following…
Azure SQL Database
Azure Database unable to update Datasync config & Datastudio timeout
We seem to be having 2x issues with an Azure SQL database. Datasync keeps failing sync data & reconfiguring of tables to sync. The database is timing out populating the tree of table in both SQL Management Studio & Azure Data Studio. The…
Azure SQL Database
Cant get the Database Watcher to start collecting data from the Azure SQL DB
We carefully configured a database watcher as per documentation. everything is setup (Key Vault with proper permissions, executed script to create login and grant permissions (script copy-pasted), created secrets in the vault). But we don't get any data…
Azure SQL Database
Failed SQL logins to MI coming from same subnet as SQLManagedInstance
We have started monitoring failed login attempts to our managed instance and see some failed connections that we can't seem to figure out what the attempt may be. Error message: A disconnect event was raised when server is waiting for Federated…
Azure SQL Database
Login Failed for User '
Encountering the error "Login failed for user '
Azure SQL Database
Is it mandatory to create index's for azure sql database object's and also how to handle performance issue on azure databases.
Is it mandatory to create index's for azure sql database object's and also how to handle performance issue on azure databases.
Azure SQL Database
I can connect to my Azure database today. Can you help me solve this issue?
Microsoft.Data.SqlClient.SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL…
Azure SQL Database
How to improve query performance in Azure SQL Database with large datasets?
Hi everyone, I'm working with an Azure SQL Database that contains a few large tables (over 10 million rows each), and I'm noticing performance issues when running complex joins and aggregations. I've already implemented indexing on the commonly queried…