Author: Peter Whyte

  • DBA Scripts: Get Error Log Patterns

    ,

    🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Performance & Troubleshooting Group the Error Log Instead of Scrolling It The SQL Server error log is where the instance tells you what’s wrong, but on a busy server it’s also where hundreds of routine startup, backup, and checkpoint messages bury the handful…

    Written by

    Peter Whyte

  • DBA Scripts: Get Edition Feature Usage

    ,

    🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Server & Configuration › Server Inventory What Actually Breaks If You Downgrade This Instance Edition downgrades, Enterprise to Standard, Standard to Web, look simple until you discover a feature that only Enterprise supports has quietly been in use the whole time. TDE-encrypted databases…

    Written by

    Peter Whyte

  • DBA Scripts: Maintenance and Automation

    🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks. Is the Automation Healthy, and Is It Actually Doing the Job A SQL Agent job that silently stopped running is one of the quietest failure modes in SQL Server, nothing errors, nothing alerts, the work it used to do just stops happening until…

    Written by

    Peter Whyte

  • DBA Scripts: Performance and Troubleshooting

    🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks. Something is slow · the investigation You are past the point of guessing. This pillar is the middle step: turning “it feels slow” into a named, evidenced cause before you change anything. Look up the wait type Pick a diagnostic scriptYou are here…

    Written by

    Peter Whyte

  • DBA Scripts: Server and Configuration

    🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks. What This Server Is, and How It Got That Way Two pillars, one underlying question: before performance, before security, before anything else, what is this SQL Server instance, and how did it come to be configured the way it is. Server Inventory answers…

    Written by

    Peter Whyte

  • DBA Scripts: Collectors and Baseline Infrastructure

    🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Maintenance & Automation From “Check When Asked” to “Already Watching” Every other pillar on this site answers a question the moment you ask it: what’s blocking right now, what are the current wait stats, how much free space is on disk today. The…

    Written by

    Peter Whyte

  • DBA Scripts: Generate Collector Alerts

    ,

    🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Maintenance & Automation › Collectors & Baselines Alert on What Your Collectors Find Your collectors fill tables every few minutes and nobody reads them. Generate-CollectorAlertJob.sql writes one SQL Agent job that checks the latest collector data every 30 minutes, lists every CRITICAL and…

    Written by

    Peter Whyte

  • DBA Scripts: Get Patch Level

    ,

    🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Server & Configuration › Server Inventory Building a Patch Compliance Inventory Across an Estate Version and Edition answers “what is this one instance running” as a quick single-server snapshot. This script answers a related but different question: run it across every server you…

    Written by

    Peter Whyte

  • DBA Scripts: Collect Health and Configuration Baselines

    ,

    🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Maintenance & Automation › Collectors & Baselines Four Collectors, Four Different Rhythms AG health every few minutes if you’re running Availability Groups, index fragmentation weekly, Query Store’s top queries every 30 minutes, error log entries every 10. Each script below is a generator:…

    Written by

    Peter Whyte

  • DBA Scripts: Get Transaction Log Size and Usage

    ,

    🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Storage & Capacity Understanding Transaction Log Size Usage Keeping an eye on transaction log usage is one of the simplest ways to prevent unexpected database outages. When a transaction log fills, SQL Server cannot continue writing transactions, backups begin failing, applications stop processing…

    Written by

    Peter Whyte
Major pillars
DBA Scripts180+ scripts, one page each SSMS Complete GuideInstall, shortcuts, git, Copilot, dark mode Error LibraryLook up an exact message, cause and fix Wait Types LibraryWhat the server was waiting on
Find a script
Find a ScriptSearch by name, or browse every script page DBA Scripts: The Complete GuideHow the series works, read end to end
Health check & tooling
Full Health CheckCollect 45 diagnostics, apply rules, then an AI assessment sqldba MCP ServerGive an AI assistant a verified SQL Server reference
Script areas
Server & Configuration Storage & Capacity Backup & Recovery High Availability Performance & Troubleshooting Security Maintenance & Automation Migration & Deployment
Latest posts
Browse by topic