Author: Peter Whyte
-
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
-
Instant File Initialization: What It Actually Does and How to Enable It
Instant File Initialization is one of the few SQL Server settings that’s genuinely free performance, no license cost, no downside for the overwhelming majority of installs, and it’s still routinely left unconfigured on real production servers because it’s a Windows privilege grant, not a SQL Server setting, and it happens outside SSMS entirely. This post…
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
-
Disable Change Data Capture in SQL Server
Disabling Change Data Capture (CDC) is straightforward, but it has to happen in the right order: every tracked table first, then the database. Skip a step and SQL Server tells you plainly rather than doing it anyway, which is the safe behaviour but confusing the first time you hit it. This post covers disabling CDC…
Written by
-
SET Options Have Incorrect Settings (Error 1934)
SQL Server error 1934 means the connection running the write has the wrong SET options for a filtered index or indexed view. Reads still work, which is why it usually shows up as one failing job.
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
-
JSON in SQL Server: OPENJSON, FOR JSON, and the Native JSON Type
SQL Server has had JSON functions since 2016, and SQL Server 2025 added a native JSON data type on top of them. Most write-ups explain the syntax; fewer show what actually differs between storing JSON as text and storing it as the native type, or when reaching for JSON in a relational database is the…
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
- DBA Scripts: Get Log Shipping Status
- 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
- Backups & Recovery (17)
- DBA Scripts (152)
- High Availability (HA) (13)
- 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)