Category Archives: SSMS



    March 13, 2014 by Kenneth Fisher

    Those people who are familiar with SQLCMD will recognize this command. It is used to connect to an instance from …
    Continue reading

  2. Check your SQL Agent history settings before it’s too late!


    February 10, 2014 by Kenneth Fisher

    A little while back I was doing some research into a failed job and ran into a slight problem. The …
    Continue reading

  3. SSMS Shortcuts and more

    Leave a comment

    December 23, 2013 by Kenneth Fisher

    I went and voted for #tribalawards and when I was finished they offer you links to 6 different free PDFs. …
    Continue reading

  4. Connection options in SSMS

    Leave a comment

    November 18, 2013 by Kenneth Fisher

    When connecting to a SQL Server instance in SSMS there are a fair number of options. Most DBAs I know …
    Continue reading

  5. Change in SQL 2012 SSMS grid output behavior

    Leave a comment

    October 28, 2013 by Kenneth Fisher

    It’s one of those things that always aggravated me but not really enough to complain about. When you run a …
    Continue reading

  6. Filtering Object Explorer

    Leave a comment

    October 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

  7. Detaching a database


    September 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

  8. When I run “Script as” it isn’t (or is) … How do I fix it?

    Leave a comment

    September 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

  9. Amusing SQL Trick – Hide yourself from SQL Server

    Leave a comment

    July 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

  10. Scripting a partitioned table or index, a caution.


    July 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


Get every new post delivered to your Inbox.

Join 163 other followers