I received some large CSV files that needed importing into a database, but unfortuntely there were hundreds of lines that contained line feeds so they would not import correctly. [Read More]

This is my personal summary of the book Software Architecture: The Hard Parts: Modern Trade-Off Analyses for Distributed Architectures. It’s important to note that this is only written to jog my memory - it is almost impossible to capture this book as a summary as there is so much in... [Read More]

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]