I know that I've described Project REAL in previous blog postings.  In a nutshell, this is a project started by Microsoft and some of their top partners to build a huge, real-world BI application entirely on SQL Server 2005 technologies.

A lot of great lessons learned have come out of the project.  But as time has gone on and the project has matured, a true set of best practices has emerged.

If you're thinking about rolling out a SQL Server 2005 based BI solution, then I strongly recommend that you spend a few hours exploring Project REAL at http://lists.sqlmag.com/t?ctl=13CDE:7B5CC . Learning and applying just one industry best practice is well worth the investment of your time and energy.

Let me know what you think!

-Kevin