How to Find Offline Database Files in SQL Server
See offline database files, growth settings, and volumes for every database on an instance, even ones that are offline, restoring, or suspect.
2026
Recovering from a ransomware attack
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
Recovering from accidental data deletes
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
A password protected SSIS package can stall a migration for days. Here is how to find every one hiding inside msdb first.
Why Your Management Data Warehouse Stopped Updating
A management data warehouse can stop updating while its Agent jobs still show green. Here’s where SQL Server keeps the real failure text.
What a SQL Server Index Health Score Really Tells You
SQL Server index health is more than a fragmentation percentage: one score with its reasons, backed by ten indexing reports rolled into cards.
SQL Server Index Fragmentation: Stop Chasing the Percent
SQL Server index fragmentation percentage can be misleading. Here is the number that actually predicts what a rebuild will buy you, and where to find… Read More »SQL Server Index Fragmentation: Stop Chasing the Percent
SQL Server LOB Columns in Indexes Are Costing You Disk
SQL Server LOB columns in indexes duplicate data on disk. Here’s how to find every one, measure the cost, and know which are safe to… Read More »SQL Server LOB Columns in Indexes Are Costing You Disk
Database Health Monitor V4 Stedman SQL Podcast Sn 3 Ep 14
Stedman SQL Podcast Sn 3 Ep 14 Database Health Monitor Version 4 Database Health Monitor Version 4 is here, and it’s one of the biggest… Read More »Database Health Monitor V4 Stedman SQL Podcast Sn 3 Ep 14
Backup and recovery for SQL Server
As a database professional, you know how critical it is to have a solid backup and recovery plan in place for your SQL Server environment.… Read More »Backup and recovery for SQL Server