MS released update (January 2008) for SQL Server 2005 Best Practices Analyzer

Microsoft released update for SQL Server 2005 Best Practices Analyzer. It contains many new and updated rules for Analysis Services, a few important rules for the Relational Engine, a couple bug fixes for the UI and command line tools.  And all of these rules have rich documentation telling you what need to know.

Analysis Services related changes 

In the last release, only a few rules for Analysis Services would be displayed.  These were mainly around security.  With this release, we detect potential issues with the design of your cubes.  If you have taken a look at SQL Server 2008, you’ll see that these are the same warnings you’ll find in Business Intelligence Development Studio.  Thus, the recommendations from SQL BPA will be perfectly in sync with the recommendations from SQL Server 2008.

Check out the latest release here: http://www.microsoft.com/downloads/details.aspx?FamilyId=da0531e4-e94c-4991-82fa-f0e3fbd05e63.