Databases
Stored Procedures: When to Use Them, When to Avoid Them
Opinionated guide to stored procedures covering performance benefits, maintainability costs, security implications, and practical guidelines for when they help vs hurt.
SQL
Databases
Database Normalization and Denormalization: When to Use Each and Why
Practical guide to database normalization and denormalization with real-world examples, covering normal forms, performance tradeoffs, and when to break the rules.
Data & Analytics
dbt Explained: The Data Transformation Tool That Rewired How We Think About Analytics Engineering
dbt turned SQL-writing data analysts into software engineers without them noticing. Here's how it works, why it matters, and how to use it in production without shooting yourself in the foot.
Databases
SQL vs NoSQL Databases: Architecture, Trade-offs, and Choosing the Right One
SQL and NoSQL databases are not interchangeable. A principal architect with 30 years of database experience explains the real differences and when to use each.