Microsoft SQL Server Community Projects & Samples
The
SQL Server code-named “Denali” CTP 3 versions of the Adventure Works OLTP database and data warehouse are available on
AdventureWorks for SQL Server Denali CTP3.
Please be aware that the OLTP database name is not yet updated for SQL Server code-named “Denali” and remains: AdventureWorks2008R2. The data warehouse is now named AdventureWorksDWDenali.
The only change to AdventureWorks2008R2 is the removal of the FILESTREAM dependency.
The only changes to AdventureWorksDWDenali are the addition of the FactProductInventory table, which contains inventory data, and more date data in DimDate table to fill the years: 2001 to 2006.
Note: When you click the big
Download button on sample code project pages (including this one) you will get the x64 installer and download the
SQL Server 2008R2 samples. Use the
View all downloads links to get x86 and zip files for
SQL Server 2008R2.
SQL Server 2008R2 product code samples are available
here.
Download the AdventureWorks 2008R2 family of sample databases and AdventureWorks 2008R2 sample databases SQL Azure AdventureWorks community sample databases can be downloaded from
here.
SQL Server 2008 code samples are available
here.
Download the AdventureWorks 2008 family of sample databases separately.
SQL Server 2005 product samples can still be
downloaded and separately
AdventureWorks for SQL Server 2005.
CodePlex is the project hosting site for Microsoft SQL Server Samples and Community Projects. Projects listed here are official Microsoft samples for SQL Server (released with Service Packs or major releases of SQL Server) and applications developed by MVPs, and the SQL Server community at large, including:
Unless noted otherwise, the download links are for the latest release of the project; see the individual project sites (on the Releases tab) for prior version releases. Most projects have more than one file download for a given release; read carefully to be sure you choose the ones that you need.
Microsoft Product Samples
Note: This is one monolithic set of all Microsoft SQL Server product samples (except for the sample databases, due to size constraints) and does NOT include any community projects. If you are interested in a specific subject area, links to download individual technology-focused samples are below.
| Project | Project Site | Download |
|---|
| All Microsoft Product Samples in a Box | This page | Download |
Sample Databases
Forums & Answers
SQL Server Data Services/Cloud Samples
End to End (multi-technology, complete, integrated)
Microsoft SQL Server Analysis Services
Microsoft SQL Server Database Engine
Microsoft SQL Server Integration Services
Microsoft SQL Server Reporting Services
Microsoft SQL Server Spatial Tools
StreamInsight
Microsoft Sync Framework
Platform Tools & Utilities
SQL Heroes 2008 Contest WinnersThese awesome contributors took home a Windows Home Server (HP MediaSmart ex470) from SQL PASS 2008 for their great contributions to SQL Server community projects. We're proud to have such smart folks in our community!!
| BIDS Helper for Visual Studio/SQL Server (2005 & 2008) | Greg Galloway, Darren Gosbell, John Calvin Welch | Project Site |
| SQL 2008 Extended Events Manager | Jonathan Matthew Kehayias | Project Site |
| ssisUnit | John Calvin Welch | Project Site |
| SqlMonitoring Tool | Robert Hartskeerl | Project Site |
| Allocation SQL Server Management Studio Add-in | Daniel Gould | Project Site |