Category Archives: Documentation

  1. What permissions do I need?

    Leave a comment

    March 16, 2016 by Kenneth Fisher

    Ever wondered how to tell what permissions are required to run a statement or perform a task? Well, sometimes it …
    Continue reading

  2. 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

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

    2

    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

  4. 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

  5. Permissions Posters

    3

    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

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

    2

    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

  7. Pass TV

    3

    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

  8. Extending your metadata with Extended Properties

    8

    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

  9. Using Solutions in SSMS

    6

    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

  10. Required reading before upgrading SQL Server.

    4

    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

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 1,223 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013
Follow

Get every new post delivered to your Inbox.

Join 1,223 other followers