№ 02 / SUMMARIES

#sql

Every summary, chronological. Filter by category, tag, or source from the rail.

Tag · #sql
DAY 01Thursday JUN 25 · 20261 SUMMARIES
Google Cloud TechAI & LLMs

Powering Intelligent Agents with AI-Native Databases

Google Cloud is evolving databases into 'Agentic Data Clouds' by integrating AI primitives—like vector search, graph retrieval, and forecasting—directly into the SQL layer to provide agents with high-fidelity, secure, and real-time enterprise context.

Google Cloud Tech
DAY 02June 19, 2026 JUN 19 · 20261 SUMMARIES
Level Up CodingSoftware Engineering

Beyond the DELETE: Managing Bulk Data Operations in Production

Bulk deletion in production is not a SQL problem, but an operational one. Success requires managing database locks, replica lag, storage reclamation, and resumability, or better yet, designing for data lifecycle management from the start.

Level Up Coding
DAY 03May 27, 2026 MAY 27 · 20261 SUMMARIES
Google Cloud TechAI & LLMs

Using AI.AGG for Aggregate Data Reasoning in BigQuery

The AI.AGG function in BigQuery allows users to perform generative AI reasoning over entire groups of data using natural language instructions within a single line of SQL.

Google Cloud Tech
DAY 04April 8, 2026 APR 8 · 20261 SUMMARIES
Learning DataData Science & Visualization

SQL Execution Order Unlocks All Clauses

Databases run FROM/JOIN first, SELECT 8th—explains why SELECT aliases fail in WHERE/HAVING but work in ORDER BY, and WHERE filters rows before GROUP BY while HAVING filters groups after.

Learning Data

Showing 4 of 4