The following are some links that I refer too…
Resolve collation conflict for equal statement in where clause
How to reset the identity column of SQL Table
Consideration for Upgrading Integration Services
How to: Migrate a Reporting Services Installation
Introduction to New T-SQL Programmability Features in SQL Server 2008
