Like a car’s dashboard, the SSMS Server Dashboard Report shows the health of your SQL Server at a glance. Here is what this basic report tells you.
SQL SERVER – Introduction to SQL Server Management Studio Reports
Who dropped my table? Who is using my memory? SQL Server Management Studio Reports answer many such questions. Here is an introduction to them.
Moving SSRS Reports to a New Server
Moving SSRS reports to a new server requires the ReportServer databases, encryption key, data source checks, and subscription rehearsal.
Counting Rows per Month With Zero-Filled Gaps
Build monthly counts with zero-filled gaps, generate a complete month range, and retain empty categories through a reporting scaffold.
Turning Key-Value Pairs Into Columns for Reporting
Turn key-value pairs into reporting columns with conditional aggregation and PIVOT, handle missing values and conversions.
SSRS Parameters That Do Not Slow Reports
SSRS parameters work best with selective defaults, compact value lists, and SQL queries that preserve useful indexes under real filters.
Subtotals and Grand Totals With ROLLUP and GROUPING SETS
Build region, product, and grand totals with ROLLUP, CUBE, and GROUPING SETS, then label subtotal rows and compare plans.