Build SSMS code snippets with editable literals, register your own snippet folder, and use Template Explorer for repeatable SQL scripts.
SQL SERVER – SSMS: Memory Consumption Report
‘My SQL Server eats RAM and never gives it back’ is a common complaint. The SSMS Memory Consumption report shows where that memory goes and why.
SQL SERVER – SSMS: Scheduler Health Report
Like a conductor at a concert, the scheduler makes sure every task in SQL Server gets its turn. Here is how the SSMS Scheduler Health Report shows its state.
Object Explorer Details in SSMS: Bulk Scripting and Quick Counts
Press F7, select a group of tables and script them in one go. Then check the grid’s row counts with two short queries.
SQL SERVER – SSMS: Schema Change History Report
Who created, dropped or altered a database or object? Young DBAs in Delhi gave me many answers, but the SSMS Schema Change History report answers it quickly.
SQL SERVER – SSMS: Configuration Changes History
My friend Joe’s new job needed standard server settings. The SSMS Configuration Changes History report shows when settings changed. Here is how it helps.
SQL SERVER – SSMS: Server Dashboard Report
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.