Category Archives: SSMS
-
SSMS Tips: Copy Full Path
Leave a commentApril 24, 2017 by Kenneth Fisher
When you right click on a tab you’ll see a number of different options. You can set up new horizontal …
Continue reading -
Hiding tables in SSMS Object Explorer
Leave a commentApril 3, 2017 by Kenneth Fisher
Extended Properties Sometimes you find out the strangest things about SQL Server. I’ve written about extended properties before but had …
Continue reading -
Changing what SSMS opens on startup
Leave a commentFebruary 1, 2017 by Kenneth Fisher
When you open SSMS a connection window automatically comes up. Then once you pick your server, connection type, username and …
Continue reading -
:OUT :OUT darn results!
2December 19, 2016 by Kenneth Fisher
Years ago I worked for a company that had a rather cool way of handling requests. When we ran the …
Continue reading -
Using Snippets
Leave a commentOctober 17, 2016 by Kenneth Fisher
A while ago I talked about Templates. This is an easy way to get a, well, template of a piece …
Continue reading -
Pinned Tabs
3September 27, 2016 by Kenneth Fisher
It’s funny how easy it is to find information you aren’t looking for. A few weeks back Stephen Bennett (b) …
Continue reading -
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
3June 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
