Category Archives: SSMS
-
Learning Regular Expressions
7September 2, 2015 by Kenneth Fisher
I’m a regular watcher of the Midnight DBA Webshow and one day they mentioned regular expressions. Not a new term …
Continue reading -
SSMS’s Clipboard Manager
13August 19, 2015 by Kenneth Fisher
The other day Richie Rump (b/t) mentioned something called a clipboard manager on twitter. I’ll admit I had to ask …
Continue reading -
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 -
Rename a database
3June 15, 2015 by Kenneth Fisher
Renaming a database isn’t something you do frequently but it does have bit of a gotcha. First of all let’s …
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 -
A walk-through of creating the Activity Tracking template using Extended Events.
5June 9, 2015 by Kenneth Fisher
It’s the second Tuesday of the month and that means T-SQL Tuesday time! T-SQL Tuesday is a blog party started …
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
SQL Studies 