Microsoft Business Intelligence (BI) Resources

PowerPivot Hands on Demo and Download: http://powerpivot.com PowerPivot (Self-Service BI): PowerPivot TechCenter: http://technet.microsoft.com/en-us/bi/ff604673.aspx PowerPivot Tutorial: http://msdn.microsoft.com/en-us/library/ee210628.aspx PowerPivot Code Samples: http://www.codeplex.com/... [More]

Permalink | Comments (0) | Post RSSRSS comment feed

This Data Source Cannot Be Used Because Performancepoint Services Is Not Configured Correctly

If you’re setting up a fresh installation of PerformancePoint Services 2010 , you might think that all has gone well only to see the above error in Dashboard Designer once you try to start creating scorecards and reports. This is actually quite common – there are a few extra steps to do ... [More]

Permalink | Comments (0) | Post RSSRSS comment feed

Microsoft.Office.Project.PWA.WSSEventReceivers.PSDBUpdater Unexpected end of file while parsing Name has occurred. Line 1, position 256

Just about every Project Server 2007 farm I have worked on has had this event log error. So, what exactly causes it? This is a flaw in SharePoint where it is not checking the whole encoded URL length that a document link will have before it is uploaded. The encoded URL Document link leng... [More]

Permalink | Comments (0) | Post RSSRSS comment feed

SharePoint 2007 / Project Server GUID Error
SQL Query to Search All Tables in Database At One Time

SharePoint and all those Guids... Ever get an event log error message that only revealed a GUID based field? Well, now you can search your entire database to find all instances of the GUID. This will dramatically save you time in tracing down that error! Just type in your database na... [More]

Permalink | Comments (0) | Post RSSRSS comment feed

Project Server 2007 : Reporting (WSS Sync) Job Failed but not Blocking

Below are the top 3 reasons for receiving this error message.  First you will need to dissect the error message.Find the following two entries: SPListType=”xxxx” Error=”yyyyy” SP List ID   SP List Name 1100       &nbs... [More]

Permalink | Comments (0) | Post RSSRSS comment feed

Infrastructure Update for Microsoft Office Servers

Infrastructure Update for Microsoft Office Servers / Windows SharePoint Services / Microsoft Project UPDATED: Infrastructure Updates are now part of SP2 We finally have the release of the Infrastructure Update for MOSS, WSS and Project! There are some big changes to the core infrastructure of the ... [More]

Permalink | Comments (0) | Post RSSRSS comment feed

SharePoint 2007 - Unlocking Longterm Checked-Out Documents

In SharePoint there are two types of document checking-out: Long term check out This is the explicit check out .  This holds a lock on the document whether you have it open for edit or not. Short term check out You get this feature implicitly.  If you open a document for editing, yo... [More]

Permalink | Comments (0) | Post RSSRSS comment feed

Automatically Backup All Databases On A Server

This stored procedure will backup all databases on a server when run with a SQL job. I have it run nightly as it will also delete old backups depending on the retention period. A table DatabaseBackup is maintained to allow the changing of the retention period or exclusion of a database. ... [More]

Permalink | Comments (0) | Post RSSRSS comment feed