10 - 2026 - Database Health Monitor

Halloween pumpkins in the forest

Uncategorized

Happy Halloween

Steve Stedman Oct 31, 2026

As the jack-o’-lanterns glow and the costumes come out, Halloween brings its share of thrills and chills. But here at Stedman Solutions, we’re declaring one thing off-limits for scares: SQL Server. That’s right—your databases don’t need to be spooky on October 31st, or any other day. Think about it. Ghosts in the machine? Haunting query errors that appear out of nowhere? Those are the real horrors we banish with solid SQL Server management. No need for exorcisms when you have …

Happy Halloween Read more →

Database Health Monitor

Database Health Monitor 4.1796: 28 New Reports for Finding the Queries That Cost You

Steve Stedman Oct 27, 2026

Version 4.1796 adds 28 query tuning reports, the Query Card, an active blocking alert, tray application help and 649 fixes.

Uncategorized

Blocking Query Monitor – Part of Database Health

Steve Stedman Oct 25, 2026

Hello everyone, today, I’m excited to share with you a feature of the Database Health Monitor software that I’ve developed: The Blocking Query Monitor. Watch this video by Steve Stedman to find out more. Understanding and addressing performance bottlenecks in SQL Server is not always an easy task, and one of the biggest contributors to these bottlenecks is often blocking queries. That’s why I’ve built the Blocking Query Monitor. The Blocking Query Monitor is a powerful tool specifically designed to …

Blocking Query Monitor – Part of Database Health Read more →

Database Health Monitor

Database Health Monitor 4.1792: Smarter Exports, Server Recovery Pages, Themes and a New Password Policy Check

Steve Stedman Oct 20, 2026

Everything in Database Health Monitor 4.1792: an export that asks what the file contains, a recovery page and tree badges for servers that will not connect, a Theme menu with Follow Windows, accessible 10x controls, a new Quick Scan check for SQL logins with the password policy off, and 527 fixes.

Database Health Monitor

Evaluating a SQL Server Monitor With Sample Data

Steve Stedman Oct 19, 2026

The advice to point a monitor at a real server first is wrong. Here is how sample data, the connect card and the tour work, and what each one does not tell you.

Database Health Monitor

Scalar Function Performance: Read the Blocker Matrix First

Steve Stedman Oct 18, 2026

Improve scalar function performance by reading one screen in the right order: the verdict strip, the blocker matrix, then the grid beneath them.

Database Health Monitor

SQL Server Untrusted Constraint: Why Plans Quietly Rot

Steve Stedman Oct 15, 2026

A SQL Server untrusted constraint breaks nothing and costs you plan quality everywhere. Here is how to find them, rank them and re-check them safely.

Database Health Monitor

Pending RECONFIGURE: Find Settings That Never Took Effect

Steve Stedman Oct 14, 2026

A pending RECONFIGURE means a setting you changed is not the one SQL Server is running. Here is how to spot it, and what else the settings list gives away.

Database Health Monitor

Database Health Monitor 4.1743: Query Tuning Workbench, Backup SLA Policies and 920 Fixes

Steve Stedman Oct 13, 2026

Version 4.1743 adds the Query Tuning Workbench, Backup SLA policies with a compliance report and alert, a Default Trace Events report, safer Quick Scan fixes, easier navigation and 920 fixes.

Database Health Monitor

SQL Server Connections: Who Is on Your Database?

Steve Stedman Oct 13, 2026

Twenty SQL Server connections can be healthy or a leak. Split them into running and sleeping, spot the open transaction and the sa login, then act.

Month: October 2026

Happy Halloween

Database Health Monitor 4.1796: 28 New Reports for Finding the Queries That Cost You

Blocking Query Monitor – Part of Database Health

Database Health Monitor 4.1792: Smarter Exports, Server Recovery Pages, Themes and a New Password Policy Check

Evaluating a SQL Server Monitor With Sample Data

Scalar Function Performance: Read the Blocker Matrix First

SQL Server Untrusted Constraint: Why Plans Quietly Rot

Pending RECONFIGURE: Find Settings That Never Took Effect

Database Health Monitor 4.1743: Query Tuning Workbench, Backup SLA Policies and 920 Fixes

SQL Server Connections: Who Is on Your Database?

Getting Help from Steve and the Stedman Solutions Team