Use WITH CHECKSUM for backups, inspect checksum history, verify backup media, and understand why restored CHECKDB tests are still needed.
Point-in-Time Restore: Getting Back Rows Deleted by Accident
Plan a point-in-time restore after an accidental DELETE, preserve the log chain, recover a separate copy, and return reviewed rows.
Restoring One Table: Restore a Copy and Move the Rows Back
Learn restoring one table by restoring a separate database copy, choosing a recovery point, and safely moving reviewed rows back.
SQL SERVER – Parsing SSIS Catalog Messages – Notes from the Field #030
The SSIS Catalog captures a lot of cool information by default. Andy Leonard shares the query he uses for parsing SSIS Catalog messages in SSISDB.
Keeping msdb Small With sp_delete_backuphistory
Use sp_delete_backuphistory to control msdb growth, choose a retention window, and schedule weekly SQL Server Agent cleanup.
SQL SERVER – Database File Names and Extentions – Notes from the Field #025
What is in a name? Plenty, when it comes to database file names and extensions. Tim Radney shares a funny story on why naming standards matter.
Backing Up to Azure Blob Storage
Backing up to Azure blob storage with SQL Server requires scoped SAS credentials, block blob targets, tested striping, and a real restore drill.