Sunday, May 10, 2009

Sample Databases for SQL Server

DBAs and Database Developers always need to test new database-related work before migrating it to Production Environments.

To this end, Test/Development Environments are usually set up in order to allow for testing new administration and programmability features of DBMSs (in our case SQL Server :)

Though, by only having such an environment set up is not enough. DBAs as well as Database Developers need sample data in order to manipulate it with various SQL Server operations and record the "responses" of the underlying SQL Server objects (i.e. databases, logins, etc.).

For every version of SQL Server, Microsoft releases sample databases (and many other samples such as code examples, etc.) which allow the user setting up Testing Environments of SQL Server along with sample data, thus being able to easily test new functionality.

It is not random that many SQL Server examples found on blogs, forums and websites, are referring well-known sample databases such as: AventureWorks, Northwind, pubs, etc (well, my posts on Entity Framework use the "pubs" database :)

So, by using the links provided below, you can find SQL Server sample databases (as well as other sample stuff) for all the SQL Server versions:

SQL Server 2000
You can download the Northwind and pubs databases from the following link.

SQL Server 2005 and 2008
You can find community projects and samples for SQL Server 2005 or later on Microsoft CodePlex, on the following link:

The sample databases link is the following:

Well, that's it, I guess that now you can continue experimenting with the new features of the latest SQL Server release with using the latest sample data as well! :)
Check out my latest eBook on SQL Server:
Tuning SQL Server - Ebook

Easily secure your SQL Server instances! Try out DBA Security Advisor!
DBA Security Advisor for SQL Server by SQLArtBits
DBA Security Advisor was developed by SQLArtBits. The tool was being carefully developed for an entire year and it contains comprehensive security checks and recommendations based on proven SQL Server security best practices. Feel free to download and use the Community Edition which is free and if you find it useful, you can consider upgrading to the Enterprise Edition!

Artemakis Artemiou [MVP]

Author & Editor

Artemakis Artemiou is a Senior SQL Server Architect, Software Developer and Microsoft Data Platform MVP. He is also an author, regular blogger, president of Cyprus.NET User Group and CY Country leader of INETA-EU. He is also the creator of DBA Security Advisor and In-Memory OLTP Simulator. Artemakis is a frequent guest author of worldwide well-respected online journals where he writes articles focusing on many SQL Server topics.

Reference: The SQL Server and .NET Hub (