Blogs

2026 25 articles

Obsidian Vault to Enterprise Company Brain: Where Agents Write, Branch and Merge Sep 15

The Grammar of Data: From Definition to Execution Sep 14

Context, Semantics, and Ontology: A Primer for the Agentic Era Sep 12

If You Always Enjoy It, You're Not Pushing It Hard Enough—Benn Stancil (Show Your Workflow #1) Sep 11

Writing really is an Emotional Rollercoaster Aug 28

Figma for Agents: How Airflow's Creator Coordinates AI ft. Maxime Beauchemin Aug 06

The Act and the Outcome of Creation Jul 16

The Grammar of Data: Define Once, Run Anywhere with Cross-Engine Expressions Jul 08

Where AI Agents Belong in Data Engineering: The Correctness Layer Jul 07

The Process of Smart Note-Taking Jun 28

Operationalizing Data Orchestration: Best Practices for DevOps, Infra, and Code Locations Jun 27

Vibe Coding Is Dangerous, Agentic Engineering Isn't—Wes McKinney Jun 11

Beyond the Semantic Layer: Building a Context Layer for the Agentic Era Jun 11

The Dagster Almanack: From Complexity to Composability May 26

Plan Mode All the Time, Substrait over SQL, and the End of the DE Role ft. Chris Riccomini May 26

Internal vs. External Storage? What's the Limit of External Tables May 14

AI Reveals Why BI Still Matters Apr 21

Specs Over Vibes: Consistent AI Results ft. Mark Freeman Apr 08

Building an Agent-Friendly, Local-First Analytics Stack with MotherDuck and Rill Apr 07

Why I Still Blog — and Why the Future of Blogging Is Connected Mar 06

Git for Data Applied: Comparing Git-like Tools That Separate Metadata from Data Mar 04

Building an Obsidian RAG with DuckDB and MotherDuck Feb 13

Arch Linux (Omarchy) — 8 Months Later: The Good, the Bad, and the Fixable Feb 10

Why Coinbase and Pinterest Chose StarRocks: Lakehouse-Native Design and Fast Joins at Terabyte Scale Feb 09

A Diary of a Data Engineer Jan 13

2025 32 articles

Well Being in Times of Algorithms Dec 22

Opinionated Data Platforms vs. Open-Source: The Chef’s Choice for Your Data Platform Dec 10

Simplicity of a Database, but the Speed of a Cache: OLAP Caches for DuckDB Dec 09

Dlt+ClickHouse+Rill: Multi-Cloud Cost Analytics, Cloud-Ready Dec 04

Branch, Test, Deploy: A Git-Inspired Approach for Data Dec 03

Multi-Cloud Cost Analytics: From Cost-Export to Parquet to Rill Nov 21

Boredom is the New Luxury Nov 18

4 Senior Data Engineers Answer 10 Top Reddit Questions Nov 03

Data Modeling for the Agentic Era: Semantics, Speed, and Stewardship Oct 17

Beyond Basic ETL: Enterprise Data Capabilities Without the Complexity Oct 13

Why I Don't Research; and Write from Experience Sep 17

Data Modeling Guide for Real-Time Analytics with ClickHouse Sep 05

Why Semantic Layers Matter—and How to Build One with DuckDB Aug 24

My Journey from macOS to Arch Linux with Omarchy Aug 07

Summer Data Engineering Roadmap Aug 06

Why Are We Here on Earth? True Happiness, Giving Up Control, or the Trap of Worshipping Earthly Things? Aug 02

The Data Engineering Toolkit: Infrastructure, DevOps, and Beyond Jul 10

Has Self-Serve BI Finally Arrived Thanks to AI? Jul 09

Universal Data Orchestrator in Action: Enterprise Best Practices Jun 17

The Open Lakehouse Stack: DuckDB and the Rise of Table Formats Jun 16

Self-Host & Tech Independence: The Joy of Building Your Own Jun 07

The Open Table Format Revolution: Why Hyperscalers Are Betting on Managed Iceberg May 20

Configure, Don't Code: How Declarative Data Stacks Enable Enterprise Scale May 20

The Data Engineer's Guide to Efficient Log Parsing with DuckDB/MotherDuck Apr 21

The Universal Data Orchestrator: The Heartbeat of Data Engineering Apr 15

What «Shifting Left» Means and Why it Matters for Data Stacks Apr 14

Vector Technologies for AI: Extending Your Existing Data Stack Mar 28

Scaling Beyond Postgres: How to Choose a Real-Time Analytical Database Mar 11

A Beginner’s Guide to Geospatial with DuckDB Feb 26

Finding Flow: Escaping Digital Distractions Through Deep Work and Slow Living Feb 14

Why Pivot Tables Never Die Feb 03

The Data Engineering Toolkit: Essential Tools for Your Machine Jan 22

2024 10 articles

Designing a Declarative Data Stack: From Theory to Practice Dec 20

Semantic Layer and AI: The Future of Data Querying with Natural Language Dec 19

Universal Semantic Layer: Capabilities, Integrations, and Enterprise Benefits Dec 04

Building with Bluesky: Inside the New Open Social Network Nov 27

Exploring the Semantic Layer Through the Lens of MVC Nov 19

15+ Companies Using DuckDB in Production: A Comprehensive Guide Nov 12

BI-as-Code and the New Era of GenBI Nov 05

The Enterprise Case for DuckDB: 5 Key Categories and Why Use It Oct 16

The Rise of the Declarative Data Stack Oct 16

My Obsidian Note-Taking Workflow Jul 25

2023 9 articles

The Plain Text Workflow: How Vim and Markdown Became My Backbone Dec 10

Data Modeling - The Unsung Hero of Data Engineering: Architecture Pattern, Tools and the Future (Part 3) May 26

Data Modeling – The Unsung Hero of Data Engineering: Modeling Approaches and Techniques (Part 2) May 03

Data Modeling – The Unsung Hero of Data Engineering: An Introduction to Data Modeling (Part 1) Apr 03

Pandas 2.0 and its Ecosystem (Arrow, Polars, DuckDB) Mar 08

Finding My Pathless Path Feb 25

Modern Data Stack: The Struggle of Enterprise Adoption Jan 09

Why Vim Is More than Just an Editor – Vim Language, Motions, and Modes Explained Jan 04

The Open Data Stack Distilled into Four Core Tools Jan 03

2022 7 articles

Data Integration as Code: Configuring Airbyte and dbt with Python (Dagster) Dec 19

Rust for Data Engineering Oct 19

The Rise of the Semantic Layer Sep 29

Data Lake / Lakehouse Guide: Powered by Data Lake Table Formats (Delta Lake, Iceberg, Hudi) Aug 25

Data Orchestration Trends: The Shift From Data Pipelines to Data Products Jun 14

Personal Knowledge Management Workflow for a Deeper Life — as a Computer Scientist Apr 06

Building an Analytics API with GraphQL: The Next Level of Data Engineering? Jan 22

2021 3 articles

How to Take Notes in 2021? Sep 28

Saying Goodbye to WordPress, a Homecoming Apr 05

Building a Data Engineering Project in 20 Minutes Mar 09

2020 1 article

Business Intelligence meets Data Engineering with Emerging Technologies Jun 14

2019 1 article

Email, and the way we (should) communicate at work Apr 25

2018 5 articles

Open-Source Data Warehousing – Druid, Apache Airflow & Superset Nov 29

OLAP, what’s coming next? Nov 23

Today’s Office – The Location Independent Lifestyle Jun 18

Tools I Use – Part III Apr 07

Data Engineering, the future of Data Warehousing? Mar 08

2017 8 articles

Data Warehouse vs Data Lake | ETL vs ELT Oct 26

Tools I Use – Microsoft OneNote – Part II Aug 22

What Data Warehouse Automation tools are on the market Jul 25

Why automate? What does Data Warehouse Automation for us? Jul 07

Why Data Warehouse Automation is not more popular Jun 28

Data Warehouse Automation (DWA) – Series Jun 28

Tools I Use May 22

The more you share the more you get.. May 10

2016 3 articles

Migrate from Oracle to Microsoft (Views) – Part III Sep 24

Migrate from Oracle to Microsoft (Views) – Part II Sep 24

Migrate from Oracle to Microsoft (Views) – Part I Sep 24

2015 5 articles

SSAS Cubes – Dynamic generation of partition Oct 09

Need any Headphones? Oct 09

Do you listen to music while working? Oct 09

Annoying advertising, what you can do Sep 19

ORDER BY Oracle vs. Microsoft SQL Sep 19

/ Blogs