Is this index still used? A lifetime read count cannot say. Here is how a per-index trend line catches an index that went silent weeks… Read More »Is This Index Still Used? Read the Trend, Not the Total
Our Backup and Restore Course is designed to give you a comprehensive understanding of SQL Server backup strategies, restoration processes, and best practices. Whether you’re… Read More »Backup and Restore Course Overview
Most SQL Server maintenance window schedules are typed in once and never checked. Here is how to measure the quiet hours instead of guessing at… Read More »Your SQL Server Maintenance Window Is a Guess. Measure It
Hello everyone, today, I want to talk about something near and dear to my heart: SQL Server backups. Trust me when I say that having… Read More »Why Your SQL Server Backups Are More Crucial Than You Think: Lessons from the Frontlines
Why is one execution plan slower than another for the same SQL Server query? See which Query Store measures explain the gap, not just duration.
See offline database files, growth settings, and volumes for every database on an instance, even ones that are offline, restoring, or suspect.
Recovering from a ransomware attack is a crucial aspect of backup and recovery for SQL Server, and it deserves a closer look. Ransomware attacks have… Read More »Recovering from a ransomware attack
Our Backup and Restore Course is designed to give you a comprehensive understanding of SQL Server backup strategies, restoration processes, and best practices. Whether you’re… Read More »Recovering from accidental data deletes
A password protected SSIS package can stall a migration for days. Here is how to find every one hiding inside msdb first.
A management data warehouse can stop updating while its Agent jobs still show green. Here’s where SQL Server keeps the real failure text.
