TNWiki Article Spotlight – SQL Server and PolyBase

Welcome to another Tuesday TNWiki Article Spotlight.

The amount of data modern applications generate is staggering. We use the term Big Data as a catch-all buzz word for not only data storage but also data processing.

However, Big Data has not replaced the need for relational databases (RDBMS) in enterprise systems. A question though now emerges in how does the Big Data infrastructure link to the RDBMS? This is solved with PolyBase.

To see a nice overview of this, Chervine Bhiwoo has created an award-winning article entitled Query Unstructured Data from SQL Server using Polybase for the TechNet Wiki. Chervine demonstrates how to install PolyBase, how  to link it to an existing SQL Server installation, and then how to connect it to a Big Data solution. He wraps up by showing an in-depth example of how to fetch data from an Azure Blob Store into the RDBMS.

If you ever wanted to know more about how SQL Server and Hadoop can work together, read his article.

by Ken Cenerelli (TwitterBlogMSDN ProfileMVP Profile)