SQLCAT.Com – eBook Downloads

As of September 1, 2013 we decided to remove SQLCAT.COM site and use MSDN as the primary vehicle to post new SQL Server content. This was done to minimize reader confusion and to streamline content publication.  MSDN SQLCAT blogs already includes most SQLCAT.COM Content and will continue to be updated with more SQLCAT learnings.  You can also… Read more

Self-Service BI Works!

When I talk to people about adding self-service BI to their company’s environment I generally get a list of reasons why it won’t work. Some things I commonly hear: I can’t get anyone in IT or on the business side to even try it. The business side doesn’t know how to use the technology. This… Read more

Hurricane Sandy Mash-Up: Hive, SQL Server, PowerPivot & Power View

For my #SQLPASS Summit 2012 talk SQLCAT: Big Data – All Abuzz About Hive (slides available to all | recording available to PASS Summit 2012 attendees) I showed a mash-up of Hive, SQL Server, and Excel data that had been imported to PowerPivot and then displayed via Power View in Excel 2013 (using the new… Read more

32- and 64-Bit Connectivity from the Same Machine

Author: Chuck Heinzelman Reviewers: Steve Howard, Carl Rabeler, Shaun Tinline-Jones, Mike Weiner, Murshed Zaman   I was recently involved in a customer lab testing the Microsoft Business Intelligence stack.  I noticed an interesting behavior when working on one of my test servers.   Here’s the environment that I was working with: ·         Windows Server 2008… Read more

PowerPivot for SharePoint Installation Guides DRAFT

The installation of PowerPivot for SharePoint can be a little complex at times – especially the PowerPivot for SharePoint multi-server farm scenario.  In order to help with this, the Analysis Services team and the SQLCAT team came together and created four PowerPivot for SharePoint Installation Guides for your review. These are DRAFT guides that you… Read more

PowerPivot Jump Start!

As you may already know, the new name for Project Gemini is PowerPivot and the official names are PowerPivot for Excel and PowerPivot for SharePoint.  For information and to sign up for notification on the release dates, check out the official PowerPivot web site at http://www.powerpivot.com/ Shortly after the SharePoint conference, our Analysis Services teammates… Read more