Object Dependencies in SSMS shows the references recorded in SQL Server metadata. This post adds T-SQL queries for both directions, tested on SQL Server 2025, and shows what the dialog cannot see: dynamic SQL, other databases and a table dropped under a view.
SQL SERVER – SSMS: Activity – All Blocking Transactions
Bengaluru traffic after a rainy day has a lot in common with blocked queries. I look at the All Blocking Transactions report in SSMS and what it shows.
SQL SERVER – Activity Reports – Dormant Sessions
A parent-teacher meeting tells me more than a report card. In the same way, the SSMS activity report on Dormant Sessions shows idle connections on your server.
SSMS Code Snippets: Writing Your Own Templates
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.