Tag: Server Inventory
-
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
Major pillars
Find a script
Health check & tooling
Script areas
Latest posts
- Add a Filegroup to a SQL Server Database
- Set the Default Database for a SQL Server Login
- SQL Server High CPU: What to Check First, in Order
- Cannot Connect to SQL Server: The Checks in the Order That Finds It
- Cumulative Wait Stats Lie: Measuring Waits Over an Interval
- SQL Server Differential vs Log Backup: Which One Restores What, and How the Chain Breaks
Browse by topic
- Backups & Recovery (17)
- DBA Scripts (150)
- High Availability (HA) (12)
- Installation & Configuration (45)
- Maintenance (24)
- Migration & Upgrades (14)
- Monitoring (9)
- Performance Tuning (37)
- Security (Encryption & Permissions) (19)
- Storage & Capacity (15)
- T-SQL Fundamentals (11)
- Troubleshooting (65)
- Wait Types (235)