Programming

The JavaScript NIFE Pattern

Most JavaScript developers are very familiar with the Immediately Invoked Function Expression (IIFE): (function () { var x = ‘loaded’; console.log(x); }()); In this expression, we create a function that wraps all the enclosed code in its scope, and at the end we execute the function with the parentheses. If you aren’t super-careful though, you […]

Testing SQL Query Performance

I was asked about how to test a query without all of the clever caching that SQL performs, this is how you do it… but read on for important information. DBCC DROPCLEANBUFFERS DBCC FREEPROCCACHE GO SELECT * FROM MyTable Very Important Notes There are some very important things to consider before you use these commands. […]

Secure Octopus Deploy with an Auto-Updating Let’s Encrypt Certificate

Octopus Deploy has a web portal that runs a self-hosted website on whatever port you specify. You can even have Octopus generate a self-signed certificate in order to use HTTPS when browsing the web portal… but if you connect other application that are strictly validating certificates, they won’t be too pleased with self-signed certificates. Purchasing […]