Episode

SQL Integration with Microsoft Fabric | Data Exposed

with Anna Hoffman, Bob Ward

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.

Chapters

  • 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

Connect

Azure
Azure SQL Database
SQL Server
Microsoft Fabric
SQL