Link Dump

I haven't had cause to drop one of these since November last year, probably at least in part because Edge seems to have a nasty habit of eating tabs! In no particular order, and likely of more use to me, than to you....

MT940 Format Overview

The MT940 format is one used by banks (via SWIFT) for sending electronic bank statements to customers. So, if you want to import bank statement data into your system it'll probably be MT940 files that you'll end up processing. The really nice thing about them is that the format seems to be standard, but then each bank customises the hell out of it. So, by all means look at some of the NuGet packages available for processing MT940 files but don't be under any illusion that they'll work unless they're for your banks dialect of MT940!

Don't Block on Async Code

This post by Stephen Cleary from 2012 (six years ago, eep!) is one that every developer who's gone within a mile of async/await code should read and understand. The short version is, if your code's async, make sure it's all async. C# 7.1 implemented support for async Main methods in August last year so that last hold out has disappeared too.

Stack Overflow: OutOfMemoryException saving a List on a JSON file

The write-up by dbc of ways to mitigate against heavy memory usage when serializing large amounts of data with Json.NET is awesome. The principles are generalisable as well, so even if you've never used Json.NET and never intend to, it's probably worth a read.

Using Windows Authentication with IISExpress

Reminder to self: When working with ancient web app and trying to convert it to use IIS Express, a 401.2 error means that the app needs to be configured to use Windows auth

Connect to SQL Server When System Administrators Are Locked Out

Sometimes you find a SQL Server that you've inherited where the 'sa' password isn't known and there aren't any Windows accounts that have 'sa' level access to the server. It's a bit of a faff but you can recover access - faff is defintiely better than having to re-install SQL Server!

About Rob

I've been interested in computing since the day my Dad purchased his first business PC (an Amstrad PC 1640 for anyone interested) which introduced me to MS-DOS batch programming and BASIC.

My skillset has matured somewhat since then, which you'll probably see from the posts here. You can read a bit more about me on the about page of the site, or check out some of the other posts on my areas of interest.

No Comments

Add a Comment