Skip to content

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

Members are also interested in