Monthly Archives: October 2014

  1. Playing with the log – Before the first full backup

    1

    October 29, 2014 by Kenneth Fisher

    The log file tends to fascinate me. In fact one of my favorite posts is where I looked into the …
    Continue reading

  2. A script to list the DTS connection information for every package on the instance.

    Leave a comment

    October 27, 2014 by Kenneth Fisher

    For those of you who have moved completely to SQL 2012 & 2014, Lucky you and don’t judge! For the …
    Continue reading

  3. Force only certain values to be unique

    1

    October 22, 2014 by Kenneth Fisher

    I thought of something rather interesting the other day while answering a question asking for help with some table structures. …
    Continue reading

  4. Update to “The clustered index columns are in all of the non clustered indexes.”

    5

    October 20, 2014 by Kenneth Fisher

    I certainly hadn’t planned on creating a part two of my post on clustered index columns but in the comments …
    Continue reading

  5. UNION vs UNION ALL

    6

    October 16, 2014 by Kenneth Fisher

    You might be wondering why I’m going into such a simple subject. Well the way I see it there are …
    Continue reading

  6. TSQL Tuesday #59: My Hero, My Inspiration, My Wife

    Leave a comment

    October 14, 2014 by Kenneth Fisher

    TSQL Tuesday is a blog party started by Adam Machanic (b/t) almost 5 years ago. This month Tracey McKibben (b/t) …
    Continue reading

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

  8. You can’t use aggregate/windowing functions with CROSS APPLY

    11

    October 6, 2014 by Kenneth Fisher

    One of my favorite features of CROSS APPLY is the ability to use it instead of a calculated variable. Well …
    Continue reading

  9. Intro to Auditing in SQL Server on SQL Shack

    Leave a comment

    October 1, 2014 by Kenneth Fisher

    I had an article published yesterday on http://www.SQLShack.com. Intro to Auditing in SQL Server. It’s worth reading if I do …
    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