Exception error codes

A practice I have engaged in for a long time now is adding error codes to any custom or handled exceptions that are thrown on purpose in anapplication. The purpose of these error codes is to act as an...

Biases in naming database objects

Introduction Over my whole software engineering career, I have watched and learned the right way and the wrong way to style and format code. Especially when it comes to naming objects. There has been ...

Enlarging a CHAR column

Scenario As usual when you don’t do something for a very long time, it is easy to forget what you knew already. I had to increase the column size of a CHAR field from 9 to 15 bytes and I totally...

IIS application pool exploit

What? That’s what I said too when I first discovered the exploit. I didn’t think it was so easily possible to extract usernames and passwords from IIS, but it is. I contacted Microsoft abo...

SSIS loop and container continue on error

Obscure and not straight forward This is one of those things I can never remember because it doesn’t come up that often. This is usually only a case where you are trying to introduce fault toler...