Bring Chaos to Order - A Collection of SQL Server Sample Databases and Sample Project Files from SQL Server 2000 to SQL Server 2012

Note 1: The links on the Microsoft websites are only valid on 3/13/2014.
Note 2: I have also created folders for different versions of SQL Server on My Google Docs.
Note 3: Although this document contains the major sample databases and projects, there are additional samples. You can find more samples at http://sqlserversamples.codeplex.com/.

1.     SQL Server 2000 (My Google Doc Location: https://drive.google.com/#folders/0B0NWdGCu7BBXZjRUZnlYMTZlV00)


I do not have SQL Server 2000 installed on my PC. For consistency, I have moved the four files – northwind.mdf, northwind.ldf, pubs.mdf, and pubs.ldf to the same location as the files for SQL Server 2005 at

D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data)



(D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data)

(The default path is C:\Program Files\Microsoft SQL Server\90\Samples\)

For consistency, I have installed it to:

D:\Program Files\Microsoft SQL Server\90\Samples

3.     SQL Server 2008 (SR4 - Sample Refresh 4) (https://drive.google.com/#folders/0B0NWdGCu7BBXYkxMX1lwVS1UcEE)


D:\Program Files\Microsoft SQL Server\MSSQL10.SQL2008\MSSQL\DATA

Note: When you execute the AdventureWorks2008_SR4.exe, the executable not only installs the SQL Server 2008 version for the three AW databases, but it also installs the 2005 version of the three AW databases. Interestingly, the AW databases for the 2005 and 2008 versions are different. But the differences are minor after inspection by using SQL Compare (Red Gate). For instance,
·       AdventureWorks for 2005 uses the collation of Latin1_General_CS_AS for the nvarchar columns, where AdventureWorks for 2008 employs SQL_Latin1_General_CP1_CI_AS for the collation
·       AdventureWorks for 2005 has some comments which are not in the 2008 version
·       There are some minor code changes.


D:\Program Files\Microsoft SQL Server\100\Samples

c.      No separate samples for Report Builder 2.0 with SQL Server 2008.

For Report Builder 2.0 sample reports and tutorials, you need only install AdventureWorks2008.



D:\Program Files\Microsoft SQL Server\100\Samples


D:\Program Files\Microsoft SQL Server\MSSQL10_50.R2\MSSQL\DATA


Although it is named SQL2008R2, it is actually SQL2008 samples. However, if you have other 2008R2 samples like the ones in the next list are installed, the samples for SQL Server 2008 have to be upgraded in the 2008R2 environment. Both the 2008 and 2008R2 non-DB sample files are installed to:

D:\Program Files\Microsoft SQL Server\100\Samples

d.     Nevertheless, there are some additional samples for SQL Server 2008 R2:
                                          i.     SSRS sample reports: AdventureWorks Sample Reports 2008 R2 (AdventureWorks Sample Reports 2008 R2.zip), unzipped to:

D:\Program Files\Microsoft SQL Server\100\Samples\AdventureWorks 2008R2 Analysis Services Project\AdventureWorks 2008R2 Analysis Services Project\enterprise

                                       iii.     SSIS Samples for SQL Server 2008R2 RTM (SQL2008R2.Integration_Services.Samples.x64.msi), installed to

D:\Program Files\Microsoft SQL Server\100\Samples\Integration Services


They are just some rdl files.



This database needs to be installed to SQL Azure remotely, not locally.

a.          Databases:
i.                AdventureWorks2012,
ii.              AdventureworksDW2012,
iii.            AdventureworksLT2012,
b.         Other Samples and Tutorials
ii.              Analysis Services Tutorial SQL Server 2012,
e.          SQL Azure Databases
i.                 AdventureWorks2012ForWindowsAzureSQLDatabase
ii.               OlympicsData workbook - Excel, SSIS, Azure sample