If you like Adventureworks database for your testing,then you might have faced issues previously while trying to deploy to SQL server 2008/R2.

Currently all the issues are resolved and deployment can be done within minutes with the help of an exe file.

SQL Server 2008 R2 – http://msftdbprodsamples.codeplex.com/releases/view/55926 

Just run the exe and it will do the job for you.You can choose the databases and deploy them as per the requirement.

Great news ! Yes,we have Adventureworks for SQL Server DenaliCTP3 too –

http://msftdbprodsamples.codeplex.com/releases/view/55330

As the site says,these samples are getting updated to be compatible with SQL Server 2012 RC0 and we can expect them too during the course of time.

Happy testing my friends and thanks for reading.