Create Functions in SQL Server using T-SQL

Managing the "End" of a Data Pipeline

The Missing Piece in Many Data Pipelines

How to Pick Tools for a Data Stack (considerations)

The Power of Naming in Data Projects (especially dbt)

Getting Buy-In for Data & Analytics Projects (what to focus on)

You Don't Need to Learn Every Data Tool & Skill

How to Use Jinja w/ dbt Macros (3 Examples)

4 Reasons Why You Should STILL Learn SQL

Data Warehouse Security w/ 4 Simple Roles

How to Create a Data Modeling Pipeline (3 Layer Approach)

What is Data Mesh?

How to Build Incremental Models | dbt tutorial

Modern Data Engineering Workflows, Explained

Data Architecture 101: Kappa (Real-Time Data)

How to Refresh Data Models Daily (for free)

How to Sync PostgreSQL Data w/ Airbyte

Data Architecture 101: The Lambda Strategy

How to Run Queries from the Terminal (dbt Show Command)

Common Data Team Structures (Engineer vs Analyst vs Scientist)

Data Architecture 101: The Modern Data Warehouse

Why Data Migrations Go Wrong (3 reasons)

What are "intermediate" models in dbt?

dbt Environments vs Targets | What's the Difference?

Comparing 3 Types of Data Modeling (Normalized vs Star Schema vs Data Vault)