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

LinqPad quick reference

This is a quick post for my own ignorance. On occasion I use LinqPad to make changes in a database and I find the stock LinqPad linq to sql provider to be very useful. I just happen to forget the synt...

Pivoting data without an aggregation column

Don’t use PIVOT for non-aggregate-able data I ran into a rather displeasurable experience where a separate team of people built some very important tools for us and they did a lackluster job and...