Sample Databases for SQL Server

Sample Databases for SQL Server

Share on Facebook0Share on Google+0Tweet about this on TwitterShare on LinkedIn0Share on Reddit0

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: http://www.codeplex.com/SqlServerSamples

The sample databases link is the following: http://www.codeplex.com/MSFTDBProdSamples/

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! ๐Ÿ™‚


Recommended eBooks on SQL Server:

Tuning SQL Server: eBook by SQL Server MVP Artemakis Artemiou
Tuning SQL Server: eBook by SQL Server MVP Artemakis Artemiou
Administering SQL Server: eBook by SQL Server MVP Artemakis Artemiou
Administering SQL Server: eBook by SQL Server MVP Artemakis Artemiou
Artemakis Artemiou
Artemakis Artemiou is a Senior SQL Server Architect, Author, Software Developer and a Microsoft Data Platform MVP. He has over 15 years of experience in the IT industry in various roles. Among other, via his initiative SQLEBooks.com, Artemakis authors and publishes eBooks on different topics on SQL Server. Artemakis currently serves as the President of the Cyprus .NET User Group (CDNUG) and the International .NET Association Country Leader for Cyprus (INETA). Additionally he is the founder of the SQLArtBits initiative that aims to provide the technical community with simple, yet powerful and high-quality SQL Server tools. Currently, the highlights of these tools are DBA Security Advisor and In-Memory OLTP Simulator. Artemakis's official website can be found atย aartemiou.com. Artemakis's blogs can be found at: SQLNetHub.comย and TechHowTos.com.