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.

Area of Expertise

Information & Communications Technology

Topics

SQL Server
Azure SQL Database
SQL Server Data Tools
SQL Server Integration Services
Power BI
Data
Databases

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.