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.
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.
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..
Sorry about that Olexiy. Fancy words without explanation don't get us very far. Here is a great Microsoft SQL 2019 TH-cam channel I recommend for in-depth explanations of what is available in SQL 2019. th-cam.com/channels/_BLf95QgWpwlbSq-ZKLMwA.html
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.
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.
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..
Sorry about that Olexiy. Fancy words without explanation don't get us very far. Here is a great Microsoft SQL 2019 TH-cam channel I recommend for in-depth explanations of what is available in SQL 2019. th-cam.com/channels/_BLf95QgWpwlbSq-ZKLMwA.html