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
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
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.
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
Creating Tables: DDL for Python Devs
Map Python types to SQL types. Learn CREATE TABLE with primary keys, foreign keys, and constraints like NOT NULL and DEFAULT.
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