Sign in to confirm you’re not a bot
This helps protect our community. Learn more

SQL Integration with Microsoft Fabric | Data Exposed

Microsoft Developer
589K subscribers
<__slot-el>
<__slot-el>
4.5K views 1 year ago #MicrosoftFabric #SQLServer #AzureSQL
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 htt …...more
...more

Introduction

0:18

Microsoft Fabric Overview

0:52

Data Integration and Virtualization

1:48

SQL Server CETAS to Cold Storage

2:11

Demo of CETAS using Partitions

3:12

Moving Cold Storage to Fabric Storage

5:15

Demo of using Fabric Shortcuts to Cold Storage

5:35

Loading data to a Fabric Delta Table

7:25

Integrate data with Excel files using OneDrive and OneLake

8:30

Create a Power BI report over the integrated data

9:35

Data duplication or reference

11:45

Fabric futures

12:37

Resources for learning more

13:00

Closing

13:39
SQL Integration with Microsoft Fabric | Data Exposed
128Likes
4,566Views
2023Jun 29
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/tra... 🔴 Watch even more Data Exposed episodes: https://aka.ms/dataexposedyt 📌 Let's connect: Twitter: Anna Hoffman,   / analyticanna​​​   Twitter: Bob Ward,   / 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 #AzureSQL #SQLServer #MicrosoftFabric

Follow along using the transcript.

Microsoft Developer

589K subscribers