I was doing some Web API testing for a client today, with a fairly complex scenario that required multiple permutations of data. I had requested each possible combination, which was provided to me as a pile of JSON files that were compliant with a REST service on our side. The... [Read More]

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]