Performance tips, security advisories, health check findings, and industry analysis. Practical, technically accurate, no fluff.
Practical SQL Server performance tuning techniques for developers, drawn from 20 years of consulting work across real client environments.
Read article →When SQL Server slows down, wait statistics reveal exactly where the problem is hiding. Learn how to query DMVs to diagnose performance issues quickly.
Read article →Use SQL Server's plan cache DMVs to surface full table scans, missing indexes, and columns with no statistics without running a trace or waiting for an incident.
Read article →Identify exactly where your SQL Server is struggling using the Perfmon counters experienced DBAs rely on first for memory, disk, locking and CPU diagnostics.
Read article →Learn how to use SQL Server's missing index DMVs to identify index gaps that are quietly draining CPU and I/O from your production environment.
Read article →Learn how to query SQL Server index fragmentation using DMV views and identify which indexes need rebuilding or reorganising to restore query performance.
Read article →Five field-tested DMV queries that give you immediate visibility into SQL Server performance, from procedure execution frequency to wait statistics and plan cache health.
Read article →When your SQL Server is running hot, knowing which queries are responsible is the first step. This script uses DMVs to surface the top 50 queries by average CPU time.
Read article →Blocking processes can cascade and cripple SQL Server performance within minutes. Learn how to find them quickly and act on what you find.
Read article →Learn how to read SQL Server wait statistics and identify the wait types that actually matter, with inline descriptions built into the query result set.
Read article →Learn how to find your longest running SQL Server queries using sys.dm_exec_query_stats, so you can identify the top resource consumers and fix performance problems fast.
Read article →Running with SQL Server's default autogrowth settings is quietly hurting your performance. Learn how to bulk-update file growth settings across all databases using a single T-SQL script.
Read article →Performance tips, security advisories, and industry analysis. No fluff, no spam.