Status rows hold timestamps, not durations. I use LEAD to measure each step, keep unfinished steps NULL, and show why zero ruins your averages.
Offloading Reports to a Readable Secondary
Readable secondary replicas can serve reports away from a SQL Server primary; learn routing, lag, licensing, and query differences to test.
Standard Reports in SSMS: SQL in Sixty Seconds #016
Standard Reports in SSMS put activity, space and performance information a few clicks away. This post adds T-SQL queries for the same questions, tested on SQL Server 2025, and shows the permission error a reader without VIEW SERVER PERFORMANCE STATE receives.
Row-Level Security for Reports
Use SQL Server row-level security for reports with predicate functions and SESSION_CONTEXT, and test every identity boundary.
Fiscal Years That Do Not Start in January
Compute fiscal years and quarters from an April start, build indexed date boundaries, and store a fiscal calendar for repeatable reports.
Percent of Total With SUM() OVER() in One Query
Calculate percent of total with SUM() OVER(), group and running shares, safe numeric division, and checks for zero totals.
SQL SERVER – Configure Management Data Collection in Quick Steps – T-SQL Tuesday #005
A visual walk through to configure Management Data Collection in a few quick steps and get default reports on CPU, memory and disk for your server.







