Tag: Encryption
-
DBA Scripts: Get Certificates, Keys, and TDE Status
🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Security The Encryption Layer Nobody Monitors Until It Expires Certificates created for TDE, backup encryption, or an Availability Group encrypted endpoint get created once and then quietly forgotten. An expired certificate doesn’t break TDE in memory on the server that has it, but…
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)