Audit the model database template for recovery model, options, objects, and file size, then verify growth settings on new databases.
Finding Orphaned Data and Log Files Nobody Attached
Inventory orphaned data and log files by comparing data-folder contents with sys.master_files, then review candidates before cleanup.
Rehearsing a master Database Restore on a Test Instance
Rehearse a master database restore on a matching test instance, including single-user sqlcmd, automatic shutdown, and configuration checks.
Waiting for an Agent Job to Finish Before the Next Step Runs
Wait for an Agent job to finish by polling its current sysjobactivity row, enforcing a timeout, and checking sysjobhistory outcome.
Piecemeal Restore: Bringing the Primary Filegroup Online First
Rehearse a piecemeal restore that brings PRIMARY and current data online first, then restores archive filegroups with the right log chain.
Maintaining SharePoint Content Databases: What the DBA Still Owns
Review SharePoint content databases for CHECKDB, backup history, log growth, recovery model, and a tested site-collection restore.
Running a Command in Every Database Without sp_MSforeachdb
Run a checked command in every database with a FAST_FORWARD cursor, AG role filter, QUOTENAME, and per-database error log.