When I guide a DBA over a screen share, line numbers make it easy to point at the right spot. Here is how to enable line numbers in SSMS.
SQL SERVER – Unable to See SQL Server Configuration Manager. How to Open it?
A reader had no Start menu shortcut for SQL Server Configuration Manager and could not find it. Here is how to open it anyway.
SQL SERVER – Save Auto Recover Information – SSMS
SSMS can save your unsaved queries if it crashes, yet few people know the setting. Here is where to find Auto Recover under Tools, Options and why it matters.
SQL SERVER – How to DELETE Multiple Table Together Via SQL Server Management Studio (SSMS)?
A DBA asked for a shortcut to drop more than one table at once in SSMS without writing T-SQL. Here are the simple steps, using just the keyboard.
SQL SERVER – SSMS 17.7 Observation – Two Miscellaneous Category in Database Property Options
In SSMS 17.7 the Database Property options page shows two Miscellaneous categories. Why are there two? Here is what I found when I looked closer.
SQL SERVER – Unable to Bring SQL Cluster Online – Reason: The Account is Disabled
After security hardening, a client’s SQL cluster resource sat in Online Pending, then failed: the account is disabled. Here is how we found and fixed it.
SQL SERVER – Error: Could not Load File or Assembly Microsoft. SqlServer. management. sdk. sfc Version 12.0.0.0
Could not load file or assembly errors come in many flavors. Here is how to read the assembly name and version in the message and fix the missing file.