Category Archives: SSMS
-
Emojis in SQL Server
8September 15, 2016 by Kenneth Fisher
I blame Aaron Bertrand (b/t) and Kevin Kline (b/t). Aaron who posted a great #BackToBasics blog about naming stored procedures …
Continue reading -
Perfectly Placed Parentheses
14June 27, 2016 by Kenneth Fisher
Like many other programming languages T-SQL uses parentheses () for a number of tasks. To help determine precedence, function calls …
Continue reading -
Comparing two query plans
2June 14, 2016 by Kenneth Fisher
This month my friend Michael J Swart(b/t) would like us to talk about the new 2016 version of SQL Server. …
Continue reading -
Certificates, Proxies and Jobs! Oh My!
2April 27, 2016 by Kenneth Fisher
Oh Noes! I have a job that requires me to run an SSIS package, cmdshell script, etc. And I need …
Continue reading -
Scripting out multiple scripts from the Object Explorer Details window.
5December 16, 2015 by Kenneth Fisher
A few weeks ago I was reading a blog post by Andrea Allred (b/t) and was just amazed by what …
Continue reading -
SSMS Setup
7November 16, 2015 by Kenneth Fisher
Every time I install a new version of SSMS I make a handful of changes to the default setup. For …
Continue reading -
Generating scripts for previous versions of SQL
1October 21, 2015 by Kenneth Fisher
I make a habit of using the latest version of SSMS even if I’m not working with the latest version …
Continue reading -
“That little green arrow.” or “My code used to work but now I’m getting a debug error.”
3October 15, 2015 by Kenneth Fisher
If you’ve worked with SSMS for any length of time this will look awfully familiar: SSMS 2008R2 SSMS 2012 + …
Continue reading -
SSMS Connection Information
Leave a commentSeptember 28, 2015 by Kenneth Fisher
If you work with a number of different instances and have lots of connections open in Management Studio (SSMS) it …
Continue reading -
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
