SSIS loop and contains 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...

Dot net core NUnit unit test won’t start

I was hoping this problem would resolve itself, but it hasn’t so I am writing about it to document it to refer to in the future. I ran into this problem twice now and it annoys me because it sho...

Cannot ping or RDP to Windows 10 machine

Problem This is a particularly stupid gotcha. For a long time now I haven’t been able to RDP into my Windows 10 Surface Pro 4. I tried everything I could think of or look up including but not li...

Padding a string in tSQL

Gotcha There isn’t a Pad Left or Pad Right function in tSQL. Solution There is a lengthy discussion about this topic already on Stack Overflow here: https://stackoverflow.com/questions/16760900...