When scripting SFTP jobs, it’s a good idea to include the host key fingerprint to prevent man in the middle attacks. The easiest way I have found to get this information (if not provided) is to use WinSCP. [Read More]

This is for future me….as present me always forgets how to do this. [Read More]

Loading raw text data into SQL Server can be done using Flat File import or Data Imports, but I find this is always problematic as it does row scans to predict data types, but invariably fails on large data sets due to bad data types further down the file, or... [Read More]

This article is my personal summary (for future reference) of Robert Martin’s book Clean Code (most of it, anyway). [Read More]

I use mRemoteNG on a daily basis, but every now and again it crashes, prompting you for a password to load your connections. This is as a result of a corrupt connections files. [Read More]