SQL Server DBA Field Notes

Guides and scripts for diagnosing and running SQL Server in production.

SQL Server DBA operations monitoring with performance dashboards and active alerts

DBA Operations

Fixing and operating SQL Server in production: connectivity, services, backups, jobs, and incident response.

SQL Server platform design and architecture planning

DBA Engineering

Designing and improving SQL Server platforms: performance, security, HA/DR, scalability, and reliability.

SQL Server Management Studio with T-SQL script on dual monitors alongside GitHub in a professional DBA workspace

DBA Scripts

Production-ready SQL Server scripts for diagnostics, monitoring, safety checks, maintenance, 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