One of the most effective ways to truly understand how Azure SQL Database connectivity works is to observe the connection at the packet level. A short Wireshark capture clearly shows the interaction ...

If you’ve ever opened a packet capture for an Azure SQL Database connection, you’ve seen a very “SQL-shaped” conversation riding on top of TCP: Tabular Data Stream (TDS). TDS is the application-layer...

In some environments, users follow a weekly workflow where they drop a table and later re-enable mirroring for that table. While this works most of the time, it can occasionally lead to metadata inco...

Azure SQL Managed Instance supports setting up a linked server to Azure Synapse SQL using SQL Authentication or Managed Identity. The linked server will grant you access to the Synapse SQL instance, ...

On a recent case, a customer received the error "Invalid Managed Identity" when trying to scan a database. The error suggests that there is an issue with the managed identity or the RBAC permission...

Co-authored with angesalsaa​  Case Overview We investigated a customer case where a Major Version Upgrade (MVU) from PostgreSQL 11 to 17 on Azure Database for PostgreSQL Flexible Server consisten...

Getting Better Diagnostics with ClientConnectionId in .NET A few days ago, I was working on a customer case involving intermittent connectivity failures to Azure SQL Database from a .NET applicatio...

Query performance tuning is one of the most critical aspects of maintaining stable and predictable workloads in Azure SQL Database. While Microsoft continuously improves the SQL Server Cardinality Es...

1) Scope & Symptoms Observed symptom: Queries for the read‑only replica are now visible in the primary database’s Query Store. Please verify the application’s connection string and check whether ...

Co‑authored with HaiderZ-MSFT​  Symptoms Customers experience issues when attempting to approve a Private Endpoint for Azure PostgreSQL Flexible Server, particularly in cross‑subscription or cros...