Archive - Music and Tech

Denormalization And A Welcome Back

Data Modeling part 9 / Normalization part 5

Feb 9, 2022 •

March 2021

Dataset Normalization in Practice

Data Modeling part 8 / Normalization part 4

Mar 2, 2021 •

December 2020

What does 'Advanced SQL' mean?

It's all over job requirements but you never get a full picture answer from anyone

Dec 8, 2020 •

October 2020

How to Optimize Compression on Snowflake, Redshift, and BigQuery

Columnar Compression Explained and Deconstructed

Oct 20, 2020 •

September 2020

The Fall 2020 Job Hunt Letter

To Data/ML Engineering Job Hunters

Sep 11, 2020 •

August 2020

DML and DDL, Dark Horses Squared

A love letter to oft ignored database languages

Aug 23, 2020 •

June 2020

Automate Airflow Parameters

Speeding up Data Transformation with Reproducible Connections

Jun 29, 2020 •

Building a Robust Data Lake with Parquet

An overview of Data Lineage and Historical Analytics

Jun 1, 2020 •

April 2020

Interpreting Python Interpreters with Bash

Use bash to figure out your Python and Pip version bugs

Apr 10, 2020 •

March 2020

Data Modeling Articles

Articles I've written on Data Modeling

Mar 19, 2020 •

February 2020

Review of 11 Best Practices For Data Engineers

A Modern Data Infrastructure take on a vendor Email

Feb 24, 2020 •

Data Engineering Hierarchy of Needs

"Just My Thoughts" - Jay Z

Feb 5, 2020 •

#nojs-banner { position: fixed; bottom: 0; left: 0; padding: 16px 16px 16px 32px; width: 100%; box-sizing: border-box; background: red; color: white; font-family: -apple-system, "Segoe UI", Roboto, Helvetica, Arial, sans-serif, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol"; font-size: 13px; line-height: 13px; } #nojs-banner a { color: inherit; text-decoration: underline; } This site requires JavaScript to run correctly. Please turn on JavaScript or unblock scripts