Samples and Sample Databases

Microsoft SQL Server 2005 introduces the Adventure Works Cycles company. This company with its business scenarios, employees, and products is the basis for the following sample databases:

  • AdventureWorks sample OLTP database
  • AdventureWorksDW sample data warehouse
  • AdventureWorksAS sample analysis services database

These databases are used in the code examples in SQL Server Books Online and in the companion application and code samples that can be installed with the product.


The example companies, organizations, products, domain names, e-mail addresses, logos, people, places, and events depicted herein are fictitious. No association with any real company, organization, product, domain name, email address, logo, person, places, or events is intended or should be inferred.

In This Section

Topic Description

Adventure Works Cycles Business Scenarios

Describes Adventure Works Cycles, the fictitious company on which the sample databases are based, and the business scenarios used to determine the design of the databases.

AdventureWorks Sample OLTP Database

Describes in detail the AdventureWorks sample OLTP database.


Describes how to install samples in this release of SQL Server 2005. Demonstrates how to use a number of SQL Server technologies with a variety of programming languages.

See Also

Other Resources

Installing AdventureWorks Sample Databases and Samples

Help and Information

Getting SQL Server 2005 Assistance