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

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

by Kevin Feasel
Released March 2021
Publisher(s): Apress
ISBN: 9781484270479

Watch it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Video description

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. 

Product information

  • Title: PolyBase in SQL Server 2019: Data Virtualization with SQL Server, Cosmos DB, PostgreSQL, and Other Database Engines
  • Author(s): Kevin Feasel
  • Release date: March 2021
  • Publisher(s): Apress
  • ISBN: 9781484270479