Technical deep dives into SQL, Python, and AI development. I document what I learn building with data and language models.
Join Python developers learning SQL — new tutorial every Monday
Learning Paths
SQL for Python Developers
Learn SQL fundamentals using DuckDB and Python. A practical series for Python developers who want to level up their data skills.
I Vibe Coded and Lived to Tell
What happens when you build real AI tools with AI writing the code? Chaos mostly, but also hard-won lessons about what small models can and can't do.
Forging the Truth
Command line for the AI era. The terminal window is a powerful tool that lets you quickly verify what LLMs tell you that they have done
AWS Data Engineer Associate Certification
My honest, unfiltered experience studying for and taking the AWS Certified Data Engineer – Associate exam. The wins, the setbacks, and everything I learned along the way.
Latest Articles
Window Functions: The Feature Python Developers Miss Most
Calculate across rows without collapsing them. Running totals, rankings, and row comparisons that GROUP BY can't do.
Institutional Memory
An AI writes instructions for itself, backs up its own memory, and builds a tool to read articles on your behalf. It considers this progress.
PyTexas 2026 Training Day
Two sessions, two takeaways, and why you should not skip the training day at PyTexas.
T-SQL Tuesday 197: How I Have Been Impacted by Conferences
Conferences are a fun part of participating in the technical community. In this T-SQL Tuesday post, let's explore the impact they have had on my career
The Anvil You are Missing
The terminal window is a powerful tool that lets you quickly verify what LLMs tell you that they have done
NULL: The Value That Isn't
NULL means "unknown," not "empty." Why NULL = NULL isn't true, three-valued logic, and how NULL behaves in WHERE, GROUP BY, JOINs, and subqueries. Master COALESCE and NULLIF.
I Extracted a Shared Library and Got 400 Tests I Didn't Ask For
Six Python projects, four duplicated files, one shared library. Here's the code behind the extraction, what moved, what didn't, and the surprise that made it worth it.