I always forget this, so I’m documenting it here for myself. If you make SFTP connections from automated scripts or within a program, you really want to be supplying the SSH key. [Read More]

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]