Connecting PowerPivot to Hadoop on Azure – Self Service BI to Big Data in the Cloud

. “I caught a fish thiiiiis biiig” — On stage with Ted Kummert during the PASS 2011 Keynote on Big Data (thanks to Karen Lopez @datachick for the pic) . . During the PASS 2011 Keynote (back in October 2011), I had the honor to demo Hadoop on Windows / Azure.   One of the key showcases during that presentation was to show how to connect PowerPivot to Hadoop on Windows.  In this post, I show the steps on how to connect PowerPivot to Hadoop on Azure. Pre-requisites PowerPivot for Excel (as of this post, using SQL Server 2012 RC1 version)…

Rate this:

Revelations – rolling the hard six to SQL BI and Hadoop

  Sometimes, you have to roll a hard six. — Commander Adama in Battlestar Galactica “Revelations”     In May of this year, I had noted that I was At a Crossroads … from SSAS to Big Data!.  After I had written this post, many people ping me wondering if I had left the world of BI and/or left Microsoft altogether. [Note, I have called out that I AM a Microsoft employee but the opinions here are my own]  My subsequent posts ranged from Cloud to a little bit of Analysis Services. By the way, I did forget to create…

Rate this:

SQL Server/PDW Hadoop Connectors

Stargate-SG1 Quote from SG-1 episode Bad Guys: (Vala is attempting to power the stargate with a Goa’uld bomb.) Vala: There’s a 70% chance that if we dial manually we’ll be able to establish a connection, and a 50% chance the bomb will just go off. Lt. Col. Mitchell: That a 120%. Vala: Well there’s some crossover where we establish a wormhole and it blows up. Lt. Col. Mitchell: [on the radio] Jackson, did you catch any of that? Dr. Jackson: Yeah, 100% chance we should have brought someone who knows what they’re doing.     In the posting Parallel Data…

Rate this:

Procedure used for applying Database Compression

A very handy SQL Server 2008 data compression procedure was posted by my collegue Juergen Thomas with his extensive background in SAP.  He propped up an excellent blog post about data compression at: Procedure used for applying Database Compression to Microsoft SAP ERP system. What is interesting here is that he had created a procedure that would go through and compress all of the tables and indexes within your database using various options (online, batch, schemas, etc.) so that way you didn’t have to write your own statements to individually go through each table and compress them yourselves.  It’s a…

Rate this: