In my recent YouTube video, I share a practical tip for SQL Server Management Studio (SSMS) users to make their coding workflow more efficient. As someone who mentors developers, I’ve seen how small optimizations can make a big difference, and this trick for commenting and uncommenting code is one I’m excited to teach. It’s a simple technique that saves valuable time, especially when managing large scripts or working in fast-paced database development environments. In the video, I walk through a …

Speed Up Your SQL Workflow: Commenting Code in SSMS Read more →

At Stedman Solutions, we are always working to make SQL Server management easier and more effective. In Database Health Monitor, we have several reports and enhancements that help you better understand what’s happening across your SQL Servers. One of the highlights is the Job History Chart. Viewing job history in SQL Server Management Studio often felt like sifting through fragmented data without much context. With the redesigned job history report, you now get a clear 24-hour view of all jobs …

Job History, Problem Indexes and Backup Reports Read more →

Overview Most Database Health Monitor reports show a snapshot or history. The SQL Performance Monitor (the window is titled Performance Viewer) is the other kind of tool: you point it at one SQL Server, leave it running while a problem happens or a load test runs, and read what it saw during that time. It answers what was blocking, running long, waiting or burning CPU while I was watching? It is a separate program that Database Health Monitor starts for …

SQL Performance Monitor Read more →

For more information on Database Health Monitor you can visit StedmanSolutions.com. You can download the free trial of Database Health Monitor at https://DatabaseHealth.com/download2. Welcome to our deep dive into DB Assistant, a critical component of the Database HealthMonitor suite. As organizations increasingly rely on robust database systems to manage vast amounts of data, ensuring optimal performance and reliability becomes paramount. DB Assistant is designed to be your proactive partner in this journey, offering real-time insights and automated solutions to keep …

DB Assistant – Part of Database Health Monitor Read more →

Database Health Monitor streamlines SQL Server Agent job management by offering a clear, visual way to track job successes and failures in real time. Its intuitive dashboards help you quickly spot trends, identify recurring issues, and troubleshoot problems, ensuring your SQL Server jobs run smoothly across single or enterprise environments. Want to see how it works? Watch our video to explore Database Health Monitor‘s powerful features, from real-time monitoring to trend analysis, and learn how to optimize your SQL Server …

SQL Server Agent Job Management Read more →