Production SQL Server Engineering
SQL Server DBA engineering notes from real production environments.
Practical scripts, operational runbooks, troubleshooting workflows, and performance diagnostics focused on reliability, observability, backups, HA/DR, and day-to-day database operations at scale.
Built for DBAs and engineers who need actionable information quickly, not generic documentation.
Written by Peter Whyte – Senior SQL Server DBA.
Outside Europe? View international editions.
Categories
DBA Operations
Incident response, failovers, backup failures, login and connectivity issues. Production troubleshooting and recovery.
DBA Engineering
Availability Groups, latency analysis, storage design, performance tuning, and HA/DR architecture.
DBA Scripts
Production-safe SQL Server scripts for diagnostics, monitoring, security checks, and auditing.
Latest Posts
More About The Author
I’m a SQL Server DBA working in large-scale production environments, focused on reliability, performance, and keeping systems running when they matter most. Most of my day to day work sits around operations, incident response, platform engineering, and automation, supporting SQL Server workloads that need to stay available and predictable under real pressure.
This site is a collection of practical DBA notes I’ve built up over years of working with SQL Server. It’s written for people who already run systems, not for tutorials or marketing. The posts here reflect how I actually work, what I check first, and the things that tend to cause problems in production if they’re misunderstood or ignored. For more background and non-DBA writing, see peterwhyte.com.