Category Archives: Problem Resolution

  1. The 30 minute rule

    3

    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

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

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

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

  5. Building a job to monitor other jobs

    5

    May 4, 2015 by Kenneth Fisher

    The other day Tom Roush (b/t) and Tim Radney (b/t) were having a discussion on twitter about using scheduled windows …
    Continue reading

  6. Clean out all bad characters from a string.

    10

    March 25, 2015 by Kenneth Fisher

    I have a customer who is having a problem with a load. He is getting a fair number of bad …
    Continue reading

  7. Dealing with layered function calls

    5

    February 5, 2015 by Kenneth Fisher

    T-SQL is not the best language in the world for formatting strings. It can be done, but typically you are …
    Continue reading

  8. Finding the reason for the error “Subquery returned more than 1 value”

    1

    January 7, 2015 by Kenneth Fisher

    First this type of error is because a subquery returned more than one row when it wasn’t allowed to. In …
    Continue reading

  9. SQL Judo’s Monthly Challenge – January 2014 – Restore the Master

    5

    January 5, 2015 by Kenneth Fisher

    Every month SQL Judo (Russ Thomas) (b/t) challenges us to do his Monthly DBA Challenge. I’ve decided it would be …
    Continue reading

  10. ‘Twas 4:45 Friday

    2

    December 16, 2014 by Kenneth Fisher

    ‘Twas 4:45 Friday, and all through the office not a creature was stirring, not even the bosses. The code was …
    Continue reading

Follow

Get every new post delivered to your Inbox.

Join 804 other followers