22-25 April 2026 
Maximise compute performance with Azure SQL Data Warehouse
2018TL; DR
Learn about the new compute optimized performance tier in SQL Data Warehouse and how to maximize your performance through improved table design and columnstore optimization.
Session Details
The Azure SQL Data Warehouse service recently launched a new compute-optimized performance tier that delivers new performance capabilities and drives faster insight. With this innovation Azure SQL Data Warehouse is a true powerhouse in the cloud data warehouse industry leveraging the latest hardware innovations such as NVMe SSDs to deliver up to 100x performance gains on customer workloads. This session explains the innovation behind the new offering and demonstrates the value that an optimized for compute performance tier can bring to your cloud data warehouse.
In this session you will learn about the new compute optimized performance tier in Azure SQL Data Warehouse and how to maximize your performance through improved table design and columnstore optimization.
In this session you will learn about the new compute optimized performance tier in Azure SQL Data Warehouse and how to maximize your performance through improved table design and columnstore optimization.
3 things you'll get out of this session
Speakers
James Rowland-Jones's previous sessions
Agnostic, Hybrid Big Data Integration using PDW and PolyBase
PolyBase is one of the most exciting, innovative features in PDW; enabling transparent data integration with Hadoop's distributed file system (HDFS) and Windows Azure Storage Blobs (WASB). See it in action.
Demonstrating PDW integration with Hadoop & Polybase
Polybase is one of the most exciting, innovative features in PDW; enabling transparent data integration with Hadoop's distributed file system (HDFS) and soon Windows Azure Storage Blobs (WASB). See it in action.
The Art of War-Fast Track Data Warehouse & Fragmentation
When loading a Fast Track Data Warehouse it is important to ensure that your data is optimally laid out for Sequential I/O. Fragmentation is therefore the enemy. Know your enemy. Learn what it is, how it occurs and prevent it from happening to you!