Monthly Archives: August 2013

  1. The most important skill to practice when preparing for any certification exam!

    4

    August 28, 2013 by Kenneth Fisher

    I like practice tests. Once I feel like I’m getting ready to take a certification exam I start taking an …
    Continue reading

  2. The effect of VLF size on shrinking the log.

    3

    August 26, 2013 by Kenneth Fisher

    I was wondering the other day how VLF (Virtual Log File) sizes effected shrinking the log file so I decided …
    Continue reading

  3. Lots of ways to UNPIVOT a table

    Leave a comment

    August 21, 2013 by Kenneth Fisher

    I recently read an awesome post on http://www.stackexchange.com questioning how to change columns to rows ie UNPIVOT. One answer demonstrated …
    Continue reading

  4. sp_SrvPermissions

    Leave a comment

    August 19, 2013 by Kenneth Fisher

    Last week I posted my stored procedure for database permissions, sp_DBPermissions. A couple of days later I was demonstrating it …
    Continue reading

  5. sp_DBPermissions

    3

    August 14, 2013 by Kenneth Fisher

    Last week I posted a series of database permissions scripts. I’ve been using them quite a bit over the last …
    Continue reading

  6. “My transaction log is too big!”

    3

    August 12, 2013 by Kenneth Fisher

    “My transaction log is too big!” I wish I had a dime for each time phrase has been spoke, written, …
    Continue reading

  7. How are COALESCE and ISNULL different?

    6

    August 7, 2013 by Kenneth Fisher

    At first glance these two functions seem very similar, and superficially they are. For example COALESCE(fieldname1, fieldname2) and ISNULL(fieldname1, fieldname2) …
    Continue reading

  8. Database Permissions Queries

    3

    August 5, 2013 by Kenneth Fisher

    Over the last year of blogging my thoughts and queries I’ve discovered something interesting. I posted Where is my Backup? …
    Continue reading

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

Join 1,614 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013