Small date time is garbage and you should stop using it

Smalldatetime has been obsolete for a long time now get with the program A major pet peeve of mine is the smalldatetime datatype from SQL server. Not because it exists or it was what was available at ...

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

Error: The SQL command requires a parameter named “”, which is not found in the parameter mapping.

Gotcha This is a problem I have encountered a few times already when using SSIS with an OLE DB Source and a stored procedure. All the mappings are correct, but it just seems like SSIS doesn’t li...

Adding assembly version information to dotnet core projects

Gotcha In dot net framework the assembly information was located inside of a Properties folder where you would find the “AssemblyInfo.cs” file and you could either edit that file directly ...

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

Visual Studio 2017 SSIS unable to start debugging

Microsoft’s handling of SSDT isn’t good I have criticized Microsoft about this before here – and I am going to continue to wag my finger at them. It’s getting better, but still...

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

Could not load file or assembly System.Web.WebPages.Deployment

I encountered this problem when moving from an old machine to a new machine. I vaguely recall having this problem once before, but it was such a long time ago I just don’t remember. However I en...

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