Data Modeling Best Practices: 7 Mistakes to Avoid
Seven common data modeling mistakes that cause reporting errors and slow analytics, with practical solutions to avoid them.
Seven common data modeling mistakes that cause reporting errors and slow analytics, with practical solutions to avoid them.
Explains the distinct roles of data catalogs and semantic layers in data architecture, arguing they are complementary tools.
Explains the difference between a metrics layer and a semantic layer in data architecture, clarifying their distinct roles and relationship.
Explains idempotent data pipelines, patterns like partition overwrite and MERGE, and how to prevent duplicate data during retries.
Argues that data quality must be enforced at the pipeline's ingestion point, not patched in dashboards, to ensure consistent, reliable data.
Compares Star Schema and Snowflake Schema data models, explaining their structures, trade-offs, and when to use each for optimal data warehousing.
Explores how AI-generated code creates 'cognitive debt'—a loss of system understanding—which can paralyze developers more than technical debt.
Announcing Interop 2026, a cross-browser initiative by major vendors to improve web platform feature compatibility and parity.
Anthropic's Claude Code creator discusses the evolving role of engineers and why developers are still crucial in the AI era.
A technical guide implementing Wagon's algorithm in Python to solve x² + y² = p for large primes, using quadratic residues and a modified Euclidean algorithm.
Explains how to compute a square root of -1 modulo a prime p, using number theory and Python code examples.
A guide to creating long-form TikTok videos using open-source AI models and tools like ComfyUI, focusing on automated, iterative video generation.
Explains an algorithm for finding a non-square modulo a prime, with Python code and examples from cryptography.
Weekly roundup of updates from .NET, Azure DevOps, GitHub, and Visual Studio blogs, covering new releases, features, and AI tools.
A technical overview of Microsoft's new Azure Virtual Network Routing Appliance (AVNRA), exploring its purpose, capabilities, and use cases for high-throughput network routing.
A developer shares his experience using Claude AI to accelerate coding tasks, including database support and performance optimizations.
A developer shares a real conversation with Claude Code, an AI coding assistant, to fix bugs in a Delphi IDE expert plugin.
Using Claude Code AI to fix complex bugs in the GExperts Delphi code formatter, including indentation issues in anonymous functions and repeat-until loops.
GExperts Reverse Statement expert upgraded with customizable regex rules for transforming Delphi code, including loops, function pairs, and assignments.
Thoughtworks retreat findings challenge the idea that AI replaces junior devs, highlighting their value and the challenges facing mid-level engineers.