SQL Server DBA Field Notes
Guides and scripts for diagnosing and running SQL Server in production.

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

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

DBA Scripts
Production-ready SQL Server scripts for diagnostics, monitoring, safety checks, maintenance, and auditing.
Latest Posts
Tags
Database Backups & Recovery (10) Database Maintenance (5) DBA Tools (17) Performance Troubleshooting (4) PowerShell (4) Query Behaviour (4) Schema Changes (1) SQL Agent (1) SQL Interview Questions (1) SQL Scripts (13) SQL Server Administration (1) SQL Server Configuration (4) SQL Server Errors (2) SQL Server High Availability (1) SQL Server Internals (3) SQL Server Management Studio (SSMS) (7) SQL Server Monitoring (6) SQL Server Networking (7) SQL Server Replication (1) SQL Server Security (3) SQL Server Versions (2) Storage and Capacity (10) T-SQL (6) Transaction Logs (6) Troubleshooting (4) Windows Server (4)
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.
