MariaDB backup and restore is really simple from the command line. If you have a problem with a database caused by a change (see: Wordpress), and want to restore to a previous version, you need a mysql dump file, and that’s it. All you need to do is run the... [Read More]

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]