Mark Pryce-Maher
geeksonscreens.com
Mark Pryce-Maher s a Data Architect on the Azure Synapse Analytics Customer Success Engineering team at Microsoft, where he his working with customers implementing Azure Synapse Analytics.
SQLBits 2022
Dedicated SQL Pools : How some stuff 'really' works
Session covering table distributions, partitioning , RSC and materialised views.
In the session we look at a few features as Azure Synapse Dedicated SQL Pools;
* Table Distributions
* Partitioning
* Result set caching
* materialized views.
We will cover these great features; When to use them but also which situations when not to use them and why.
This is a L400 session, so you will be expected to have used SQLDW or Synapse Dedicated SQL Pools , not just skimmed the documentation. :-) If you don't know your Round Robin from your Clustered Column Stored Index, then maybe this isn't the session for you.
Feedback Link - https://sqlb.it/?6969
* Table Distributions
* Partitioning
* Result set caching
* materialized views.
We will cover these great features; When to use them but also which situations when not to use them and why.
This is a L400 session, so you will be expected to have used SQLDW or Synapse Dedicated SQL Pools , not just skimmed the documentation. :-) If you don't know your Round Robin from your Clustered Column Stored Index, then maybe this isn't the session for you.
Feedback Link - https://sqlb.it/?6969