This is a really useful resource from where you can download over 100 samples and three sample databases for SQL Server 2005.
The downloads demonstrate the following components:
- Database Engine, including administration, data access, Full-Text Search, Common Language Runtime (CLR) integration, Server Management Objects (SMO), Service Broker, and XML
- Analysis Services
- Integration Services
- Notification Services
- Reporting Services