Report caching and snapshots in SSRS reduce repeated database work when freshness rules, parameter combinations, and schedules are clear.
SQL SERVER – SQL Server RDL Specification
The RDL Specification describes Report Definition Language, the XML schema behind SQL Server reports. I list the 2000, 2005 and 2008 versions.
A Minimal BI Stack on SQL Server
A minimal BI stack can start with SQL Server tables, stable views, one scheduled load, and one reporting tool that a small team can run.
Resource Governor: Capping a Runaway Report
Capping a runaway report with Resource Governor uses workload groups, pools, and a tested classifier to limit one workload safely.
Dynamic PIVOT: Building Report Columns From the Data
Build a dynamic PIVOT with ordered STRING_AGG and QUOTENAME, parameterized filters, zero-filled results, and explicit report-width limits.
DATEPART Quarter: Keep the Year Beside the Quarter
DATEPART quarter identifies a calendar component. I keep its year when reporting separate periods. A cross-year January case shows how quarter-only grouping combines events.
Weighted Average: Keep Group Totals and Value Counts
A weighted average preserves each group’s contribution. I compare unequal groups before combining their means. Group totals and populated-value counts reconstruct the underlying average without treating missing readings as zero.