Monthly Archives: August 2012

SQL Server 2012 and SharePoint 2013: Installing on a Virtual Machine

With SharePoint 2013 now available, I have updated my post SQL Server 2012: Installing on a Virtual Machine to use SharePoint 2013 instead of SharePoint 2010.  If you would like to get a head start on learning what is new with SharePoint … Continue reading

Posted in SharePoint 2013, SQL Server 2012, SQLServerPedia Syndication | 11 Comments

Excel 2013 and BI

On July 16, 2012, Office 2013 Preview was released to the public (download).  Excel 2013 now includes a lot of the SQL Server BI components directly in the initial install, as well as enhancements made to the business intelligence (BI) capabilities … Continue reading

Posted in Business Intelligence, Excel, SQLServerPedia Syndication | Leave a comment

PerformancePoint 2013 and SharePoint 2013

PerformancePoint is an important BI Tool in the Microsoft world and it will continue to be Microsoft’s solution for creating interactive, context-driven dashboards with balanced scorecards, key performance indicators, analytic reports, and filters.  There is no doubt it is an integral part of … Continue reading

Posted in PerformancePoint, SharePoint 2013, SQLServerPedia Syndication | Leave a comment

Prevent wiping out of SSAS partitions

There have been a few times when I have created SSAS partitions outside of BIDS using script code in an SSiS package, then later made a change in BIDS and deployed the cube, wiping out those partitions (since they did … Continue reading

Posted in SQLServerPedia Syndication, SSAS | 1 Comment