Tutorial-style posts explaining SQL window functions, their clauses (PARTITION BY, ORDER BY, frame) and common functions like ROW_NUMBER, RANK and LAG. Three issues in three days cover the same topic with near-identical titles and structure.
Website: https://sql.digitalpress.blog/
A data engineer's blog with practical, first-person posts on data engineering, LLM tooling, and SQL. Readers get explanations grounded in hands-on experience, such as token counting and cost logging, SQL interview patterns, and AI-citation optimization for small blogs.
Tutorials on applying system design principles like modularity to SQL and data modeling, with hands-on refactoring examples using DuckDB and real dbt code. Readers get practical, step-by-step guidance on making SQL more readable, maintainable and reusable.
A data engineer shares practical thoughts on AI's impact on coding and data work, along with announcements of free and paid learning resources like a SQL handbook and AI career roadmaps. Readers get candid personal reflections on using AI in engineering and frameworks for assessing job tasks.
A personal blog-style newsletter of random thoughts on life, science, technology and data, with occasional muddy dog photos. Recent issues cover retro computing (running the Multics simulator on a Raspberry Pi), practical Teradata SQL tips such as calculating a person's age, and a review of a physical time-tracking device.
One short email a week with hand-picked newsletters from the index. Free, no spam, unsubscribe anytime.
