SQL to LINQ LEFT JOIN Masterclass: EF Core 10 and Modern Data Access
Discover the revolutionary LeftJoin operator introduced in EF Core 10: relief from GroupJoin complexity, mental model compatibility between SQL and LINQ…
SQL in Production (SQL)
Posts about sql
How Does a Vertical Slice Work from the Inside?
A technical guide to the inner flow of a Vertical Slice: request, validation, handler, aggregate, outbox, projection, idempotency, performance, tests, and…
Why ERP (Enterprise Resource Planning) MySQL Is Not an Analytics Store
MySQL written by an internal ERP is operational truth — geographic analysis and wait hotspots need a cleansed analytics store.
Cleansing Operational Data into PostgreSQL
Cleansing Operational Data into PostgreSQL — a production lesson from an ABC Logistics backend/data platform.
PostGIS for Fleet and Yard Truth
PostGIS for Fleet and Yard Truth — a production lesson from an ABC Logistics backend/data platform.
MongoDB for High-Frequency Telemetry
MongoDB for High-Frequency Telemetry — a production lesson from an ABC Logistics backend/data platform.
Elasticsearch for Ops Search Across Entities
Elasticsearch for Ops Search Across Entities — a production lesson from an ABC Logistics backend/data platform.
Multi-Node Clusters Without the Single-Brain Myth
Multi-Node Clusters Without the Single-Brain Myth — a production lesson from an ABC Logistics backend/data platform.
Anti-Corruption Between ERP (Enterprise Resource Planning) and Analytics
Anti-Corruption Between ERP and Analytics — a production lesson from an ABC Logistics backend/data platform.
Serving Clean Reads to Ops Frontends
Serving Clean Reads to Ops Frontends — a production lesson from an ABC Logistics backend/data platform.
Data Contracts for Geofence and Expeditions
Data Contracts for Geofence and Expeditions — a production lesson from an ABC Logistics backend/data platform.
Observing Lag Across Polyglot Stores
Observing Lag Across Polyglot Stores — a production lesson from an ABC Logistics backend/data platform.