Monthly Archives: June 2010

Database Migrations – Configure Logins and Permissions


Most Microsoft BI product installation have a separate data tier.  In other words, the database is on a different machine than the actual product (like SharePoint, PerformancePoint, ProClarity, …).  Occasionally, you may have a need to change your database server.  Perhaps … Continue reading

Posted in Microsoft BI, PerformancePoint, ProClarity, Setup, SharePoint, SQL Server, SSRS | Tagged , , , , , , , , , , , , , , , , , , , , , , , | 3 Comments

PowerPivot in Microsoft Excel 2010


PowerPivot for Excel is an Excel 2010 add-in that allows users to pull data from multiple sources, mash them up, and then build reports using regular pivot tables. You can even share these reports with others in Microsoft SharePoint (via PowerPivot … Continue reading

Posted in Microsoft BI, PowerPivot | Tagged | Leave a comment

Setting up a Local SQL Alias on a SharePoint Farm


Updated on July 2, 2010 by FUTURESULTS:  On June 17, 2010 Microsoft Updated the article – Move all databases (Office SharePoint Server 2007) that is referenced in my blog post below.  They also added instructions for SharePoint Server 2010.  The new process basically follows the … Continue reading

Posted in Microsoft BI, Setup | Tagged , , , , , , , | 4 Comments