PolyBase in SQL Server 2019: Data Virtualization with SQL Server, Cosmos DB, PostgreSQL, and Other Database Engines

This video dives into PolyBase - Microsoft's technology for data virtualization - and its ability to virtualize data from a variety of data sources into SQL Server 2019. In this video, you will learn how to configure SQL Server and PolyBase to connect to another SQL Server instance. You will also learn the differences between PolyBase and linked server connections.

Next you will learn how to connect to additional data sources from SQL Server 2019, such as to Cosmos DB and PostgreSQL. You will see the configuration steps needed, as well as options available for retrieving data. From there, you will learn how to use statistics to assist the optimizer, obtain key query tuning tips, and implement a reference for loading a data warehouse using PolyBase.

What You Will Learn

Connect to remote instances of SQL Server, Cosmos DB, and PostgreSQL
Contrast linked servers to PolyBase and learn when to choose which method
Use statistics to assist the SQL Server optimizer in executing PolyBase queries
Tune queries against external tables
Load data from multiple external data sources into a data warehouse

Who This Video Is For

Data platform specialists who need to work on multiple data platforms, but want to use one unifying language to tie them together. Viewers should be familiar with SQL Server and the T-SQL language, but do not need prior experience with any other technologies. Viewers should have seen the first video in the series, PolyBase Concepts and Configuration.

Download Example Code