PowerPivot was a great new tool when it released several years ago. Now the newest version is out along side SQL Server 2012.You can still install the 2008 R2 version of PowerPivot or you can try out the new 2012 RTM version. There are some nifty improvements that Devin Knight has chronicled ( Blog | Twitter ). There are several requirements that are not part of the 2008 R2 requirements. The install instructions are the following with the first step being the new requirements: Install .NET Frame...
Read More
Between SharePoint 2007 and SharePoint 2010 there were many new features that were added or enhanced. There still remains a list of items that are either unsupported actions, such as workbook authoring, or unsupported features, such as cell comments. In Excel Services 2007 many unsupported features would cause the workbook to not load at all and have since had the behavior changed in 2010. The following is a list of features that would prevent the workbook from loading in 2007. They are still un...
Like all systems built on top of SQL Server SharePoint 2010 needs to have a plan for availability. There are many methods for configuring high availability, one of which is database mirroring. Other options, such as clustering will be discussed separately. Database mirroring is a SQL Server technology used for providing database redundancy. It is configured on a database level, not the server level. With this method any transaction on the the principal server are sent to the mirror server/databa...