Data Virtualization in SQL Server 2022
ABSTRACT
PolyBase is Microsoft's primary data virtualization technology, allowing you to integrate SQL Server with a variety of external systems such as Oracle, MongoDB, Cosmos DB, Teradata, Apache Spark, and even other SQL Server instances. In this talk, we will walk through the mechanics of PolyBase, showing how we can write T-SQL queries to access data from heterogeneous sources. We will see how data virtualization in SQL Server has evolved over the years and the new capabilities you will find in SQL Server 2022. Finally, we will look at several interesting use cases for data virtualization in the modern data environment.ADDITIONAL MEDIA
On August 30, 2022, I gave this talk to the DBA Fundamentals group. You can get the recording on the DBA Fundamentals group's YouTube channel.
On August 13, 2019, I delivered the prior version of this talk at the Triangle SQL Server User Group's Advanced DBA special interest group. You can get the recording on my YouTube channel.
SLIDES
Click here to access the slides for this presentation.
The slides are licensed under Creative Commons Attribution-ShareAlike.
DEMO CODE
Click here to access demo code for this presentation.
The source code is licensed under the terms offered by the GPL.
LINKS & FURTHER INFO
- I have a multi-part blog series covering this topic in great detail.
- One thing I have not covered in my series is multi-node Polybase. David Benoit has covered this in a great blog post.
- Check out the SQL Data Warehouse feedback site if you have suggestions on how to make Polybase better. You can also see current issues with Polybase on that site as well.