Sergey Olontsev

Build a query optimizer from scratch in 2 hours. Learn how databases execute queries efficiently by implementing parsing, plan generation, and cost-based optimization. Understand the principles behind real database optimizers.

Build a query optimizer from scratch in 2 hours. Learn how databases execute queries efficiently by implementing parsing, plan generation, and cost-based optimization. Understand the principles behind real database optimizers.

Ever wondered how applications communicate with databases? This session reveals what happens behind the scenes when connecting to SQL Server. We'll examine the protocol messages and demonstrate a Rust service implementing TDS, showing how query commands are processed and results formatted.

I'll demonstrate both approaches side by side. First, a live Text2SQL demo: what works and where it breaks down. Then, I'll explain semantic layers in detail: what they are, how to build them, and why they matter. Finally, I'll show an AI agent using both methods, comparing results directly. You'll see how semantic layers reduce errors and enforce business rules.