I purchased a new laptop through work today, which came with a pre-installed version of Windows Home Edition. I need Professional Edition for work, and so bought a copy of Windows Pro at the same time. Because I’m iffy about setup, I elected to install the new OS myself…what a... [Read More]

I’ve used OPENROWSET to import Excel documents for years, but I was playing around today with CSV and Pipe-delimited files, and there are some tricks to these that I thought I would document for future reference. [Read More]

A client reported an issue with one of our API endpoints today with a rather depressing problem - it worked fine with single posts, but multiple concurrent posts resulted in random errors. [Read More]

Creating a web site is simple, but there are a lot of basic items to consider that are easy to forget but will trip you up in the lifetime of the web site. These lists should be revisited regularly. [Read More]

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]