SQL in Fabric - Warehouse, Lakehouse or SQL Database?
Details
ð¯ The Problem: Three ways to run SQL in Fabric. Three different architectures. Three different use cases. The wrong choice means rebuilding everything in 6 months. Which one is actually right for YOUR workload?
ð¡ This Evening: We'll demystify Warehouse vs. SQL Endpoint vs. SQL Database with a clear decision tree. Plus: Copy Jobs and Airflow for data loading at scale.
â±ïž Save yourself: The pain of discovering you picked the wrong SQL architecture after going to production.
What you'll learn:
ð¢ Fabric Warehouse - T-SQL at scale with automatic distribution, and WHY Warehouse uses columnstore and distribution keys
ð SQL Analytics Endpoint - SQL access to Lakehouse tables, and WHY the endpoint is read-only (Delta Lake transaction safety)
ðŸ SQL Database in Fabric - Full OLTP capabilities in Fabric, and WHY SQL Database completes the Fabric story
ð¥ Copy Jobs & Airflow - Bulk data loading and enterprise orchestration, and WHY Copy Jobs replace complex SSIS packages
Decision Framework:
- Need OLTP (transactions, updates)? â SQL Database
- Need analytics at scale with Lakehouse? â SQL Endpoint
- Need pure SQL analytics workload? â Warehouse
- Need both OLTP and analytics? â SQL Database + Mirroring
Who should attend: SQL Developers evaluating Fabric, Data Architects designing analytics platforms, DBAs planning migrations
Agenda:
- 18:30 - Welcome & Networking
- 18:45 - Warehouse Deep Dive
- 19:10 - SQL Endpoint vs Warehouse
- 19:30 - SQL Database - The Missing Piece
- 19:45 - Copy Jobs & Airflow Overview
- 19:55 - Q&A and Discussion
- 20:00 - Networking
