Run a resumable index rebuild with ONLINE and MAX_DURATION, pause and resume it, inspect progress, and weigh edition and log costs.
Tracking Recent Object Changes With modify_date
Use modify_date to find recent SQL Server object changes, compare databases, and understand which audit questions need event capture.
Finding Databases With Auto Shrink or Auto Close Turned On
Find auto shrink and auto close settings, generate reviewed correction commands, inspect model, and check the effects of prior shrink work.
Page Restore: Fixing a Few Corrupt Pages Without a Full Restore
Rehearse page restore on a test database, identify damaged page IDs, apply the backup chain, and verify storage and database consistency.
Backing Up MySQL, Explained for SQL Server DBAs
Backing up MySQL means choosing logical or physical copies and retaining binary logs for point-in-time recovery, then testing restores.
Checking Data Type Mapping After a Database Migration
Audit data type mapping after migration, compare counts and checksum screens, inspect length and precision, and reconcile changed values.
Disabling All Agent Jobs During a Freeze and Restoring Their State
Enable-all after a freeze wakes up jobs that were off on purpose. Save the starting state and put back exactly that.