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 ...
Using Gmail for SMTP access
Introduction When you search for this on google you will find one hundred million results that all pretty much say exactly the same thing. The problem is none of them are from a developer’s pers...
Offline installation of Microsoft Machine Learning server components SQL 2019 is stuck
Problem You are installing SQL Server 2019 and you get stuck at the Machine Learning Server Components installation step. Your installer could not download the files for whatever reason, it asks you t...
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...
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 ...