
Mark Pryce-Maher
Senior Program Manager - Microsoft Fabric
Norwich, United Kingdom
Mark Pryce-Maher is a Senior Program Manager on Microsoft Fabric. Primary focusing on the User Experiences and Migrations for the Data Warehouse. Mark has spent the last 6 years at Microsoft in the Big Data space, including helping many customers migrate from Netezza, Teradata, Oracle, APS, SQL Server to Synapse Data Warehouse.
Links
Area of Expertise
Topics
Dedicated SQL Pools : How some stuff 'really' works
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.

Mark Pryce-Maher
Senior Program Manager - Microsoft Fabric
Norwich, United Kingdom