Category: DBA Scripts

  • DBA Scripts: SQL Server Maintenance Job Framework

    🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Maintenance & Automation If you’re already running Ola Hallengren’s maintenance solution, this framework won’t replace it, but the approach might still be useful: three small, readable T-SQL generator scripts that build the same category of scheduled job framework, full and log backups, backup…

    Written by

    Peter Whyte

  • DBA Scripts: Generate Index Maintenance Jobs

    ,

    🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Maintenance & Automation › Maintenance Job Framework A Readable Generator for Index Rebuilds and Statistics Updates If you’re already running Ola Hallengren’s maintenance solution, this won’t replace it, but the approach here might still be useful: a small, readable T-SQL generator that builds…

    Written by

    Peter Whyte

  • DBA Scripts: Index Maintenance

    ,

    🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Maintenance & Automation Index problems rarely announce themselves. A missing index shows up as a slow query someone eventually complains about; a duplicate or unused one just sits there costing write overhead and storage with nothing to show for it; fragmentation quietly degrades…

    Written by

    Peter Whyte

  • DBA Scripts: Blocking and Locking

    ,

    🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Performance & Troubleshooting “The database is slow” and “the database is blocked” look identical from the outside, timeouts, a frozen application, users complaining, and the fix is completely different depending on which one it actually is. Four scripts on this site cover a…

    Written by

    Peter Whyte

  • DBA Scripts: Generate Backup and Restore Scripts

    ,

    🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Backup & Recovery Stop Hand-Typing Database Names Into Backup Commands Writing a one-off BACKUP DATABASE or RESTORE DATABASE command for a single database is trivial. Doing it correctly for every database on an instance, with a consistent naming convention, the right options, and…

    Written by

    Peter Whyte

  • DBA Scripts: Backups and Recovery

    ,

    🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks. Backup and recovery is the one area of SQL Server administration where “probably fine” isn’t good enough, a backup you haven’t verified restores is a belief, not a backup. Twelve scripts across this site cover the whole lifecycle: what recovery model each database…

    Written by

    Peter Whyte

  • DBA Scripts: Get Open Transactions

    ,

    🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Performance & Troubleshooting › Blocking & Locking The Transaction Nobody Remembered to Close An open transaction that never commits or rolls back is one of the quietest ways SQL Server gets into trouble: it holds locks other sessions wait on, it stops the…

    Written by

    Peter Whyte

  • DBA Scripts: Get Recovery Model Audit

    ,

    🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Backup & Recovery The Mismatch That Fills a Disk A database’s recovery model is a promise about what kind of restore is possible, FULL and BULK_LOGGED promise point-in-time recovery, backed by log backups; SIMPLE promises none, and truncates the log on its own.…

    Written by

    Peter Whyte

  • DBA Scripts: Get Login Migration Parity

    Counting logins passes a broken migration. Compare SIDs, disabled state, default database and password policy between two SQL Servers.

    Written by

    Peter Whyte

  • DBA Scripts: Get Log Reuse Waits

    ,

    🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Storage & Capacity The One Question That Actually Matters A transaction log that won’t truncate and keeps growing, or a log backup job that suddenly can’t keep up, always comes back to the same underlying question: what is this database’s log actually waiting…

    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