Most Active Speaker

Mark Pryce-Maher

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 Mirroring, User Experiences and Migrations for the Data Warehouse. Mark has spent the last 7 years at Microsoft in the Big Data space, including helping many customers migrate from Netezza, Teradata, Oracle, APS, SQL Server to Synapse Data Warehouse.

Awards

  • Most Active Speaker 2023

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.

Data Platform Next Step 2023 Sessionize Event

June 2023 Billund, Denmark

SQLBits 2023 - Full day training sessions Sessionize Event

March 2023 Newport, United Kingdom

Mark Pryce-Maher

Senior Program Manager - Microsoft Fabric

Norwich, United Kingdom