There is a very powerful feature in SQL Server that if you know how to take advantage of can cut down on the amount of […]
SSIS Custom Task XML Corruption
Introduction I usually like to keep any explanation I write to be straight to the point, but informational and no fluff. There are times where […]
ASP.Net Forms Authentication IsAuthenticated is always false
Obscure problem You have a web application that uses Forms Authentication The code has been working fine for months if not years because it’s boiler […]
Git stop tracking files
Problem You screwed up and you added a bunch of garbage files to your repository and realized it while reviewing your PR (hopefully). This doesn’t […]
Windows 10 KB4532693 profile issue
Windows has a strange habit of corrupting your profile at times. This can happen for a number of reasons. In my experience it is usually […]
Using absolute paths with FTP
Obscure problem Ran into an annoying problem recently where an FTP account I was logging in with had a home directory of something like this: […]
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 […]
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 […]
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 […]
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 […]