An upgrade checklist that fits on one page keeps before, during, and after checks visible, including backups, logins, jobs, clients, and rollback.
Restoring a Backup From an Older SQL Server Version: What Changes
Restore a backup from an older SQL Server into a test database, read the upgrade messages, and check compatibility and integrity.
Keeping Personal Data Out of Test Databases
Keeping personal data out of test databases requires synthetic records or masking during refresh, plus verification before access.
SQL SERVER – Delete Backup History – Cleanup Backup History
SQL Server keeps backup history in msdb forever. Use sp_delete_backuphistory to delete backup history older than 30 days, or any number you pick.
Handing Over a Database to Another Team
Handing over a database should include a current map, tested recovery path, access transfer, open risks, and a defined support period.
The Tools a DBA Installs on Day One
The tools a DBA installs on day one include SSMS, command line utilities, a checked script library, and managed source control.
SQL SERVER – Behind the Scene of SQL Server Activity of – Transaction Log – Shrinking Log
Why does an LDF file keep growing even with hourly log backups? Imran Mohammed explains what goes on behind the scene of the Transaction Log and shrinking.