SQL Database in Fabric - OLTP Meets Analytics

🔄 SQL Database in Fabric - OLTP Meets Analytics (Translytical Pattern) An OLTP database inside an analytics platform — why? SQL Database in Fabric brings transactional workloads into Fabric with automatic mirroring to OneLake. In this Fabric Friday episode, I explain the architecture (TDS/GraphQL → SQL Database → Change Feed → Delta Parquet → OneLake), show the decision tree for choosing between SQL options, demonstrate the billing model (the 15-minute cooldown trap!), and walk through the translytical pattern. 📋 Chapters: 00:00 Introduction – OLTP in Fabric 00:44 Architecture: Application → SQL Database → Auto-Mirror 03:00 Access Paths: SQL Endpoint, Spark, Power BI Direct Lake 05:06 Demo: Create Lakehouse & Ingest Data 10:30 Read/Write Handling: Write Path vs. Mirror Path vs. Read Path 14:00 Decision Tree: SQL in Fabric 17:00 Demo: Import Data with Notebook 20:30 Billing Deep Dive: Idle → Active → Cooldown 25:00 The 15-Minute Cooldown Trap 28:00 Demo: Connect from VS Code 30:00 Security: Row-Level Security Demo 33:00 Performance: Views in Semantic Models (Direct Query Fallback) 36:00 Translytical Pattern: OLTP + Analytics in One 40:00 Community Q&A: CU Costs, F2 Capacity Issues 46:00 Outro 🔗 Links & Resources: 📖 SQL Database Overview: https://learn.microsoft.com/en-us/fabric/database/sql/overview 📖 Create SQL Database: https://learn.microsoft.com/en-us/fabric/database/sql/create 📖 Decision Guide: https://learn.microsoft.com/en-us/fabric/database/sql/decision-guide 📖 Feature Comparison vs Azure SQL: https://learn.microsoft.com/en-us/fabric/database/sql/feature-comparison-sql-database-fabric 📖 Mirroring Overview: https://learn.microsoft.com/en-us/fabric/database/sql/mirroring-overview 📖 GraphQL API: https://learn.microsoft.com/en-us/fabric/database/sql/graphql-api 📖 Usage Reporting: https://learn.microsoft.com/en-us/fabric/database/sql/usage-reporting 🧪 Fabric Periodic Table: https://fabric-periodic-table.com 👤 About me: Matthias Falland – The Trusted Advisor Microsoft Data Platform MVP 🌐 https://www.the-trusted-advisor.com 🔗 LinkedIn: https://www.linkedin.com/in/intune/ 🎓 Fabric Periodic Table: https://fabric-periodic-table.com 📍 Fabric Community Meetup (Zürich/Hamburg/Basel): https://www.meetup.com/ai-and-intelligent-cloud/