You will need two sample databases for the tutorials in this book and throughout the Microsoft Books Online tool built into SQL Server 2008. The AdventureWorks2008 database is an example database that simulates a bike retailer. It contains HR, accounting, and sales data for online transactions and store sales. The AdventureWorksDW2008 database is an example data warehouse for the same bike reseller.
The two sample databases are not installed by default with SQL Server 2008. You can download these and other sample databases from CodePlex.com (
http://www.codeplex.com/MSFTDBProdSamples/). CodePlex is Microsoft's community website where you can find projects and source code to extend SQL Server. The site is constantly updated and the sample databases are updated often as well.
You can also find the sample databases at the Wrox website at
The AdventureWorks2008 database requires that the Full Text Search feature be installed and that the new FileStream feature be enabled in SQL Server 2008. In addition the SQL Server Full Text service must be running. Without these, you can still install the AdventureWorksDW2008 database but not the AdventureWorks database.
To install the Full Text Search feature, you must go back to the SQL Server Installation Center under SQL Server 2008
The new FileStream feature ...