Locate the system_health file target, read its retained events with T-SQL, and inspect serious errors, connectivity records and waits.
SQL Server Audit: Tracking Who Read or Changed Sensitive Tables
Configure SQL Server Audit for reads and changes, inspect file records by user and time, and plan retention and target failures.
Documenting SQL Agent Jobs: Schedules, Steps and Owners in One Query
Start documenting SQL Agent jobs with owners, steps, readable schedules and retained run outcomes, then save a reviewed inventory document.
Tail-Log Backup: Saving the Last Transactions Before a Restore
Take a tail-log backup before an approved restore, understand NORECOVERY and damaged-database options, and rehearse the full recovery chain.
Refreshing a Test Database From Production Safely
Plan refreshing a test database with isolated restores, safe paths, user repairs, data replacement, disabled outbound actions, and a log.
A Performance Counter Baseline Saved to a Table Every 15 Minutes
Save a performance counter baseline every 15 minutes, calculate interval rates, detect resets, and compare a defined week with last month.
Finding Dead Code: Stored Procedures Nobody Calls
Investigate dead code with cached procedure statistics, dependency checks and retained snapshots, then quarantine candidates before removal.