SQL Integration with Microsoft Fabric | Data Exposed

From the creator

In this episode of Data Exposed with Anna Hoffman and Bob Ward, we will show you how to archive “cold” data using new data virtualization capabilities in SQL Server 2022. Then we will show you how to utilize the cold data for trend analysis using the new Microsoft Fabric. A true hybrid cloud story. 00:18 - Introduction 00:52 - Microsoft Fabric Overview 01:48 - Data Integration and Virtualization 02:11 - SQL Server CETAS to Cold Storage 03:12 - Demo of CETAS using Partitions 05:15 - Moving Cold Storage to Fabric Storage 05:35 - Demo of using Fabric Shortcuts to Cold Storage 07:25 - Loading data to a Fabric Delta Table 08:30 - Integrate data with Excel files using OneDrive and OneLake 09:35 - Create a Power BI report over the integrated data 11:45 - Data duplication or reference 12:37 - Fabric futures 13:00 - Resources for learning more 13:39 - Closing ✔️ Resources: Learn more at https://aka.ms/sqlserver2022 Go through the learning module at https://learn.microsoft.com/en-us/training/modules/introduction-to-sql-server-2022/ 🔴 Watch even more Data Exposed episodes: https://aka.ms/dataexposedyt 📌 Let's connect: Twitter: Anna Hoffman, https://twitter.com/AnalyticAnna​​​ Twitter: Bob Ward, https://twitter.com/BobWardMS Twitter: AzureSQL, https://aka.ms/azuresqltw​​​ 🔔 Subscribe to our channels for even more SQL tips: Microsoft Azure SQL: https://aka.ms/msazuresqlyt Microsoft SQL Server: https://aka.ms/mssqlserveryt Microsoft Developer: https://aka.ms/microsoftdeveloperyt #Azu

Published 2023-06-29 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.