Monthly Archives: March 2015

The April Blogger Challenge

Posted on March 27, 2015 by way0utwest

I’d encourage you to take Ed Leighton-Dick’s challenge to blog in April. Read his post, start writing, and put your post out there. Tweet about it, and be proud. However, if you’ve never blogged, I have a modification for you. … Continue reading →

Posted in Blog | Tagged , , , | 3 Comments

Efficiency

Posted on March 26, 2015 by way0utwest

This editorial was originally published on Oct 22, 2010. It is being re-run as Steve is away on vacation. There was a debate recently about older IT workers and the fact that there is some age discrimination going on in … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Efficiency

tSQLt with TRY..CATCH

Posted on March 25, 2015 by way0utwest

Someone asked me the question recently about how tSQLt works with TRY..CATCH blocks and the exceptions that we might test for. It works fine, just as it would with other code, but you need to understand that a CATCH still … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on tSQLt with TRY..CATCH

The Basic TRY..CATCH

Posted on March 24, 2015 by way0utwest

Have you written a TRY..CATCH statement in T-SQL? I hadn’t done it for most of my career, since the construct hadn’t existed. As a result, my code over the years is littered with catching @@error in a variable and then … Continue reading →

Posted in Blog | Tagged , , | 2 Comments