Category Archives: Problem Resolution
-
“That little green arrow.” or “My code used to work but now I’m getting a debug error.”
3October 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 -
Keep an eye on those Audit files!
Leave a commentOctober 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 -
Finding the error from a failed job.
3October 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 -
“sql_handle” is not a recognized table hints option.
Leave a commentSeptember 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 -
The 30 minute rule
3August 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
Leave a commentJuly 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
Leave a commentJune 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
