Category: DBA Scripts
-
DBA Scripts: Enable or Disable All SQL Agent Jobs
Turning every SQL Agent job off is easy. Turning the right ones back on is where it goes wrong. Save the state first, disable with sp_update_job, restore from what you saved, and know why disabling does not stop a running job.
Written by
-
The sqldba MCP Server: Give Your AI Assistant a Verified SQL Server Reference
The reference behind this site, as six tools an AI assistant can call: error numbers, wait types, patch levels and scripts, hand-verified rather than scraped. It never connects to your SQL Server, and it refuses rather than guessing.
Written by
-
DBA Scripts: Migration and Deployment
🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks. A SQL Server migration fails in two places: before it starts, when nobody checked whether the workload even fits the target, and after it finishes, when logins don’t match, users are orphaned, and the first Monday morning proves the move wasn’t as done…
Written by
-
DBA Scripts: SQL Server Change Management
🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Migration & Deployment Change window open and you need the checklist or the rollback criteria now? Start Here goes straight to them. The rest is the paperwork either side of the window: how a change gets approved, proved safe before you start and…
Written by
-
DBA Scripts: Get Database Summary
🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Server & Configuration › Server Inventory One Row Per Database, Every Issue Flagged in One Column Checking every database on an instance one at a time, state here, recovery model there, backup age in a third window, doesn’t scale, and it’s exactly the…
Written by
-
DBA Scripts: Get Database Inventory
🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Server & Configuration › Server Inventory One Query, Every Database’s Migration Readiness Before you migrate, upgrade, or consolidate anything, you need one honest answer per database: is it actually online, what recovery model is it running, and is its compatibility level going to…
Written by
-
DBA Scripts: Pre-Install and Post-Install Checks for SQL Server
🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Server & Configuration › Installation & Patching Start Here Will this build actually run here?OS and Hardware InfoWhat did the installer leave at defaults?Configuration SnapshotHow does the finished build score?Configuration ScoreWhat are the install steps themselves?Install and Configure Bookend Checks for an Installation…
Written by
-
DBA Scripts: Generate Database Integrity and Housekeeping 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 Integrity Checks and msdb Housekeeping No DBCC CHECKDB has run in weeks, msdb keeps growing, or the error log is one enormous file: this generator writes the 3 SQL Agent jobs that…
Written by
-
DBA Scripts: Generate Backup 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 Full Backups, Log Backups, and Cleanup 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…
Written by
-
DBA Scripts: Run a Full SQL Server Health Check
🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Maintenance & Automation › Collectors & Baselines Inherited a server, or sure something is wrong but not what? One command runs 45 read-only checks against the instance. A second turns the results into a ranked CRITICAL / WARNING / INFO list. An optional…
Written by
- SQL Server Row-Level Security: The Filter Does Not Stop Cross-Tenant Writes
- View the Definition of a Stored Procedure in SQL Server
- TempDB Is Full or Still Growing: Find What Is Using It, Right Now
- SQL Server Service Will Not Start: Error 17113, 17058, 1067 and Where the Real Reason Is
- How to Move TempDB Files in SQL Server
- RAND() vs NEWID() in SQL Server
- Backups & Recovery (17)
- DBA Scripts (151)
- High Availability (HA) (12)
- Installation & Configuration (49)
- Maintenance (25)
- Migration & Upgrades (14)
- Monitoring (9)
- Performance Tuning (37)
- Security (Encryption & Permissions) (20)
- Storage & Capacity (16)
- T-SQL Fundamentals (15)
- Troubleshooting (94)
- Wait Types (235)