Locks

Getting started with Ephemeral environments

Ephemeral developer environments are short-lived and typically serve a single purpose. Perhaps you are away from your development computer or you are working on completely different projects and don’t want to “polute” one or the other. For instance, I have a policy of not mixing up work and personal projects. If I am not at home, I typically don’t have my blog code or environment setup. I spent some time working with both gitpod....

August 17, 2022 · 3 min · LPains
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