Database Indexing Deep Dive
2026-08-21 • 14 min read • Steve Lloyd
The Data Structure That Decides If Your Query Takes 2ms or 2 Minutes
SQL Query Optimization Techniques
2026-01-16 • 21 min read • Steve Lloyd
Rewriting queries for performance, avoiding common pitfalls, using statistics
Recursive Queries in SQL
2025-08-22 • 8 min read • Steve Lloyd
Using recursive CTEs to traverse hierarchies, trees, and graphs in a single query
SQL Window Functions
2025-08-15 • 8 min read • Steve Lloyd
The analytical superpower every data professional needs to master
Common Table Expressions in SQL
2025-08-08 • 5 min read • Steve Lloyd
The answer to making complex SQL more readable and maintainable
Relational Database Differences
2025-04-11 • 5 min read • Steve Lloyd
Comparing MySQL, PostgreSQL, MSSQL, Oracle, Snowflake, SAP HANA, SQLite, and DuckDB
JSON Recordsets are Your Friends
2025-01-24 • 3 min read • Steve Lloyd
Regardless of what database you use, you can probably harness JSON recordsets to improve your queries.