The Augmented Dev · Archive

All articles

Dynamics 365, Power Platform, AI, system design, and web development — filter by theme or search across every post.

4 of 225 articles tagged data-engineering

Jul 5, 202610 min read

CI/CD Pipelines for Data Engineers

Data pipelines are production software. Here's how to build CI/CD that catches bad transforms before they corrupt dashboards: testing strategy, environment promotion, slim runs, and rollback patterns.

devops data-engineering

Jul 5, 202610 min read

Columnar Storage: How Analytical Databases Work Under the Hood

Why column-oriented databases run analytical queries 100x faster than row-oriented ones — covering physical layout, compression algorithms, vectorized execution, and predicate pushdown with concrete examples.

system-design data-engineering

Jul 5, 202610 min read

dbt Best Practices for Production Data Modeling

Hard-won lessons for structuring dbt projects that scale: layer conventions, testing strategies, slim CI runs, incremental models, and documentation that doesn't rot.

data-engineering

Apr 16, 202612 min read

Snowflake Security in Layers: Roles, Column Masking, Row Policies, and Environment Controls

A practical walkthrough of Snowflake's four security layers — role hierarchy, column-level masking policies, row access policies, and environment isolation — with real SQL examples.

tutorial data-engineering snowflake

Newsletter

New posts, straight to your inbox

One email per post. No spam, no tracking pixels, unsubscribe anytime.