A Deep Dive into Microsoft Fabric Data Warehouse

Dive deep into the world of Microsoft Fabric Data Warehouse in this 51-minute conference talk from SQLBits. Explore the core concepts, creation process, and key features of data warehousing in Microsoft Fabric. Learn about warehouse properties, Azure Storage Explorer integration, and SQL Studio functionality. Discover how to create a Lake House, utilize SparkSQL Analytics Endpoint, and manage cloning operations. Gain insights into access management, permissions, and the differences between Microsoft Fabric Data Warehouse and SQL Server. Understand mirroring techniques and provide valuable feedback to enhance your data warehousing experience. Presented by Jerry Nixon and Mark Pryce-Maher, a Data Architect on the Azure Synapse Analytics Customer Success Engineering team at Microsoft, this talk offers expert knowledge and practical strategies for effectively leveraging Microsoft Fabric Data Warehouse in your data architecture.

Introduction
What is the Data Warehouse
Creating a Warehouse
Properties
Azure Storage Explorer
SQL Studio
Create a Lake House
Spark
SQL Analytics Endpoint
Clone
Manage Access
Permissions
Differences from SQL Server
Mirroring
Feedback