There is nothing like learning something new just after you realize what was released broke several referenced URLs. After upgrading to the latest v4 release of Gatsby, a plugin to generate the blog post pages needed some drastic refactoring, as the…

Two years into writing for myself, how it feels like I have always been here. But, in the grand scheme, it is still a new practice to me. What I was initially worried about (spelling mistakes, having nothing to say, confidence in writing skills) have…

Earlier this evening I had an idea for a post. It has been some time since sitting down to write a post. Trying to get back into the routine, I grabbed my laptop and settled in. In the time since last writing, newer versions of Node have been…

I have not posted in some time. That has not been intentional. I had an idea well over a month ago that I began working on. I loved the idea, it was so fun to explore deeper. As I kept digging. The idea kept growing and growing. It had everything I…

In the past couple of years, I have learned that time too easily gets away from me. I tend to get lost in a problem and lose track of time. It was not uncommon for half of the day to be gone and progress not where I thought it should be. Once I was…

Many of us technical folks are on teams with 3 maybe 4 or more different skill sets. Not all of which are technical in nature, some more people focused, others may focus on statistical analysis, perhaps skills that are focused on art and graphics. It…

I remember when I was first getting into the field of software development. Ready to soak up all the knowledge from my new colleagues and the challenges I was facing down. I was going to learn it all leaving nothing left on the table. I worked my…

It has been a while since I have contributed to this blog. Am I mad about it? Not in the slightest. But, in not writing I have learned something about myself. I am a creature of habit... SHOCKING! We often talk about what we can do to make ourselves…

With all this data landed, how about some fun and interesting stats from the data set? Top 5 Constructors with podium finishes Top 5 Drivers with Podium Finishes

With my first ETL complete, I want to provide additional details on the steps I took. Then reflect on what I would do differently next time. First, a more detailed look at the steps I took: Collect data, as CSV files, from the data source Scan CSV…

The final step in the ETL process is to load the transformed data into the target datastore. For this example, I have created a landing database on the same SQL Server, but this final target could be anywhere data can be stored. Given that much of…

With landed data and the first pass at type analysis completed. It is time to take a better look at the current state of the data. Since this data set is quite small and I was on the edge of my SQL knowledge I performed this manually. Creating a…