Year: 2025

How Copy-Only Backups Were Hiding Your Real SQL Server Recovery Chain (And Why We Finally Fixed It) Over the past decade of doing health checks, Performance Tuning engagements, emergency recovery calls, and even the occasional “please tell me we have a good backup” midnight panic, one issue shows up more often than almost anything else: total confusion caused by copy-only backups created by VM-level snapshot tools. For years the Backup Status Report inside Database Health Monitor did exactly what every …

Backup Status in Database Health Monitor Just Got a Major Overhaul Read more »

Every year during audit and compliance season, support tickets flood in with the same urgent request: DBAs need a fully automated, hands-off way to generate the same comprehensive SQL Server health reports they create manually in the Database Health Monitor GUI — without ever launching the app. They want a scheduled task that runs at 3 AM (or any interval) to connect to one or many instances, collect all diagnostic data, and deliver a professional report to a shared folder …

Faster, Smarter Automation with the Latest Command-Line Updates in Database Health Monitor Read more »

Grab a blanket and get comfortable. It’s story time with Steve Stedman and Derrick Bovenkamp! In this 10 min video they will share with you database corruption stories. From these stories hopefully you’ll learn what not to do. Things to watch out for to avoid SQL Server corruption. Transcription: Steve Stedman 0:04Let’s roll onto the corruption stories. So the first one we’re going to talk about here was one of the first really big corruption repairs that I did after …

Steve and Derrick – Tales of Database Corruption Read more »

If you’ve ever stared at a slow-running query at 2 a.m. wondering “What setting did I forget this time?”, you’re not alone. Most DBAs and accidental DBAs wear a dozen hats, and SQL Server has hundreds of knobs that can quietly hurt performance, security, or reliability long before anyone notices. That’s exactly why we built DBAssistant inside Database Health Monitor — to act as your always-on virtual senior DBA that never sleeps, never takes vacation, and never sends passive-aggressive emails. …

Unlock Expert-Level SQL Server Optimization with DBAssistant Read more »

Parameter Sniffing and Conditional Logic in SQL Server Stored Procedures: A Performance Pitfall Parameter sniffing in SQL Server stored procedures can be a double-edged sword. On one hand, it allows the query optimizer to create an execution plan tailored to the specific parameter values provided during the initial compilation of the procedure, often resulting in improved performance. On the other hand, this same mechanism can lead to suboptimal plans when the sniffed parameters are not representative of typical workloads, causing …

Parameter Sniffing and Conditional Logic in SQL Server Stored Procs Read more »

Here is a short video on the Job History Chart in Database Health Monitor. Need some help with Database Health Monitor. Check out our classes where you can learn all about Database Health Monitor. For over 14 years, Database Health Monitor has been meticulously developed to deliver unparalleled performance and reliability for your database systems. Now is the perfect time to harness the full potential of this powerful application, designed to streamline monitoring, enhance efficiency, and ensure your databases run …

Job History Chart Read more »

Working with numerical data in SQL Server often requires precise formatting to meet specific display or reporting needs. One common challenge developers face is ensuring that numbers are displayed with leading zeros, especially when dealing with identifiers, codes, or other fixed-length numeric strings. Whether you’re formatting invoice numbers, employee IDs, or product codes, SQL Server provides several methods to achieve this, but the right approach depends on your data type and use case. In this blog post, we’ll explore the …

Formatting Leading Zeros in SQL Server Read more »

Welcome to our deep dive into the world of database management with a focus on Mastering SQL Server Replication. If you’re looking to enhance your skills in managing and distributing data across multiple servers, you’ve come to the right place. SQL Server Replication is a powerful feature that allows you to copy and distribute data and database objects from one database to another, ensuring consistency and availability. Whether you’re a database administrator, a developer, or simply a tech enthusiast, understanding …

Master SQL Server Replication Today Read more »