Offload analytics to Azure using MI link
Learn how you can offload your analytics and reporting workloads to Azure SQL Managed Instance with MI link feature.
Link feature enables near real-time data replication from SQL Server to Azure SQL Managed Instance. The link provides hybrid flexibility and database mobility as it unlocks several scenarios, such as scaling read-only workloads, offloading analytics and reporting to Azure, and migrating to the cloud. And, with SQL Server 2022, the link feature enables disaster recovery.
Chapters:
00:08 Demo
00:30 PowerBI report on top of SQL MI data
00:45 Adding new data to the SQL Server
01:00 Refreshing report
Recommended content:
Overview of the Managed Instance link feature: https://learn.microsoft.com/azure/azu...
Announcing GA of the link feature for Azure SQL Managed Instance for SQL Server 2016 and 2019: https://techcommunity.microsoft.com/t...
What is Azure SQL Managed Instance: https://learn.microsoft.com/azure/azu...
2022 – a year of unparalleled innovation in Azure SQL Managed Instance: https://techcommunity.microsoft.com/t...