Locks

Convert PFX to PEM for AWS Certificate Manager

When adding a certificate to AWS Certificate Manager, you need to have the certificate’s PEM encoded body, private key, and certificate chain. Note that unless you have a self signed certificate, you will need the certificate chain. If your cert has a chain but you don’t include it AWS will tell you an error occurred but it won’t tell you what’s wrong. I had to try and fail a few times before it worked....

March 9, 2022 · 2 min · LPains
Developer Environment

Automated and repeatable Developer Environment setup

First post of 2022 in March? Sorry for that, it took a while to get traction this year. I have a habit of “starting over” with my development environment once a year at a minimum. That means that I reinstall the OS from scratch and all my tools. This is actually fun and not hard to do at all, but can it be automated? Yes, powershell + chocolatey is a good answer to this....

March 7, 2022 · 4 min · LPains
Node Sass error

Removing node-sass from VueJS project

Let’s start with some context so things make sense. I’ve created a vue project back in 2018. It is the largest project I work on regularly and we’ve done a decent job to keep everything up to date in it. This project is built by Azure DevOps hosted servers and recently the builds started failing because of node-sass. Let’s talk about the problem, and how we can fix it. First, you should know that node-sass is no longer recommended....

December 29, 2021 · 2 min · LPains
Time

Detecting changes on SQL Server Temporal Changes

SQL Server system-versioned temporal tables provide a powerful way to keep data history for a table. It provides a way to query data as of a point in time, or the changes between a time period. Check the docs for more detail. While history tables are great for many scenarios based off history data. When you need to calculate delta changes it gets a little more complicated as I am sure Temporal Tables were not designed for that purpose....

October 29, 2021 · 5 min · LPains
Hugo

Migrating from jekyll to Hugo

So, the first obvious question is: what’s wrong with Jekyll? Overall, Jekyll is fine. I just never liked how hard it is to install it on Windows. For the most part, I made most of my blog changes blindly. That includes structure, style, and blog posts. The next big question is: why Hugo? Well… It is super easy to install for one. But it is also popular, easy to use, and works similarly to Jekyll....

October 10, 2021 · 5 min · LPains