Synapse Espresso: Using Replicated tables in Dedicated SQL Pools

Welcome to the 16th video of the Synapse Espresso series! In this video, Stijn is joined by Liliam and a special guest, Luca, to talk about how replicated tables works in dedicated SQL pools. Click play to learn how and when to use replicated tables.

Timestamp:
00:00:30 - Introduction
00:00:34 - FTA guest introduction
00:01:00 - What are replicated tables?
00:01:40 - When use replicated tables?
00:02:34 - How the replicate table works internally?
00:04:06 - Demo
00:06:20 - Summary

Stijn Wynants - Fast track Engineer
  / stijn-wynants-ba528660  
https://sql-stijn.com/
  / sqlstijnn  

Liliam Cristiman Leme - Fast Track Engineer
LinkedIn:   / liliam-cristiman-leme-52891965  
Twitter:   / @lemeliliam  
Contributor on Azure Synapse Analytics Blog: https://techcommunity.microsoft.com/t...

Luca Ferrari - Fast Track Engineer
LinkedIn:   / luca-ferrari-89b1312a  


More examples of Dedicated SQL Pool through a series of challenges
What The Hack - Synapse Dedicated SQL Pool - https://microsoft.github.io/WhatTheHa...

Links:
Dedicated SQL pool (formerly SQL DW) architecture - https://learn.microsoft.com/en-us/azu...
Design guidance for replicated tables - https://learn.microsoft.com/en-us/azu...
How to minimize data movements (Compatible and Incompatible Joins) -https://techcommunity.microsoft.com/t...

#azuresynapse #sql