Ok, I know I haven't posted for a while... but as it is a new year I thought I'd try and post more frequently.
Some new (and really good) SQL Server 2005 downloads have appeared recently on the microsoft.com. I've listed these below:
SQL Server 2005 Samples and Sample Databases (December 2005) http://www.microsoft.com/downloads/details.aspx?familyid=e719ecf7-9f46-4312-af89-6ad8702e4e6e&displaylang=en
Troubleshooting Performance Problems in SQL Server 2005http://www.microsoft.com/technet/prodtechnol/sql/2005/tsprfprb.mspx
SQL Server 2005 Business Intelligence Metadata Whitepaper http://www.microsoft.com/downloads/details.aspx?FamilyId=182BD330-0189-450C-A2FE-DF5C132D9DA9&displaylang=en
This white paper covers several interesting and unique methods for managing metadata in SQL Server Integration Services, Analysis Services and Reporting Services using built-in features including data lineage, business and technical metadata and impact analysis.
SQL Server 2005 Business Intelligence Metadata Samples Toolkithttp://www.microsoft.com/downloads/details.aspx?FamilyId=11DAA4D1-196D-4F2A-B18F-891579C364F4&displaylang=enMicrosoft
SQL Server 2005 BI Metadata Samples provides tools and samples for analysing dependencies within and across SSIS and SSAS.The source code for the tools is provided. The following are the components of this pack:DependencyAnalyzer: a utility that scans SSIS packages and SSAS databases for enumerating metadata (objects, properties and dependencies).DependencyViewer: a utility to view metadata organization & inter-dependencies (lineage/impact analysis).Analysis Services Samples : sample SSAS packages that can be analyzedIntegration Services Samples: sample SSIS packages that can be analyzedReport Model Samples (Report Builder): report builder modelReports: sample reports built from metadata storeSQL: SQL script for creating metadata store