Tabular Database PowerShell CmdLets available on CodePlex

JuanPablo just released an interesting cmdlet library to manage Tabular Models using PowerShell. It builds on the Tabular Model with AMO project, which JuanPablo introduced a few months ago in his blog article Creating a Tabular Model with AMO – New Version SQL 2012. So there you have it! Go to, download the compiled… Read more

Understanding Analysis Services Deployment Modes

SQL Server 2012 Analysis Services (SSAS) supports three different deployment modes: Multidimensional, Tabular, and SharePoint. You can choose the deployment mode during Setup, as the following figure illustrates. The SharePoint deployment mode is implicitly chosen on the Setup Role page when you install PowerPivot for SharePoint. Multidimensional and Tabular modes, on the other hand, can… Read more

Troubleshooting PowerPivot for SharePoint Solution Deployments

The configuration of PowerPivot for SharePoint entails a critical phase concerning the deployment of multiple solution packages (.wsp files) on all servers in the farm. If you run the PowerPivot Configuration Tool for the first time in a farm, you can see the various steps this phase includes under Add and Deploy PowerPivot Solutions, as… Read more