A change log for every database records what changed, when, why, and by whom, with a simple table and a habit of updating it.
Monitoring Log Growth and VLF Counts
Monitor VLF counts and transaction log growth with SQL Server DMVs, then choose file growth settings that keep recovery and maintenance predictable.
Assessing a Database Before a Migration
Assessing a database before a migration covers features in use, compatibility, size, dependencies, and the evidence needed before a date is promised.
SQL SERVER – SHRINKDATABASE For Every Database in the SQL Server
A query tuning visit turned into a lesson on why running SHRINKDATABASE for every database is a bad idea. Here is what happened at the client’s office.
Documenting a Server You Just Inherited
Documenting a server you just inherited starts with identity, databases, files, jobs, access, alerts, and tested recovery ownership.
Monitoring Availability Group Health
Monitor availability group health through replica connection state, database synchronization, send and redo queues, and failover readiness checks.
SQL Tips – 5 SQL Server Best Practices
5 SQL Server Best Practices worth a quick check, starting with backing up the master database and testing it, and rebuilding indexes online to cut downtime.