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 | Comments Off on Excel 2013 and BI

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 | Comments Off on PerformancePoint 2013 and SharePoint 2013

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