Turn a business question into a tested T-SQL metric with explicit time zones, cancellations, returns, and a hand-checked sample.
Job Steps That Fail While the Agent Job Reports Success
A green job history does not mean every step worked. Decode the failure routing and pair failed steps with their outcomes.
Who Dropped Your Table? – SQL in Sixty Seconds #112
Who Dropped My Table? – I was recently asked this question in Comprehensive Database Performance Health Check. Let us learn about it today.
User Statistics Report in SSMS: Who Is Connected
The User Statistics report in SSMS shows the users who are connected to a database. This post opens the report, answers the same question with a query over sys.dm_exec_sessions, and finds the one application that holds many sessions.
Year-Over-Year Comparisons in One Query
Build year-over-year monthly comparisons with a complete calendar, LAG, date-aligned joins, safe percentages, and missing-period rules.
Schema Changes History Has No Data: Check Default Trace Enabled
The Schema Changes History report can say it has no data to show. A client saw this message in SSMS. Check that default trace enabled is 1, make a schema change, and run the report again.
Capturing the SQL Behind SSMS Reports With Extended Events
Capture the SQL behind SSMS reports with a filtered Extended Events ring buffer, inspect batch text, and remove the session afterward.







