SQL in Fabric - Warehouse, Lakehouse or SQL Database?

🎯 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

Agenda

#

Who should attend

#

SQL Developers evaluating Fabric, Data Architects designing analytics platforms, DBAs planning migrations.

Part of the monthly Fabric Meetup Series by The Trusted Advisor.