Category Archives: SSMS
-
Filtering Object Explorer
3October 2, 2013 by Kenneth Fisher
I absolutely love learning new tricks that can be done in SSMS. Everything from opening initial connections to both the …
Continue reading -
Detaching a database
1September 26, 2013 by Kenneth Fisher
In my general quest to figure out the T-SQL to do common GUI tasks I did some browsing through BOL …
Continue reading -
When I run “Script as” it isn’t (or is) … How do I fix it?
1September 3, 2013 by Kenneth Fisher
When I run “Script (say table) as” it isn’t (or is) (say generating scripts for indexes). How do I fix …
Continue reading -
Amusing SQL Trick – Hide yourself from SQL Server
1July 17, 2013 by Kenneth Fisher
I make a point of reading DBAReactions on a fairly regular basis and today while reading it I was lead …
Continue reading -
Scripting a partitioned table or index, a caution.
14July 15, 2013 by Kenneth Fisher
I was researching a problem with a partitioned table that had somehow become unpartitioned and discovered something rather interesting. First …
Continue reading -
Ordering steps in a SQL Agent job
2July 8, 2013 by Kenneth Fisher
Generally if I need to do any form of complicated control flow I’ll end up using SSIS, however there is …
Continue reading -
Easy way to generate a restore script.
Leave a commentJune 5, 2013 by Kenneth Fisher
Easy way to generate a restore script. I was asked today if I had a canned restore script handy. I …
Continue reading -
Dragging a name from the object explorer to a query window
8May 13, 2013 by Kenneth Fisher
In the same vein as Steve Jones’ series on Customizing SSMS this is a fairly basic trick, but one that …
Continue reading -
Using Templates
3March 18, 2013 by Kenneth Fisher
Templates are one of those really handy tools that most DBAs I know of have either never heard of or …
Continue reading -
Multiple instances, single query window
2February 18, 2013 by Kenneth Fisher
Anyone who has been reading my blog for a while should realize that several divisions in my company have been …
Continue reading
SQL Studies 