Calculate period-to-date totals with shared scan boundaries, Monday-based weeks, and older date arithmetic for SQL Server reports.
Schema Changes History Report: See Who Dropped a Table
The Schema Changes History report shows who created, altered or dropped a table. This post reads the same default trace with T-SQL, tests it on a table and a database drop, and explains the limits: file rollover and shared logins. It ends with ways to keep the history longer.
SQL SERVER – Reporting Services Not Starting After Maintenance Window
Reporting Services not starting after maintenance? On my lab server every SQL service came back except SSRS. Here is what the log showed.
In-Memory OLTP Migration Checklist in SSMS: Step by Step
The In-Memory OLTP migration checklist shows which tables and stored procedures can move to memory-optimized objects. This post sizes up the tables with T-SQL, walks through the wizard in Management Studio and explains how to read the reports.
SQL SERVER – The Report Server Cannot Open a Connection to the Report Server Database. (rsReportServerDatabaseLogonFailed)
A report viewer failed with rsReportServerDatabaseLogonFailed: the report server cannot open a connection to the report server database. Here is the fix.
SQL SERVER – Activity Monitor – Active Expensive Queries
A DBA spotted an extra pane in my Activity Monitor during a health check. Here is where Active Expensive Queries shows up and which SSMS version has it.
Pareto Analysis in T-SQL: Which Products Make 80 Percent of Sales
Build Pareto analysis in T-SQL with product totals, stable running sums, and explicit ABC thresholds that handle ties and boundary choices.