Engineering posts about SQL
Curated summaries and key learnings for engineers working with SQL.
Protect Performance and Reduce Surprise Costs with Default Warehouse
The article introduces the Default Warehouse feature in Databricks SQL, designed to enhance performance and cost efficiency by allowing administrators to set a default SQL warehouse for ad hoc...
What is a Relational Data Model?
The relational data model is a foundational framework for organizing data in structured tables, utilizing rows and columns to represent entities and their attributes. It employs keys to establish...
The Top 10 Best Practices for AI/BI Dashboards Performance Optimization (Part 1)
This article serves as a comprehensive guide for optimizing the performance of AI/BI dashboards within the Databricks environment. It outlines ten best practices aimed at enhancing dashboard...
Announcing support for GROUP BY, SUM, and other aggregation queries in R2 SQL
The article introduces the support for aggregation queries, including GROUP BY and SUM, in R2 SQL, Cloudflare's serverless analytics query engine. It explains the importance of aggregations in...