SQL Server 2019 Data Virtualization with PolyBase

[@colfaxschuyler3675]

I understand parts of this. What I haven't seen addressed are some practical aspects. PolyBase is touted for remote connections, to NoSQL sources and to relational dbs. This example is for a single table per connection at a time? If a practical DB has several hundred tables/views, would this have to be repeated for each? That is a daunting task.

[@colfaxschuyler3675]

Also, not discussed, what is the effect on the remote system? It's still going to have to process the request, which means a (pushdown) sql query. If the remote system is a prod system, you've pushed a load that you can't see/monitor to a system that you have limited (or NO) visibility into. The idea is interesting, but I haven't seen actual practical implementations.

[@olexiyusov1279]

This tutorial is great but like most of azure demos it's just showing the mouse clicks.. I hardly understand what is the simple concept behind of all those fancy words..

[@SQLTalk]

Sorry about that Olexiy. Fancy words without explanation don't get us very far. Here is a great Microsoft SQL 2019 KZbin channel I recommend for in-depth explanations of what is available in SQL 2019. kzbin.info/door/_BLf95QgWpwlbSq-ZKLMwA