Polybase: Big (Data) Things in SQL Server 2016 – Part 2

Part Two: Transact-SQL Queries of Hadoop Data Three tasks are necessary if we are to query Hadoop data with Polybase. We must define the connection information, we must define how the semi-structured Hadoop data is to be parsed, and we must specify the row-and-column format for the parsed data that we will use to write […]
Read More ›

Polybase: Big (Data) Things in SQL Server 2016 – Part 1

Installation and Configuration of SQL Server 2016 Polybase Introduction Among SQL Server’s many new features introduced in 2016 is Polybase, a bridge between relational data stored in SQL Server and bulk data stored in the Hadoop ecosystem. Hadoop is an excellent store for what many folks call “semistructured” data. That is, data which cannot be […]
Read More ›

SQL Server 2016 CTP 3.2 – A Little Something for Everyone

SQL Server 2008 R2 and Sql Server 2012 brought with them lots of new features to please data warehouse admins, BI developers, and analysts. Lest the OLTP folks felt left out, Microsoft introduced in 2014 in-memory optimization technology, code-named Hekaton, along with other features designed to please database administrators concerned with transaction processing. It’s the […]
Read More ›

Microsoft Power BI 2.0

What is it about version 2.0? Perhaps when software reaches version 2.0 it seems to have gained some maturity and respectability, but is still young enough to be filled with excitement and energy. In any case, Microsoft’s Power BI Version 2.0, announced for general availability July 24, is generating considerable excitement within the community of […]
Read More ›

Executing DAX Queries From R

Christine, a student in Learning Tree’s course SQL Server Analysis Services for Business Intelligence, writes “I just created my first Analysis Services tabular model database, and I am having lots of fun. But now I want to do some more sophisticated statistical analysis using R. I can’t seem to find a way to use DAX […]
Read More ›

Type to search blog.learningtree.com

Do you mean "" ?

Sorry, no results were found for your query.

Please check your spelling and try your search again.