Microsoft SQL Server Community Projects & Samples

The SQL Server code-named “Denali” CTP 1 versions of the Adventure Works OLTP database and data warehouse are available on AdventureWorks for SQL Server Denali CTP1.
Please be aware that the database and data warehouse names are not yet updated for SQL Server code-named “Denali” and remain: AdventureWorks2008R2 and AdventureWorksDW2008R2.
The only change to AdventureWorks2008R2 is the removal of the FILESTREAM dependency. The only change to AdventureWorksDW2008R2 is the addition of a table with inventory data.

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.
ProjectProject SiteDownload
All Microsoft Product Samples in a BoxThis pageDownload

Sample Databases

ProjectProject SiteDownload
Microsoft Sample DatabasesProject SiteDownload
VSTS DB Edition Sample DB ProjectsProject SiteDownload
Northwind Community EditionProject SiteNo Releases Yet
SQL Server 2000 Sample DBsProject SiteDownload

Forums & Answers

ProjectProject Site
SQL Server Community & Samples Discussion ForumDiscussion Forum
SQL Server Community & Samples FAQWiki Page
Why upgrade to SQL Server 2008?Website
Microsoft TechNet SQL Server TechCenterWebsite
Microsoft MSDN SQL Server Developer CenterWebsite
SQL Server ForumsDiscussion Forums Index
SQL Server 2008 (Katmai) ForumsDiscussion Forums Index
SQL Examples by MVPs (answers from the forums)Wiki Page
SQL Server Community WorldwideWebsite
What clients can I use for source control with CodePlex?Wiki Page

SQL Server Data Services/Cloud Samples

ProjectProject SiteDownload
SQL Server Data Services Developer CenterProject Site
SSDS ExamplesProject SiteDownload

End to End (multi-technology, complete, integrated)

ProjectProject SiteDownload
SQL Server 2008 SQL RSSProject SiteDownload
SQL Server 2008 Fault Retry ProviderProject SiteDownload
Microsoft End-to-End SamplesProject SiteDownload
Community End-to-End Samples Gallery (sponsored by DPE) Project SiteDownload
Tailspin Travel SampleProject SiteDownload

Microsoft SQL Server Analysis Services

ProjectProject SiteDownload
Microsoft Samples (OLAP, Data Mining, Administration)Project SiteDownload
Community Analysis Services Samples GalleryProject SiteDownload
Analysis Services Stored ProceduresProject SiteDownload
MDX Script Performance AnalyzerProject SiteDownload
powerSSAS: A PowerShell provider for SQL Server Analysis ServicesProject SiteDownload

Microsoft SQL Server Database Engine

ProjectProject SiteDownload
Microsoft Database Engine Samples (CLR, Full Text, SMO) Project SiteDownload
Microsoft Data Programmability Samples (ADO.NET, OLEDB, ODBC) Project SiteDownload
Microsoft Replication SamplesProject SiteDownload
Microsoft Service Broker SamplesProject SiteDownload
Community Service Broker SamplesProject SiteDownload
Microsoft Transact-SQL Sample ScriptsProject SiteDownload
Microsoft XML SamplesProject SiteDownload
Microsoft TechNet SQL Server Scripting CenterProject Site
SQL Server 2D Matrix BuilderProject SiteDownload
SQL 2008 Extended Events ManagerProject SiteDownload
Allocation SQL Server Management Studio Add-inProject SiteDownload
Open DBDiffProject SiteDownload
ADO.NET Entity Framework ExtensionsProject SiteDownload
Perseus: Entity Framework EntityBagProject SiteDownload
SQL CLR Measure TimeProject SiteDownload
ADO.NET Entity Framework & LINQ to Relational DataProject Site
XML Toolkits & ExtensionsProject Site

Microsoft SQL Server Integration Services

ProjectProject SiteDownload
Microsoft Integration Services SamplesProject SiteDownload
Community Integration Services Samples GalleryProject SiteDownload
Metadata Driven ETL Management Studio (MDDE) Project SiteDownload
ssisUnitProject SiteDownload
MapPoint Batch Geocoder for SSISProject SiteDownload
VulcanProject SiteNo Releases Yet
Integration Services Performance StrategiesWhitepaper
SCD Component for Kimball Model DWsProject SiteDownload
ssisTwitterSuite via RESTProject SiteDownload
SSIS Configuration ManagerProject SiteDownload
DTLoggedExecProject SiteDownload

Microsoft SQL Server Reporting Services

ProjectProject SiteDownload
Microsoft Reporting Services SamplesProject SiteDownload
ReportServer ExplorerProject SiteDownload
SQL Server 2005 Report Packs Download

Microsoft SQL Server Spatial Tools

ProjectProject SiteDownload
SQL Server Spatial ToolsProject SiteDownload
Spatial Data Support in SQL Server 2008Project SiteDownload

StreamInsight

ProjectProject Site
StreamInsight SamplesProject Site

Microsoft Sync Framework

ProjectProject SiteDownload
Sync101 - Getting Started with Sync V1.0 CTP2Project SiteDownload
Contact Synchronization Sample - Outlook SyncProject SiteDownload
Sync Framework TutorialProject SiteDownload
Producing and Consuming FeedSync Feeds using SyncProject SiteDownload

Platform Tools & Utilities

ProjectProject SiteDownload
BIDS Helper for Visual Studio/SQL Server (2005 & 2008)Project SiteDownload
SqlMonitoring ToolProject SiteDownload
SQL Server Health & HistoryProject SiteDownload
SQL Load GeneratorProject SiteDownload
SQL Server 2005 Metadata ToolkitProject SiteDownload
DMV Stats performance data warehouse (for SQL Server 2005)Project SiteDownload
SQL Nexus performance analysis tool Project SiteDownload
SQL Server 2005 Service Manager Project SiteDownload
SQL Server Hosting Toolkit Project SiteDownload
SQL Web Data Administrator Project SiteDownload
SQL Web QueryProject SiteDownload
SQL Server 2005 Driver for PHPProject SiteDownload
MassDataHandler for Unit TestingProject SiteDownload
ScriptioProject SiteDownload
T-SQL Macro for Unit TestingProject Site
SQL Server 2005 FineBuildProject SiteDownload
OpenDBDiffProject SiteDownload
SQL Server Gadgets for VistaProject SiteDownload
SQL UtilitiesProject SiteDownload
Sql Server Backup UtilityProject SiteDownload


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 WelchProject Site
SQL 2008 Extended Events ManagerJonathan Matthew KehayiasProject Site
ssisUnitJohn Calvin WelchProject Site
SqlMonitoring ToolRobert HartskeerlProject Site
Allocation SQL Server Management Studio Add-inDaniel GouldProject Site

Last edited Feb 8, 2011 at 6:28 PM by mariwill, version 87