CDC capture lag measures work committed at the source that the capture process has not yet exposed. Compare known markers, scan sessions and captured LSNs, and distinguish capture progress from a downstream consumer reading the changes.
Your First Extended Events Session
Build your first Extended Events session for slow SQL calls, choose a bounded ring buffer or file target, and read the captured result.
Restart History: Preserve Startup Evidence Before Logs Cycle
Restart history records startup evidence before retained logs disappear. Keep each source and timestamp separate, and test repeat collection with synthetic archives.
A Weekly Routine for SQL Server Administration
A weekly routine for SQL Server Administration checks recovery, failures, capacity, integrity, security, and pending changes in a practical order.
Replacing Profiler Traces With Extended Events
Replacing Profiler traces with Extended Events starts with the question, a focused event session, and a bounded target that avoids needless load.
Standard DBA Reports You Can Write in T-SQL
Standard DBA reports can use T-SQL to show backup age, database sizes, job failures, login changes, and errors in one weekly review.
Tracking Which Updates Every Server Has
Tracking Which Updates each SQL Server runs takes a dated inventory table, SERVERPROPERTY snapshots, and a report of instances behind the target.