SQL Server DBA Field Notes

Production-ready SQL Server scripts, runbooks, and engineering notes for real-world environments. Written by Peter Whyte – Senior SQL Server DBA.

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.



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.

Peter Whyte SQL Server DBA