h264, yuv420p, 1920x1080 | ENGLISH, 44100 Hz, Stereo| 1h 16mn | 360.49 MB
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.