Episode 209: Azure SQL Data Warehouse with Matt Usher

In this episode Chris Risner and Haishi Bai are joined by Matt Usher, Sr. Program Manager working on Azure SQL Data Warehouse. Matt starts by talking through what SQL Data Warehouse is and how it differs from a SQL Database. He then goes into some of the analytics and intelligence you can use with a Data Warehouse. Matt demonstrates how to create a new Azure SQL Data Warehouse, connect to it, and then how to insert data, query against it, and change data routing and partitioning. He also walks through connecting a SQL Data Warehouse to Power BI. Finally, Matt reviews a few different security options you have when you using Azure SQL Data Warehouse Links from the show: [00:52] - DataWarehouse vs Database[03:00] - Creating an Azure SQL Data Warehouse[05:17] - Connecting to SQL Data Warehouse with SQL Server Management Studio[07:22] - Distributed queries[11:50] - Creating views[14:20] - Using Power BI[19:00] - Data SecurityAzure SQL Data Warehouse landing pageLike Cloud Cover on Facebook! Follow @CloudCoverShowFollow @chrisrisnerFollow @haishibai2010 Follow @two_under