What is AdventureWorks in SQL Server

AdventureWorks is a Sample Database shipped with SQL Server and it can be downloaded from http://codeplex.com site.

AdventureWorks has replaced Northwind and Pubs from the sample database in SQL Server 2005.

The Microsoft team keeps updating the sample database as they release new versions.

Here are some quick links:
AdventureWorks SQL Server 2008 SR4

AdventureWorks 2008R2 November CTP

AdventureWorks for SQL Azure (December CTP)

AventureWorks for SQL Server 2005 SP2A

SQL SERVER – 2008 – Download and Install Samples Database AdventureWorks 2005 – Detail Tutorial