Tag Archives: SSMS
-
Some of my favorite SSMS Keyboard shortcuts
11July 29, 2015 by Kenneth Fisher
I love keyboard shortcuts. I recently mapped a keyboard shortcut to Change Connection and thought I would share some of …
Continue reading -
SSMS 2015
4July 16, 2015 by Kenneth Fisher
Yes, you heard me right. SSMS 2015. No I’m not one of those crazy recruiters who keep asking for 10 …
Continue reading -
Adding a new keyboard shortcut in SSMS.
7July 6, 2015 by Kenneth Fisher
I love keyboard shortcuts. I’d rather keep my hands on the keyboard than move back and forth to the mouse. …
Continue reading -
Modifying the “New Query” template.
13June 11, 2015 by Kenneth Fisher
TLDR; Search for and modify the sqlfile.sql file. During a recent T-SQL Tuesday Boris Hristov (b/t) taught me about SET …
Continue reading -
Yet one more quick and easy performance tuning setting
1June 1, 2015 by Kenneth Fisher
I blogged in the past about two simple commands that can be a big help in performance tuning SET STATISTICS …
Continue reading -
Using Solutions in SSMS
16March 11, 2015 by Kenneth Fisher
There are a handful of scripts I use on a regular basis. Adam Mechanic’s (b/t) sp_WhoIsActive, My sp_DBPermissions and sp_SrvPermissions, …
Continue reading -
Using T-SQL to populate a Central Management Server
6November 17, 2014 by Kenneth Fisher
We have been using a CMS (Central Management Server) at my office for the last few years. Even beyond the …
Continue reading -
Escaping from a runaway Logon trigger
11May 19, 2014 by Kenneth Fisher
Most people know that logon triggers can be dangerous if you aren’t careful. And if you didn’t know, well, logon …
Continue reading
SQL Studies 