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 remain: 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
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.
|All Microsoft Product Samples in a Box||This page||Download|
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
Microsoft Sync Framework
Platform Tools & Utilities
SQL Heroes 2008 Contest Winners
These 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|