Updated SQL Sever 2005 sample databases and code (Feb 2007)
You can download the latest versions of the SQL Server 2005 samples and databases using the link below.There is also a new sample database called AdventureWorksLT. This is a scaled-down sample database that those who are new to SQL Server will find easier to use and understand.
http://www.microsoft.com/downloads/details.aspx?familyid=E719ECF7-9F46-4312-AF89-6AD8702E4E6E&displaylang=en
Among the new additions to the samples are the Aggregation Manager for Analysis Services which lets you view, design, edit, and add aggregations based on the information collected in the query log, the ASUV (Analysis Services Upgrade Verification) tool which lets you compare MDX query results and performance between a Microsoft SQL Server 2000 Analysis Services databases and a Microsoft SQL Server 2005 Analysis Services database and ASTrace which lets you capture an Analysis Services trace and log it into a SQL Server table which can then be queried via TSQL or read using SQL Server Profiler.