Restore a TDE protected database on another SQL Server by moving its certificate and private key, then verify encryption state.
Ordering a Maintenance Window: Backups, CHECKDB and Index Work
Order a maintenance window by listing Agent schedules, separating CHECKDB, backups, index work, and statistics, then tracking growth.
SQL SERVER – Move Database Files MDF and LDF to Another Location
Your new database sits in the default location and keeps growing. Here is how to move the MDF and LDF database files to another disk or drive.
FileTable: Files You Can Open in Explorer and Query in T-SQL
Set up FileTable prerequisites, create a Windows-accessible file namespace, query stored file metadata, and compare simpler path storage.
Backing Up msdb: Jobs, History and Mail Live There
Your user databases come back, but the jobs and mail setup do not. A short demo of what lives in msdb and how to protect it.
Keeping a Patch Test Environment Honest
A Patch Test Environment must match production data, settings, jobs, and versions closely enough to reveal real patch risks.
Moving From LocalDB to a Real Instance
Moving from LocalDB to a server instance takes a tested backup and restore, new connection strings, mapped logins, and a collation check.