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
Stuck after SET SHOWPLAN_TEXT? Here is the sequence that confuses developers and the fix for turning on graphical execution plan again in SSMS.
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.
SQL SERVER – Find Anything in Object Explorer in SSMS
It is easy to find anything in Object Explorer, but how do you find every object where a string exists? Here is my chat with Vinod Kumar about it.
SSMS Keyboard Shortcuts Worth Learning
SSMS keyboard shortcuts for execution, comments, results, and Object Explorer remove repeated clicks while keeping query context visible.
SQL SERVER – Rename a Table Name Containing [ or ] Identifier in the Name – Part 2
Part 2 shows another way to rename a table name that contains [ or ] identifiers, after sp_rename fails with a Msg 15253 syntax error.