Keep CDC cleanup and capture jobs healthy by checking log reuse, job settings, retention, polling, and a stopped-job alert.
Auditing SELECT Statements on Sensitive Tables
Auditing SELECT statements on sensitive tables needs a narrow database audit, protected files, volume checks, and active review.
Rotating the TDE Certificate
Rotating the TDE certificate protects recovery only when the new private key is backed up and old backups still restore.
Finding the Real Error Behind an SSMS Dialog
Finding the real error behind an SSMS dialog starts with technical details, inner exceptions, and a safe query-window reproduction.
Finding Databases Nobody Uses
Finding databases nobody uses requires index activity, connection samples, job searches, and owner evidence before an offline trial.
Finding Unused Logins and Users Before an Audit
Review unused logins with password metadata, database mappings and activity capture, then use an owner approved disable-first plan.
Color-Coding Production Connections in SSMS
Color-coding production connections in SSMS adds a visual warning, while an identity query confirms the real destination.