Read Azure SQL Database wait stats with sys.dm_db_wait_stats, identify log-rate governance, and compare resource percentages before scaling.
Finding Hot Tables With sys.dm_db_index_usage_stats
Identify hot tables with index usage, lock and latch counters, table sizes, and retained snapshots that describe a real workload interval.
What Is a Data Type, and Why the Wrong One Costs You
A data type decides what a column holds, what it costs in bytes, and how SQL Server compares it. Why NVARCHAR doubles your storage, why float will not compare cleanly, and the conversion that quietly kills an index.
FORMAT vs CONVERT: The CPU Cost of Pretty Dates
FORMAT makes dates look nice, but it costs CPU on every row. Here is the gap, and where it hurts most.
Delayed Transaction Durability Explained: SQL in Sixty Seconds #074
Delayed transaction durability lets a commit return before its log record reaches the disk. This post explains the idea and the three settings, then measures 10,000 small transactions on SQL Server 2025 and shows the one risk with a log write count. It ends with a simple rule for using it safely.
Example of Delayed Durability: How Much Faster Are Commits?
This example of delayed durability runs 50,000 small transactions on SQL Server 2025 four ways and compares time and log writes. It shows what the database setting and the commit option change, and what you risk.
Live Execution Plan of a Running Query: SQL in Sixty Seconds #073
A live execution plan shows how far a query has gotten while it is still running. This post builds a slow query on SQL Server 2025, watches it through sys.dm_exec_query_profiles from a second window, and explains why rows divided by the estimate is a progress meter only when the estimate is right.