Flattening out MongoDb documents can be a bit of pain. I use RoboMongo to inspect database documents, and I may be stupid, but although I can query individual fields, the GUI will still present them in tree format, so I don’t get a nice “spreadsheet” view that I can export... [Read More]

I have no idea how I didn’t know this existed - it’s been around for ages. Openfiles.exe has existed on Windows machines since Windows XP, and this is something that I’ve struggled with for years! [Read More]

I was looking into poor performance issue on a data warehouse report today, and noticed this line as one of the columns being returned in the SELECT statement: [Read More]

I decided to install MediaWiki today on one of our web servers, and set it up within IIS. However, although the site immediately served pages, all of them were displaying without any styles. The stylesheet request showed with a 200 response within Chrome so I didn’t think there was anything... [Read More]

I needed to set up a web site that has a basic page for browsing as the root, but within that site there should also be download folders secured for different users. The folders don’t require a web page, just browsable content. The issue I had was that there is... [Read More]