For the 2012 Hadoop Summit, I will have the honor to co-present with Dave Mariani (@dmariani) from Klout in our session How Klout is changing the landscape of social media with Hadoop and BI. Our session is currently scheduled for June 13th at 3:35pm but it is subject to change. Check out our session and [...]
Archive for the ‘Analysis Services’ Category
SQL BI at Hadoop Summit = Awesomesauce!
Posted in Analysis Services, BigData, SQL, tagged Hadoop, hive, Thoughts on May 30, 2012 | Leave a Comment »
How to Connect Report Builder 3.0 to a SQL Server 2012 PowerPivot workbook
Posted in Analysis Services, Reporting Services, SharePoint on March 25, 2012 | Leave a Comment »
With the upcoming release of SQL Server 2012, the new and cooler way to connect to a PowerPivot workbook within SharePoint is to use Power View which addresses the concept of Self Service Reporting (similar to how PowerPivot addresses Self Service BI). I even have a cool YouTube video showing how to connect Power View [...]
BI and Big Data–the best of both worlds!
Posted in Analysis Services, BigData, PowerPivot, Random Thoughts, tagged Architecture, Excel, Hadoop, Javascript, Thoughts on March 1, 2012 | 1 Comment »
As part of the excitement of the Strata Conference this week, Microsoft has been talking about Big Data and Hadoop. It started off with Dave Campbell’s question: Do we have the tools we need to navigate the New World of Data?. And some of the tooling call outs specific to Microsoft include references to PowerPivot, [...]
Reminder SQLPASS breakout–SQLCAT: Tier-1 BI in the world of Big Data
Posted in Analysis Services, BigData on October 10, 2011 | 1 Comment »
Okay kid, this is where it gets complicated. – Amy Pond from Doctor Who’s “The Big Bang” The SQL PASS Summit 2011 starts tomorrow and lots of craziness and technical learnings from SQL Karoke to the Birds of Feather luncheon. Just a friendly reminder that on Thursday, October 13th, Thomas Kejser (@thomaskejser) and I – [...]
Are you an Analysis Services rock star? Yahoo! is looking for you!
Posted in Analysis Services, tagged Cool Job on May 24, 2011 | 2 Comments »
While I do not normally blog about job postings, this is definitely the exception to the rule. And this is a pretty big exception as I’m talking about a Yahoo! job posting too (and for full disclosure – don’t forget that I’m with Microsoft). My compatriots over at Yahoo! have built one of the largest [...]
At a Crossroads … from SSAS to BigData!
Posted in Analysis Services, BigData, tagged Architecture, Thoughts on May 17, 2011 | 2 Comments »
“There must be some way out of here, said the joker to the thief / There’s too much confusion, I can’t get no relief” – Bob Dylan’s ‘All Along the Watchtower’ . For those not familiar with Battlestar Galactica – this is from Crossroads, Part 2 with Bear McCreary’s (@bearmccreary) amazing version of All Along [...]
Announcing SSAS Maestros v1.2
Posted in Analysis Services, tagged Internals, Performance, SSASMaestro on May 12, 2011 | 1 Comment »
In homage to the maestro, the Battlestar Galactica image links to Bear McCreary’s All Along The Watch Tower. Note, This is a re-post of Announcing SSAS Maestros v1.2 on the SQLCAT blog. — We are proud to announce that SQLCAT will continue with the SSAS Maestros course in June and July in Redmond and Madrid. [...]
Why the obsession with random I/O within the context of SSAS?
Posted in Analysis Services, tagged Performance on March 1, 2011 | Leave a Comment »
As many of you know from the various blogs, whitepapers, and conferences from SQLCAT, there is a big obsession or compulsion toward I/O by various members of SQLCAT. If you’re not already familiar with this topic, definitely reference Mike Ruthruff’s whitepaper Predeployment I/O Best Practices. But as could be seen from the SSAS Maestros session [...]
Using SQL Server PowerPivot for Excel to Analyze SAP Data
Posted in Analysis Services, PowerPivot, tagged Excel, SAP on January 28, 2011 | 1 Comment »
Sorry! I’ve been offline and haven’t blogged or responded to comments for quite some time and frankly I don’t have any good excuses: I fell asleep My dog ate my WordPress login account info (never mind that I don’t have a dog yet) I was working (yeah, right) I used the TARDIS to back in [...]
Getting ready for enterprise SSAS and PowerPivot at PASS with SQLCAT!
Posted in Analysis Services, PowerPivot, tagged Performance on November 3, 2010 | Leave a Comment »
If you’re online this week, and admittedly the last few weeks I have been extremely dormant, you may know that next week is the 2010 SQL Server PASS Summit! It’s one of the most important SQL Server conferences and my team, SQLCAT, will be out in force. Heck, we’ll be in our green SQLCAT shirts [...]

