Recent Blogs
A user connects to Azure SQL Managed Instance through SQL Server Management Studio (SSMS) using Microsoft Entra authentication with multifactor authentication (MFA). The sign-in flow completes, b...
Nov 17, 202637Views
0likes
0Comments
CPU hit 100%. You scaled the database. The problem went away. You still haven't proved that CPU was the root cause.
We see RCAs written this way all the time, and it's easy to understand why. There...
Nov 16, 202647Views
0likes
0Comments
5 MIN READ
Your query returns 800 rows, but the engine processed 108,000 to get there. That gap may be the whole performance problem.
"This query used to be fast, and nobody changed it" is one of the most com...
Nov 16, 202637Views
0likes
0Comments
4 MIN READ
Can an Azure SQL database look healthy while your users can't log in? Yes. It happens when the health signals and your application are measuring different things.
We see this question in support ca...
Nov 16, 202636Views
0likes
0Comments
5 MIN READ
Your database disappeared for seven seconds. Was that an outage, a maintenance event, or a gap in how your application handles reconnects?
We get some version of this question a lot. A batch of log...
Nov 16, 202633Views
0likes
0Comments
A database can have spare CPU and still spend most of its time waiting.
Your application is crawling. You open the Azure portal and CPU is moderate, storage I/O looks fine, worker usage is normal a...
Nov 16, 202638Views
0likes
0Comments
In several support cases I’ve worked on, DBAs wanted to see the history of automated backups for their Azure SQL databases. I start by checking two things the DBAs can verify: the database’s service ...
Nov 14, 2026158Views
1like
1Comment
Azure SQL Database makes scaling compute straightforward. But troubleshooting becomes more complicated when several things happen simultaneously:
A scale operation remains IN_PROGRESS.
A cancel...
Oct 27, 2026195Views
0likes
0Comments
A growing Change Tracking table is a symptom. The useful question is whether cleanup is slow, blocked, or behaving as configured.
Change Tracking is a lightweight mechanism for applications tha...
Oct 27, 2026182Views
0likes
0Comments
A database can recover in seconds while an application remains unavailable for much longer.
Brief connectivity interruptions are expected failure modes that cloud applications should be designe...
Oct 27, 2026196Views
0likes
0Comments
Tags
- azure sql database197 Topics
- AZURE SQL DB94 Topics
- azure sql71 Topics
- performance62 Topics
- Connectivity57 Topics
- azure sql managed instance22 Topics
- azure22 Topics
- AzureSQL21 Topics
- troubleshooting19 Topics
- powershell18 Topics