Name: 8th Oct 25| East Midlands Data | Derby | Speaker - Mark Pryce-Maher
Start: 2025-10-08T18:00:00+01:00
End: 2025-10-08T20:30:00+01:00
Location: Waterfall

**___________________________________________________________________________________**

**MeetUp Agenda**

18:00 - Arrive. Networking
18:30 - Guest Speaker Talk
19:30 - Buffet. Networking
20:30 - Event Close

**___________________________________________________________________________________**

**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.
**___________________________________________________________________________________**

**Venue Website**

[http://www.waterfall-derby.com/](http://www.waterfall-derby.com/)

**___________________________________________________________________________________**

**Sponsors**

Cloud Formations
[https://www.cloudformations.org](https://www.cloudformations.org)

**___________________________________________________________________________________**

**Microsoft Community Code of Conduct**

[https://answers.microsoft.com/en-us/page/codeofconduct](https://answers.microsoft.com/en-us/page/codeofconduct)

**___________________________________________________________________________________**

Paul Andrew

East Midlands Data

Azure Data Tech Groups

No Nonsense Consulting - Data Strategy, Design, Delivery, and Training

Cloud Formations Ltd

Specialties in recruitment, resourcing and head hunting.

RP Analytics

Community-led MeetUp groups focused on data platform technology.

Microsoft

Technology

Database Professionals

SQL Server

Business Intelligence

Database Development

Data Analytics

SQL Azure

Business Intelligence & Data Warehousing

Data Management

Microsoft Azure

Power BI

Data Architecture

Big Data

Data Visualization

Data Science

Stuart Moore

Jon Gregory

Alastair Reilly

Gavin Campbell

Richard Douglas

Andy J

Deborah-Jayne Evans

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.

Mark Pryce-Maher