Microsoft SQL Server Community Projects & Samples

The SQL Server 2012 RTM versions of the Adventure Works OLTP sample database and Adventure Works data warehouse sample database are available on AdventureWorks for SQL Server 2012.

SQL Server 2008R2 product code samples are available here. Download the AdventureWorks 2008R2 family of sample databases and AdventureWorks 2008R2 sample databases

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 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

Project Project Site Download
Microsoft Sample Databases Project Site Download
VSTS DB Edition Sample DB Projects Project Site Download
Northwind Community Edition Project Site No Releases Yet
SQL Server 2000 Sample DBs Project Site Download

Forums & Answers

Project Project Site
SQL Server Community & Samples Discussion Forum Discussion Forum
SQL Server Community & Samples FAQ Wiki Page
Why upgrade to SQL Server 2008? Website
Microsoft TechNet SQL Server TechCenter Website
Microsoft MSDN SQL Server Developer Center Website
SQL Server Forums Discussion Forums Index
SQL Server 2008 (Katmai) Forums Discussion Forums Index
SQL Examples by MVPs (answers from the forums) Wiki Page
SQL Server Community Worldwide Website
What clients can I use for source control with CodePlex? Wiki Page

SQL Server Data Services/Cloud Samples

Project Project Site Download
SQL Server Data Services Developer Center Project Site
SSDS Examples Project Site Download

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

Project Project Site Download
SQL Server 2008 SQL RSS Project Site Download
SQL Server 2008 Fault Retry Provider Project Site Download
Microsoft End-to-End Samples Project Site Download
Community End-to-End Samples Gallery (sponsored by DPE) Project Site Download
Tailspin Travel Sample Project Site Download

Master Data Services in SQL Server 2012

Project Project Site Download
Master Data Services in SQL Server 2012 Project Site] Download]

Microsoft SQL Server Analysis Services

Project Project Site Download
Microsoft Samples (OLAP, Data Mining, Administration) Project Site Download
Community Analysis Services Samples Gallery Project Site Download
Analysis Services Stored Procedures Project Site Download
MDX Script Performance Analyzer Project Site Download
powerSSAS: A PowerShell provider for SQL Server Analysis Services Project Site Download

Microsoft SQL Server Database Engine

Project Project Site Download
Microsoft Database Engine Samples (CLR, Full Text, SMO) Project Site Download
Microsoft Data Programmability Samples (ADO.NET, OLEDB, ODBC) Project Site Download
Microsoft Replication Samples Project Site Download
Microsoft Service Broker Samples Project Site Download
Community Service Broker Samples Project Site Download
Microsoft Transact-SQL Sample Scripts Project Site Download
Microsoft XML Samples Project Site Download
Microsoft TechNet SQL Server Scripting Center Project Site
SQL Server 2D Matrix Builder Project Site Download
SQL 2008 Extended Events Manager Project Site Download
Allocation SQL Server Management Studio Add-in Project Site Download
Open DBDiff Project Site Download
ADO.NET Entity Framework Extensions Project Site Download
Perseus: Entity Framework EntityBag Project Site Download
SQL CLR Measure Time Project Site Download
ADO.NET Entity Framework & LINQ to Relational Data Project Site
XML Toolkits & Extensions Project Site

Microsoft SQL Server Integration Services

Project Project Site Download
Microsoft Integration Services Samples Project Site Download
Community Integration Services Samples Gallery Project Site Download
Metadata Driven ETL Management Studio (MDDE) Project Site Download
ssisUnit Project Site Download
MapPoint Batch Geocoder for SSIS Project Site Download
Vulcan Project Site No Releases Yet
Integration Services Performance Strategies Whitepaper
SCD Component for Kimball Model DWs Project Site Download
ssisTwitterSuite via REST Project Site Download
SSIS Configuration Manager Project Site Download
DTLoggedExec Project Site Download

Microsoft SQL Server Reporting Services

Project Project Site Download
Microsoft Reporting Services Samples Project Site Download
ReportServer Explorer Project Site Download
SQL Server 2005 Report Packs Download

Microsoft SQL Server Spatial Tools

Project Project Site Download
SQL Server Spatial Tools Project Site Download
Spatial Data Support in SQL Server 2008 Project Site Download

StreamInsight

Project Project Site
StreamInsight Samples Project Site

Microsoft Sync Framework

Project Project Site Download
Sync101 - Getting Started with Sync V1.0 CTP2 Project Site Download
Contact Synchronization Sample - Outlook Sync Project Site Download
Sync Framework Tutorial Project Site Download
Producing and Consuming FeedSync Feeds using Sync Project Site Download

Platform Tools & Utilities

Project Project Site Download
BIDS Helper for Visual Studio/SQL Server (2005 & 2008) Project Site Download
SqlMonitoring Tool Project Site Download
SQL Server Health & History Project Site Download
SQL Load Generator Project Site Download
SQL Server 2005 Metadata Toolkit Project Site Download
DMV Stats performance data warehouse (for SQL Server 2005) Project Site Download
SQL Nexus performance analysis tool Project Site Download
SQL Server 2005 Service Manager Project Site Download
SQL Server Hosting Toolkit Project Site Download
SQL Web Data Administrator Project Site Download
SQL Web Query Project Site Download
SQL Server 2005 Driver for PHP Project Site Download
MassDataHandler for Unit Testing Project Site Download
Scriptio Project Site Download
T-SQL Macro for Unit Testing Project Site
SQL Server 2005 FineBuild Project Site Download
OpenDBDiff Project Site Download
SQL Server Gadgets for Vista Project Site Download
SQL Utilities Project Site Download
Sql Server Backup Utility Project Site Download


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

Last edited Mar 12, 2012 at 9:45 PM by akiwhit, version 94