Video description
- 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
Product information
- Title: PolyBase in SQL Server 2019: Data Virtualization with SQL Server, Cosmos DB, PostgreSQL, and Other Database Engines
- Author(s):
- Release date: March 2021
- Publisher(s): Apress
- ISBN: 9781484270479
You might also like
book
PolyBase Revealed: Data Virtualization with SQL Server, Hadoop, Apache Spark, and Beyond
Harness the power of PolyBase data virtualization software to make data from a variety of sources …
video
Microsoft PolyBase Concepts and Configuration: Binding SQL Server and Other Platforms into a Single Data Source
This video provides an overview of PolyBase, Microsoft's technology for data virtualization. Modern data platform environments …
video
SQL Server 70-762: Developing SQL Databases: Required Knowledge for SQL Server 2012 and 2014
More than 19 hours of video instruction to help you learn and master the skills necessary …
book
Pro SQL Server 2019 Wait Statistics: A Practical Guide to Analyzing Performance in SQL Server
Here is a practical guide for analyzing and troubleshooting SQL Server performance using wait statistics. Learn …