Tag Archives: Management Studio


Management Studio Custom Shortcuts

Management Studio Custom Shortcuts

A DBA recently attended me on the “Query Shortcuts” option within Management Studio. Now, I have to admit that I’m lazy from time to time and a horrible typist on Monday mornings and therefore using the option a lot, especially while debugging.

Read More →

SSMS color code your environments

SQL Server SP_what

Ever executed a script on the wrong environment? Neither do I… but for those who do need a visual queue as to which server you are on, I’ve included some helpful steps below:

Read More →

sp_what: Seek and ye shall find

SQL Server SP_what

On-site performance tuning analysis can be as rewarding as it is frustrating. There are some aspects you just can’t control; Ranting managers or dealing with a passive DBA, which often stands behind you with popcorn and drinks. Fortunately, you can prepare your scripts in advance based as i did based on prior leanings.

Read More →