How to build a data warehouse solution for your analytical workloads

In the day long session some of the experts from Microsoft who implement the biggest data warehouses (Dedicated SQL Pools) show you how it's done.

We will cover;
* A brief overview of Azure Synapse Analytics
* Setup including stuff you must know before you go clicking things.
* Migrations
* Tables geometry (CCI/Heaps/CI/Round Robin/Replicated tables/hash)
* Data Loading - Best practices, hints and tips
* Workload management (WLM) - working out the best workload groups.
* Maintenance
* Managing different workloads
* Exporting/Sharing Data.
* Security
* Tuning

The ideal attendees will have been using dedicated SQL Pools for 3 months or someone is migrating an existing data warehouse.

Feedback LInk -

Starts: 09:00 8th Mar 2022
Ends: 17:00 8th Mar 2022


Short Description
- Learn how to implement a data warehouse analytics solution with Azure Synapse. We will cover best practices on migrations, performance, security, and more!
Should delegates bring a laptop with them?
- Yes
What is the structure of the day?
- Full day training
What internet requirements do the delegates have?
- Need fast and reliable internet for all attendees
What will the delegates get out of the day?
- Learn how to implement a data warehouse solution with Azure Synapse for your analytical workloads


Mark Pryce-Maher
Luke Moloney


AzureIntelligence and AnalyticsOptimisingSynapse AnalyticsAdvancedHow

The SQL Bits Story

SQLBits was formed in 2007 by a group of volunteers who were passionate about the SQL Server product suite and wanted to provide much-needed community-driven education to the data community.

As one of the largest data platform conferences in the world, we offer more opportunities to a wider audience.

15 Years

We’ve grown and expanded a lot since 2007.

2500 Participants

SQLBits is the best place to meet fellow data professionals.

82 Countries

We welcome data professionals from all over the globe.

1140 recorded sessions

All the live sessions are recorded and offered for free, year round.

Experience the SQLBits Conference


Want to be part of the SQLBits community?

Attend the London conference in-person or virtually on 

March 8-12, 2022 at ExCel London, UK.