SQL Integration with Microsoft Fabric | Data Exposed

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:

📌 Let's connect:

🔔 Subscribe to our channels for even more SQL tips:

#AzureSQL #SQLServer #MicrosoftFabric

[SQLBrunoFonseca]

Hi! What's really the difference, just for an archive cold data perspective, between having the database files (*.mdf, *.ldf) located on a storage account container as a Page Blob files and this new CETAS approach with the parquet file (located also on a storage account container)?
Waiting your feedback.
Thanks,