Choosing a database IDE means testing SQL editing, plans, schema work, security, and team workflow across SSMS, VS Code, and other tools.
Live Execution Plan of a Running Query: SQL in Sixty Seconds #073
A live execution plan shows how far a query has gotten while it is still running. This post builds a slow query on SQL Server 2025, watches it through sys.dm_exec_query_profiles from a second window, and explains why rows divided by the estimate is a progress meter only when the estimate is right.
SQL SERVER – CTRL + R Shortcut Does Not Work in SSMS
After a fresh SQL Server 2014 install, CTRL + R no longer hid the results pane in SSMS. These keyboard option steps got my shortcut working again.
SQL SERVER – SSMS: Memory Usage By Memory Optimized Objects Report
Why is SQL Server using all the memory? In-Memory OLTP in SQL Server 2014 makes it trickier. This SSMS report shows memory used by memory optimized objects.
SQL SERVER – SSMS: Database Consistency History Report
Like a doctor looking for patterns in symptoms, the Database Consistency History report in SSMS shows the history of consistency checks on a database.
SQL SERVER – SSMS: Backup and Restore Events Report
Backups look trivial until the day a disk crashes. The Backup and Restore Events report in SSMS shows the history of those tasks for a database.
SQL SERVER – SSMS: Disk Usage Report
After a doctor joke, we move from server level reports to database level ones, starting with the Disk Usage report in SSMS.