While configuring Auditing settings for Azure SQL, the deployment may fail and following error is encountered:   Failed to save Auditing settings for server. The client has permission to perf...

Azure SQL Database failover groups are a business continuity capability that helps you manage geo-replication and coordinated failover of one or more databases from a primary Azure SQL logical server...

A few scenarios where sequencing is useful: Generating Unique Identifiers: When you need a unique sequential number for each new row (e.g., order numbers, invoice numbers). Unlike identity co...

Co‑authored with HaiderZ-MSFT​  Case Overview A customer attempted to increase storage for their Azure Database for PostgreSQL Flexible Server but was unable to exceed 32 TiB. Investigation confi...

When Change Tracking is enabled, the system-maintained history table dbo.MSChange_tracking_history is a key place to look for cleanup progress and errors. For example, Microsoft’s troubleshooting gui...

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