ETL: Load
Last week we discussed the transform phase of ETL and now it’s time to wrap it up with the Load phase. The Load phase is where transformed data is deposited into its target destination, whether that’s a data warehouse, a business intelligence tool, or another storage...
Surfing the WSL Wave
With Summer coming to a close I decided to take another surf on the WSL (Windows Subsystem for Linux) wave and in short was not disappointed. Technically there are two flavors of WSL, WSL 1 and WSL 2. WSL 1 is a translation layer that takes Linux system calls and...
ETL: Transform
In my previous post, we explored the first step of the ETL (Extract, Transform, Load) process—Extraction. Today, we move on to the heart of ETL: Transformation. Turns out your legacy data is really value in disguise. This step is all about turning raw, extracted data...
Syncing Prod & Staging Data With Dokku
If you're anything like me, you’ve probably faced the classic problem of everything working swimmingly on your test / staging environment, but the end users hitting some weird issue on production. This is often caused by your production data being (obviously) accurate...
ETL: Extract
As organizations grow and evolve, so do their technology stacks and the quantity of import data being generated by those tools. Unfortunately, it’s all too common for firms to be unable to leverage the efficiencies that having all that data integrated would provide,...
Happy 20th Rails!
As many of you might know Rails is now twenty years old; that's two years older than it needs to be to able to be executed by the state or sent to kill people on the other-side of the world in the US, but a year shy of ordering a Sam Adams or pack of Camels....