Mamakar Jetti·1d agoThe Hidden Cost of BigQuery: Why Query Design Matters More Than ComputeUnderstanding how data scanned, execution strategies, and SQL design influence performance and cost.
InTowards Data EngineeringbyPreethi Kaluva·Sep 20SQL Boo-Boos #10: Why My Query Got Slower Every Month (CTE Misuse, Exploding Scans, and Partition…I remember when this issue happened. Our analytics dashboard the one that shows the sales team their weekly numbers had timed out. Not…A response icon1A response icon1
Anna Likhachova·Sep 9SQL Query Optimization: How to Diagnose and Fix Expensive JOINsIf I were told that a query joining ten tables takes 30 seconds, I wouldn’t start by adding indexes or rewriting the joins.
InTowards Data EngineeringbyPreethi Kaluva·Sep 9SQL Boo-Boos #9: Why NULL Broke My Entire CASE StatementLet me set the scene.A response icon1A response icon1
Keerthiambati·Sep 9Performance Engineering in Practice, Part 6: Database IndexingFrom sequential scans to smarter indexing strategies
InData Engineer ThingsbySatadru·Sep 3Pushdown Optimization: Don’t Take It for GrantedIf you’ve worked with distributed computing or modern analytical databases, you’ve probably come across the idea of Predicate Pushdown…A response icon1A response icon1
Yaseer Arafat·Aug 30When a .NET Application Is Fast but the System Is SlowDiagnosing production latency across ASP.NET Core, EF Core, SQL Server, caching, Kubernetes, and observability
InLevel Up CodingbyAndreas Sujono·Aug 22Mastering Databases, Part 8: When the Disk Stops MatteringEvery article in this series has rested on one assumption: the disk is the bottleneck. That assumption is correct, it is how every database…
AshokReddy·Aug 15I Thought SELECT * Was Harmless — Then I Learned What SQL Was Actually DoingThe real problem isn’t the asterisk — it’s everything that happens after you ask the database for every column. See how SQL handles…
