Abstract

Polybase is Microsoft's newest way of integrating SQL Server with external systems such as Hadoop and Azure Blob Storage. In this talk, we will connect SQL Server to an on-premises Hadoop cluster as well as Azure Blob Storage, writing T-SQL queries to retrieve remote data. We will then use DMVs and other resources to tease out what the Polybase engine is doing behind the scenes. Finally, we will look at several interesting use cases for Polybase.


Slides

The slides are available in HTML 5 format. All modern browsers (including tablets and phones) should be able to navigate the slides successfully.

The slides are licensed under Creative Commons Attribution-ShareAlike.


Demo Code

The demonstration code is available on my GitHub repository. This includes all of the SQL queries as well as relevant data sets.

The source code is licensed under the terms offered by the GPL. The slides are licensed under Creative Commons Attribution-ShareAlike.


Links And Further Information