Category Archives: Problem Resolution
-
The 30 minute rule
9August 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 -
Blocking and deadlocking on purpose
3July 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 -
Copying a TDE database from one instance to another
12June 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 -
Test first; Mileage may vary;
2May 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 -
Building a job to monitor other jobs
5May 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 -
Clean out all bad characters from a string.
10March 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 -
Dealing with layered function calls
5February 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 -
Finding the reason for the error “Subquery returned more than 1 value”
1January 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 -
SQL Judo’s Monthly Challenge – January 2014 – Restore the Master
5January 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 -
‘Twas 4:45 Friday
3December 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
SQL Studies 