The SQL Server 2008 Developer Training Kit will help you understand how to build web applications which deeply exploit the rich data types, programming models and new development paradigms in SQL Server 2008. Which has plenty of demos like
- Spatial Types Demo
- Intro to Filestream Demo
- SQL CLR Nullable Types Demo
- Programming with Filestream Demo
- Reporting Services Web Application Integration Demo
- Date and Time Support in SQL Server 2008 Demo
and many more…. It is really very cool one. It will give you lot of features or options to implement more to add your own stuff. You can download it here.