Tag: Features
-
DBA Scripts: Get Query Store Status
🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Performance & Troubleshooting › Query & Performance Tuning Query Store is the single most useful diagnostic feature SQL Server has shipped in the last decade, a built-in, per-database history of every query’s plans and runtime stats, no third-party tooling required. And it fails…
Written by
-
DBA Scripts: Get Service Broker Health and Database Mail Queue
🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Server & Configuration Two Messaging Systems That Run Quietly Until They Don’t Service Broker and Database Mail are both messaging infrastructure, and both are easy to forget. Database Mail itself runs on Service Broker in msdb, and it sits idle until something needs…
Written by
-
DBA Scripts: Get Collation Conflicts and Cross-Database Dependencies
🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Server & Configuration Check for Collation Mismatches and Dependencies Before a migration, rename, or decommission, run Get-CollationConflicts on the target instance and Get-CrossDatabaseDependencies in every database whose objects may reference the one being changed. The first compares online database collations with the server…
Written by
-
DBA Scripts: Get Compression Candidates
🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Storage & Capacity Where Compression Actually Pays Off Row and page compression trade CPU for storage and I/O, and that trade is worth making on some tables and not others. The biggest, least-frequently-updated tables are usually the best candidates: maximum space and I/O…
Written by
-
DBA Scripts: Get CDC and Change Tracking
🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Server & Configuration Two Features, Same Risk: They Both Grow the Transaction Log Change Data Capture and Change Tracking answer a similar question, “what changed and when,” for two different audiences, ETL/replication consumers for CDC, application-level conflict detection for Change Tracking. They’re unrelated…
Written by
- Cannot Connect to WMI Provider: SQL Server Configuration Manager Will Not Open
- SQL Server Configuration Manager: Where to Find It and What a DBA Uses It For
- DBA Scripts: Get Failed Login Summary
- Query Was Fast Yesterday, Slow Today: Find What Changed
- The Current Transaction Cannot Be Committed (Error 3930)
- Sort and Hash Spills to TempDB: Find the Query and Fix the Grant
- Backups & Recovery (17)
- DBA Scripts (154)
- High Availability (HA) (13)
- Installation & Configuration (58)
- Maintenance (25)
- Migration & Upgrades (14)
- Monitoring (9)
- Performance Tuning (37)
- Security (Encryption & Permissions) (23)
- Storage & Capacity (17)
- T-SQL Fundamentals (15)
- Troubleshooting (102)
- Wait Types (236)