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.
SQL SERVER – Fix Error – Package ‘Microsoft SQL Management Studio Package’ failed to load in SQL Server Management Studio
SSMS says Package ‘Microsoft SQL Management Studio Package’ failed to load? I list a few ways to fix it, from reinstalling .NET Framework to running as admin.
Watching Live Data With the XEvent Profiler
XEvent Profiler in SSMS offers live Standard and T-SQL event views; a focused Extended Events session serves repeat investigations.
SQL SERVER – Turning On Graphical Execution Plan After Enabling ShowPlan Text
Turning on graphical execution plan output requires resetting SHOWPLAN and checking the SSMS actual-plan option. These examples explain batch separators, estimated plans, and actual XML output.
SQL SERVER – Find Port SQL Server is Listening – Port SQL Server is Running
The default instance uses port 1433, but what about a second instance on the same box? Here is how to find the port SQL Server is listening on.