At GIDS I could not read a speaker’s SSMS output from the back row. Here is a quick SSMS tip to get larger fonts for results in grid output.
SQL SERVER 2016 – Management Studio Highlighting Current Line Option
Something felt odd in SSMS 2016: the current line highlight. Here is the option that controls Highlighting Current Line and how to change it.
SQL SERVER – Change Color for System Object Name in Text Editor (SSMS 2016)
SSMS 2016 shows system objects and DMVs in a color that is hard to read. Here is how I changed the system object color in the Text Editor back to the old style.
SQL SERVER – Skip “Save Changes to the Following Items?” Prompt in Management Studio (SSMS 2016)
Tired of the ‘Save changes to the following items?’ prompt when closing query windows? SSMS 2016 has a setting to skip it, and here is where to find it.
SQL SERVER 2016 – Scroll Bar Enhancement in Management Studio (SSMS 2016)
SSMS 2016 has new Scroll Bar settings tucked away under Tools, Options. I walk through each option, what it changes and which ones I find useful.
SQL SERVER – Unable to Open Maintenance Plan in Management Studio
SSMS refused to open a maintenance plan and showed an error instead. Here is what I did when I was unable to open Maintenance Plan in Management Studio.
SQL SERVER – syspolicy_purge_history job failing step: Erase Phantom System Health Records
A client’s syspolicy_purge_history job kept failing at the step Erase Phantom System Health Records. Here is what the job does and how to fix the failure.