Spot Agent jobs that run longer than usual by decoding msdb duration, comparing recent runs, and checking jobs still active now.
Doing Remote DBA Work Well
Remote DBA work succeeds with controlled access, current runbooks, agreed change windows, and communication that makes every action visible.
A Simple Dashboard From DMVs
A dashboard from DMVs can show live requests, database state, waits, and backups when its queries refresh without adding load.
Collecting Server Facts Into One Table Every Night
Collect Server Facts each night to track SQL Server versions, settings, databases, and file sizes in a practical history table.