I’m working on a project to create an SFTP Scheduler, and needed an SFTP server to test with. I work on Windows but have an Ubuntu virtual machine that I run through Hyper-V - and I didn’t realise how easy it was to set up a test server. For my... [Read More]

We have been looking into columnstore indexes to boost the performance of our data warehouse at IUA. [Read More]

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]

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]