Category Archives: Problem Resolution

  1. Start SQL Server without tempdb

    1

    January 20, 2016 by Kenneth Fisher

    tl;dr; Re-start the instance in safe mode (-f startup parameter) and move tempdb. Then re-start without the parameter. While at …
    Continue reading

  2. ‘Twas 4:45 Friday

    Leave a comment

    December 23, 2015 by Kenneth Fisher

    I couldn’t think of anything really fun to post for Christmas Eve-Eve and I’ve been busy buying and wrapping presents …
    Continue reading

  3. “That little green arrow.” or “My code used to work but now I’m getting a debug error.”

    3

    October 15, 2015 by Kenneth Fisher

    If you’ve worked with SSMS for any length of time this will look awfully familiar: SSMS 2008R2 SSMS 2012 + …
    Continue reading

  4. Keep an eye on those Audit files!

    Leave a comment

    October 13, 2015 by Kenneth Fisher

    This month’s T-SQL Tuesday (#71) is hosted by Sebastian Meine (b/t). He has picked an interesting security subject. SQL Server …
    Continue reading

  5. Finding the error from a failed job.

    3

    October 7, 2015 by Kenneth Fisher

    This is a fairly simple one once you’ve seen it, but then so are lots of things :). Let’s say …
    Continue reading

  6. “sql_handle” is not a recognized table hints option.

    Leave a comment

    September 23, 2015 by Kenneth Fisher

    I’ve you’ve run a query similar to the following: And gotten an error similar to: Msg 321, Level 15, State …
    Continue reading

  7. The 30 minute rule

    4

    August 26, 2015 by Kenneth Fisher

    In one of my first IT jobs (back in the dark ages) we had something called the thirty minute rule. …
    Continue reading

  8. Blocking and deadlocking on purpose

    Leave a comment

    July 1, 2015 by Kenneth Fisher

    Blocking and deadlocking are not things you typically want to do deliberately. But sometimes you need to test error handling …
    Continue reading

  9. Copying a TDE database from one instance to another

    Leave a comment

    June 22, 2015 by Kenneth Fisher

    I got my first real world experience with a TDE (transparent data encryption) database recently. For those who don’t know …
    Continue reading

  10. Test first; Mileage may vary;

    2

    May 14, 2015 by Kenneth Fisher

    I went to a SQL Saturday recently and saw a number of great sessions. If you haven’t been to a …
    Continue reading

Follow

Get every new post delivered to your Inbox.

Join 847 other followers