SQL Code Smells: Unindexed Range Predicates
When a query filters a large table on a range, like a date window, and no index supports that range, SQL Server scans the table.… Read More »SQL Code Smells: Unindexed Range Predicates
Mitchell Glasscock
Database Health Monitor Version 4 Has Been Released
We’re excited to announce that Database Health Monitor Version 4 is now available! Version 4 represents one of the biggest updates to Database Health Monitor… Read More »Database Health Monitor Version 4 Has Been Released
Logical Reads vs. Physical Reads
If you’ve spent time tuning SQL Server queries, you may have seen these two numbers side by side: logical reads and physical reads. Maybe you… Read More »Logical Reads vs. Physical Reads
What’s New in Database Health Monitor – August 2026 Release
Version 1458 is now available. The headline addition is the new tray icon and Windows service, which lets you set up historic monitoring on servers… Read More »What’s New in Database Health Monitor – August 2026 Release
SQL Code Smells: Non-Parameterized Queries
Your SQL Server is running hot. CPU is elevated, the plan cache is bloated, and queries that should be instant are taking seconds. You look… Read More »SQL Code Smells: Non-Parameterized Queries
The Affordable SQL Server Monitoring Tool
If you’re a DBA or SQL Server professional shopping for a monitoring tool, you’ve probably experienced sticker shock. Many SQL Server monitoring tools on the… Read More »The Affordable SQL Server Monitoring Tool