Build a test server from a script with unattended SQL Server setup, repeatable configuration, and sample data that can be reset after each run.
Diagnosing a Frozen Server With the Dedicated Admin Connection
The dedicated admin connection provides a narrow emergency path to a stalled SQL Server; prepare remote access and keep diagnostics light.
Striped Backups: Writing One Backup to Several Files
Use striped backups across several files, inspect media families, restore every stripe, and test resource settings on your own server.
End of Support: What Actually Stops Working
End of Support does not shut down SQL Server, but it changes security updates, fixes, and help; plan an exit before risk grows.
Restoring a Sample Database to New Folders With RESTORE FILELISTONLY
Use RESTORE FILELISTONLY to map backup files to local folders, restore a separate sample copy, and verify its data and log paths.
When Auto Update Statistics Is Not Enough
Auto update statistics can miss important data patterns; inspect thresholds, ascending keys, sampling, and targeted update schedules.
SQL SERVER – DBA or DBD? – Database Administrator or Database Developer
My poll asked if you are a Database Administrator or Database Developer. Of 694 voters, 63.4% chose developer, so maybe DBD earns a dictionary spot.