The User Statistics report in SSMS shows the users who are connected to a database. This post opens the report, answers the same question with a query over sys.dm_exec_sessions, and finds the one application that holds many sessions.
SSMS Command Line Options: Server, Database and Login
SSMS command line options open Management Studio already pointed at a server and a database. This post finds SSMS.exe, lists the switches that SSMS 22 documents in its own usage text, and shows how to turn them into a shortcut without saving a password.
How to Force Index on a SQL Server Query? – Interview Question of the Week #281
Question: How to Force Index on a SQL Server Query?
Answer: I personally do not like to force an index on any query. Let us learn together.
Shaping Query Results as JSON With FOR JSON PATH
Shape FOR JSON PATH output with nested objects, child arrays, null options, and wrappers, then return one complete JSON value to clients.
Azure Data Studio- Export Any SQL SERVER Query As JSON
Recently, one of my clients’ Comprehensive Database Performance Health Check asked me if I know a way to export any query as JSON with SSMS.
Year-Over-Year Comparisons in One Query
Build year-over-year monthly comparisons with a complete calendar, LAG, date-aligned joins, safe percentages, and missing-period rules.
QDS_LOADDB Wait: Slow Startup and Query Store Load
A QDS_LOADDB wait means a database waits for Query Store to load its data at startup. This post reads the wait, checks the size of a store, explains the trace flag that loads Query Store asynchronously, and shows the settings that keep a store small.