Synapse Link to SQL, bring your on-prem data alive

on YouTube ↗23m

" summary

Shows how Synapse Link to SQL moves on‑prem SQL Server 2022 or Azure SQL Database into an Azure Synapse dedicated SQL pool using ADLS as the landing zone and a self-hosted integration runtime for on‑prem. Demonstrates a live run: initial full snapshot then CDC keeps inserts, updates, deletes synced (demo goes from 12 to 14 rows), explains table restrictions (primary key, data types), publish step, core count affects throughput and cost, and notes you cannot apply DDL while the link is running.

AI-written summary · about

" chapters (8)

1. 0:00Introduction and agenda
2. 1:24What is Synapse Link?
3. 2:50Prerequisites and setup
4. 4:27Live demo: Initial sync
5. 10:03Demo: Data synchronization
6. 12:15Adding new tables
7. 18:00Performance and cost
8. 19:30Best practices and Q&A

" related talks

• 19mNever ETL again, thanks to Synapse Link. Really?Ben Weissman · SQLBits 2023
• 24mSynapse AnalyticsCharles Feddersen · DataEngBytes 2020
• 21mAzure Synapse Link for Dataverse ImplementationAoife Turley · SQLBits 2023
• 54mAn introduction to Azure Synapse Analytics!Mahesh Balija · SQLBits 2020
• 53mAzure Synapse Analytics: Evolving Azure SQL Data WarehouseMark Pryce-Maher, Artur Vieira · SQLBits 2020
• 45mWhat's New and Cool in Azure Synapse AnalyticsPawel Potasinski, Stijn Wynants · SQLBits 2023
• 46mThe Ultimate Jigsaw - Architecting Azure Synapse AnalyticsHeini Ilmarinen · Women Data Summit 2021
• 28mArchitecture patterns of Azure Cosmos DB & Azure Synapse AnalyticsHiroyuki Nakazato · Azure Cosmos DB Conf 2022