Partials are a nice way in ASP.NET of sharing mark-up across views. These are usually rendered from within view markup, but sometimes you may want to render a partial from within a controller method - for example if you want to create an HTML email but don’t want to put... [Read More]

When writing .NET Core+ web applications, you will want your JavaScript files to be unminified in development, and minified when you release to production. You can use the “environment” tag helper to distinguish between the two, but this adds unnecessary noise and it’s too easy to change one and forget... [Read More]

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]