Posts

Primary Keys in Snowflake are Very Demure, Very Mindful Aug 22, 2024 Select Statements in Snowflake are Having a brat Summer Aug 12, 2024
SQL Window Functions: I guess that's why they call it window pain Feb 19, 2021
How the Snowflake Qualify Clause Changed My Life Jan 31, 2021
Data Engineering Project Idea for People Getting into Data Engineering Jan 18, 2021
How to Document a Data Pipeline Dec 6, 2020
Views in Snowflake Nov 24, 2020
Table Types in Snowflake Nov 20, 2020
A Day in the Life of a Data Engineer Nov 19, 2020
Things I Sometimes Do in Snowflake That You Shouldn't Do Nov 14, 2020
Common Excel Functions in SQL Nov 1, 2020
A Good Day to Delete Hard Oct 12, 2019
Much Ado About NULL Things Oct 12, 2019
CTEs versus Subqueries Oct 2, 2019
Normal Forms for Normal People Sep 1, 2019
Functions in Where Clauses Aug 18, 2019
How to Say It for Data Engineers Aug 12, 2019
Cool Things in Snowflake Aug 6, 2019
ELI5 - Primary Keys Aug 15, 2018
ELI5 - Clustering Aug 10, 2018
ELI5- Slowly Changing Dimensions Jul 18, 2018
Database Storage Jul 3, 2018