Synapse Espresso: Using Replicated tables in Dedicated SQL Pools

Published: 08 December 2022
on channel: Azure Synapse Analytics

1,029

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

On this page of the site you can watch the video online Synapse Espresso: Using Replicated tables in Dedicated SQL Pools with a duration of hours minute second in good quality, which was uploaded by the user Azure Synapse Analytics 08 December 2022, share the link with friends and acquaintances, this video has already been watched 1,029 times on youtube and it was liked by 32 viewers. Enjoy your viewing!

38,835

566