Reconcile at the Same Grain
Align population, units and reporting boundaries before comparing totals, and keep missing keys distinct from value differences.
5 min readRead article
SQL, models & data integrity
Articles
Original guides and technical studies, written to make the assumptions and trade-offs visible.
Matching articles
1 articleFrom the wider community
Engineering Feed
Publications from DEV Community. Titles and summaries are attributed to their original authors; the links open the original articles.
Data Modelling, Relationships And Joins In Power BI
Introduction This article takes through the ideas that decide whether a model works as...
SQL Agents Need Business Context, Not Just Schema
How knowledge graphs encode metric definitions and join rules so SQL agents can generate correct queries from ambiguous business questions.
The FETCH FIRST story: from ROW_NUMBER() in 12c back to ROWNUM in 23ai, and a LIMIT equivalent for PostgreSQL
The FETCH FIRST ... ROWS ONLY clause arrived in the SQL standard with SQL:2008, and Oracle Database...
Your Database Is Small. That Doesn’t Mean Your Queries Are Fast
“My database is only 50 MB. Why is my API slow?” It's an easy assumption to make. Small database =...
How I Built a Two-Tier Data Platform in 9 Phases (Spark, Kafka, dbt, Kubernetes)
A complete data platform — batch + streaming, single-node + distributed, local + Kubernetes. What I built, what broke, and what I learned.
Your Oracle Traffic Is Readable on the Wire. Here's the Proof, and the Fix.
By default an Oracle client and server negotiate no encryption, so every query and every row crosses the network in readable bytes. A packet-capture lab shows the SQL and a confidential value in plaintext, then four lines of sqlnet.ora (REQ