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 aka.ms/sqlserver2022
Go through the learning module at learn.microsoft.com/en-us/tra...
🔴 Watch even more Data Exposed episodes: aka.ms/dataexposedyt
📌 Let's connect:
Twitter: Anna Hoffman, / analyticanna
Twitter: Bob Ward, / bobwardms
Twitter: AzureSQL, aka.ms/azuresqltw
🔔 Subscribe to our channels for even more SQL tips:
Microsoft Azure SQL: aka.ms/msazuresqlyt
Microsoft SQL Server: aka.ms/mssqlserveryt
Microsoft Developer: aka.ms/microsoftdeveloperyt
#AzureSQL #SQLServer #MicrosoftFabric
Негізгі бет Ғылым және технология SQL Integration with Microsoft Fabric | Data Exposed
Пікірлер