Forcing External Pushdown

In the last post, we dug into how the MapReduce process works.  Today, I want to spend a little bit of time talking about forcing MapReduce operations and disabling external pushdown. What Can We Force? Before we get into the mechanics behind forcing pushdown, it's important to note that predicate pushdown is somewhat limited in…

Curated SQL At One Year

Curated SQL is just over a year old now.  I started work on it during PASS Summit 2015, and I'm happy with the results so far. By The Numbers I'm up to 2026 posts on Curated SQL.  My three largest categories are Administration, Cloud, and Hadoop.  I used to call "Cloud" Azure, but kept running…

Creating External Tables

At this point, we've got Polybase configured and have created external data sources and file formats (and by the way, if you haven't been keeping up, I am tracking my entire Polybase series there).  Now we want to create an external table to do something with all of this.  As usual, my first stop is MSDN, which…