22-25 April 2026
Video unavailable
SQLBits 2016

Warehouse of the Future: Lakes Vs Marts

Data Warehouses are changing. This session will run through the architecture of the modern warehouse, from structured/unstructured Azure Data Lakes to platform as a service Azure Data Warehouse and bringing the two together.
It's time to face the fact that Data Warehouses, as we know them, are changing.

The increasing power of automatically scaling systems and the rapidly dropping cost of storage are challenging how we decide which data to keep and how we push it out to those who need it.

In this session we'll run through the architecture of the modern warehouse, from our structured/unstructured Azure Data Lake architecture to our platform as a service Azure Data Warehouse and the various tools bringing the two together.

Expect a general overview of these new Azure components, a little BI theory and practical demonstrations of setting up Data Lake, writing U-SQL, linking up Data Warehouse and exposing data to users, all from the ground up (demo gods permitting)