Overview Customers using Azure SQL Database – Hyperscale may sometimes notice a discrepancy between the configured Point-in-Time Restore (PITR) retention period and what the Azure Portal displays a...

By Tanayankar Chakraborty & Dimitri Furman  Issue  We recently worked on a customer case involving challenges with shrinking an Azure SQL Database (Hyperscale). The primary concern was that the s...

Scenario (from a real service request) A customer reported a General Purpose (Gen5, 2 vCores) Azure SQL Database that was incurring charges but could not be deleted using Azure Portal or Azure CLI....

When you run multiple databases inside an Azure SQL Database elastic pool, it’s common to hit questions like: Which database is using the most sessions right now? Are we getting close to the po...

If you’ve ever stared at Azure SQL Database metrics and thought: “Hold on… SQL Instance CPU Percent includes user + system, so it must be higher than CPU Percentage, right? If it’s lower… something’...

A few days ago, I was working on a customer case where their database went into inaccessible state due to Server level CMK TDE got expired. Though the database was brought back to online, customer ...

Recently, I worked on a service request where a customer reported that an Azure SQL Database could not be scaled down from Standard S3 to Standard S2. The operation failed with the following message:...

Summary This post walks through a real-world troubleshooting scenario involving Microsoft Entra ID Managed Identity authentication failures to Azure SQL Database. The issue appeared intermittently...

Azure SQL Data Sync is commonly used to keep selected tables synchronized between a hub database and one or more member databases. In some cases, you may discover a data “gap”: a subset of rows that ...

Transparent Data Encryption (TDE) in Azure SQL Database encrypts data at rest using a database encryption key (DEK). The DEK itself is protected by a TDE protector, which can be either: A service...