Category Archives: Documentation

  1. SSMS Connection Information

    Leave a comment

    September 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

  2. What SQL Server components are installed on this machine?


    September 14, 2015 by Kenneth Fisher

    Figuring out what components of SQL Server are installed on a particular machine has always been a task that has …
    Continue reading

  3. Where you should start when managing an enterprise

    Leave a comment

    September 8, 2015 by Kenneth Fisher

    This T-SQL Tuesday we are hosted by one of the DBA’s of the night: Jen McCown (b/t). She want’s us …
    Continue reading

  4. Permissions Posters


    July 27, 2015 by Kenneth Fisher

    I’ve been doing a lot of research recently for my permissions session and for a project at work. During said …
    Continue reading

  5. TSQL Tuesday #68: What is my configuration?


    July 14, 2015 by Kenneth Fisher

    It’s T-SQL Tuesday again and this month Andy Yun (b/t) is our host and he has asked us to “Just …
    Continue reading

  6. Pass TV


    June 17, 2015 by Kenneth Fisher

    Recently Adam Machanic (b/t) was telling me about an interesting effect of the top operator. When I asked for an …
    Continue reading

  7. Extending your metadata with Extended Properties


    May 18, 2015 by Kenneth Fisher

    Ever wanted to put a comment on a table? Or maybe even a column? How about an expiration date on …
    Continue reading

  8. Using Solutions in SSMS


    March 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

  9. Required reading before upgrading SQL Server.


    October 8, 2014 by Kenneth Fisher

    I was watching a great presentation by Brent Ozar(b/t) on why to move to SQL 2014 and in the Q …
    Continue reading

  10. What I know about batch files


    September 24, 2014 by Kenneth Fisher

    For a SQL Server guy it sometimes amazes me how often I’m in and out of batch files and how …
    Continue reading


Get every new post delivered to your Inbox.

Join 806 other followers