A Good Day to Delete Hard

Deletion method is an important data warehousing concept, one you’d ideally master before an interview.

Much Ado About NULL Things

We have to talk about NULLs. This post won’t include anything revolutionary, but rather just a summary of what NULLs are, what they aren't, and why they are important in data warehousing.

Normal Forms for Normal People

This post is for my friend Mitch, who, despite his persistent belief that he annoys me with his questions, has reminded me why it’s important that we stay hungry for theoretical knowledge even as we get caught up in our day-to-day work.

How to Say It for Data Engineers

I used to think people who made a big deal out of small syntactical or idiomatic differences were just being pedantic and condescending.

Cool Things in Snowflake

The title of this post would be “10 Things I Like to Use in Snowflake That You Could Google but First You’d Have to Know They Exist.

Genius in Tech

I just finished How Not to Be Wrong: The Power of Mathematical Thinking by Jordan Ellenberg and one particular section made me think of tech.

ELI5 - Cross Products

In order to understand cross products, you have to understand joins since cross products are a type of join.

ELI5 - Data Marts

In this post, I will explain the concept of data marts with approachable language, but I won't be talking to my 5 year old nephew Rhys.

ELI5 - Primary Keys

When I get requests to ingest or extract data as tables or reports, I often ask the requestor for the primary key.

ELI5 - Clustering

This Explain Like I’m 5 will be about clustering, a technique used by Snowflake, a cloud based data warehouse, to improve query performance.

A Memory in Tech

This is a real memory from when I was in first grade, so I was 6 to 7.

ELI5- Slowly Changing Dimensions

Explain like I’m 5 (ELI5) comes from the popular concept that if you really know something well, you can explain it simply, so a five year old can understand.

Database Storage

There are two types of relational database management systems: columnar and row-based, also called: column-wise and row-wise, column store and row store, column-based and row-based, and column-oriented and row-oriented.

Swearing in Tech

Ideally, we shouldn’t swear at work. If we lived in an ideal world though, I may not have a blog.

Beer in Tech

I’m wondering if beer in tech has reached its expiration date.

Names in Tech

Let me start by saying that I love my name. I love the way it sounds.