DZone
Thanks for visiting DZone today,
Edit Profile
  • Manage Email Subscriptions
  • How to Post to DZone
  • Article Submission Guidelines
Sign Out View Profile
  • Post an Article
  • Manage My Drafts
Over 2 million developers have joined DZone.
Log In / Join
Please enter at least three characters to search
Refcards Trend Reports
Events Video Library
Refcards
Trend Reports

Events

View Events Video Library

Zones

Culture and Methodologies Agile Career Development Methodologies Team Management
Data Engineering AI/ML Big Data Data Databases IoT
Software Design and Architecture Cloud Architecture Containers Integration Microservices Performance Security
Coding Frameworks Java JavaScript Languages Tools
Testing, Deployment, and Maintenance Deployment DevOps and CI/CD Maintenance Monitoring and Observability Testing, Tools, and Frameworks
Culture and Methodologies
Agile Career Development Methodologies Team Management
Data Engineering
AI/ML Big Data Data Databases IoT
Software Design and Architecture
Cloud Architecture Containers Integration Microservices Performance Security
Coding
Frameworks Java JavaScript Languages Tools
Testing, Deployment, and Maintenance
Deployment DevOps and CI/CD Maintenance Monitoring and Observability Testing, Tools, and Frameworks

Last call! Secure your stack and shape the future! Help dev teams across the globe navigate their software supply chain security challenges.

Modernize your data layer. Learn how to design cloud-native database architectures to meet the evolving demands of AI and GenAI workloads.

Releasing software shouldn't be stressful or risky. Learn how to leverage progressive delivery techniques to ensure safer deployments.

Avoid machine learning mistakes and boost model performance! Discover key ML patterns, anti-patterns, data strategies, and more.

Related

  • How to Repair Corrupt MySQL Database Tables Step-by-Step
  • Harnessing the Power of AWS Aurora for Scalable and Reliable Databases
  • Optimizing MySQL Performance: Best Practices for Database Efficiency
  • Fine-Tuning Performance, Resolving Common Issues in FinTech Application With MySQL

Trending

  • Automatic Code Transformation With OpenRewrite
  • Automating Data Pipelines: Generating PySpark and SQL Jobs With LLMs in Cloudera
  • The Human Side of Logs: What Unstructured Data Is Trying to Tell You
  • 5 Subtle Indicators Your Development Environment Is Under Siege
  1. DZone
  2. Data Engineering
  3. Databases
  4. Collection: SQL Server Sample Databases

Collection: SQL Server Sample Databases

Need a sample database to test out your queries? Look at a collection of different ones you can make use of immediately.

By 
Jonathan Danylko user avatar
Jonathan Danylko
·
Dec. 11, 18 · Opinion
Likes (6)
Comment
Save
Tweet
Share
76.8K Views

Join the DZone community and get the full member experience.

Join For Free

Why create a whole database when you can use an existing one for testing purposes? Today, I've collected a list of sample databases for SQL Server.

There are times when you need a sample database to test out a query or benchmark the database or server in general.

What better way than to use production...err...I mean, a test database?

It's been a while since I've done a collection post, so I thought this would be perfect.

This collection of databases is meant to show how to properly design databases and how applications use them efficiently.

Oh, and they're also great test databases to beat on for performance scenarios.

Northwind Database

Nothing like an old classic to kick off the list.

The Northwind Database works with SQL Server 2005 and 2008 and was originally created for demonstration purposes for Microsoft Access. It eventually transitioned over to SQL Server.

AdventureWorks

AdventureWorks Cycles is another classic database representing a fictional company created and published by Microsoft.

The database shows how to design a SQL Server database using SQL Server 2008 and AdventureWorksDW is the data warehouse sample.

It works with 2005, 2008, 2008R2, 2012 RTM, and Azure.

Another version exists at Microsoft SQL Server Samples GitHub.

Contoso University

The Contoso University is an updated database to show how a schooling database would look like.

It's a simple database example. There is also a sample script of how to create it.

Since the script is simple enough, it should work on every SQL Server.

StackOverflow Database

I first found out about this through Brent Ozar's post on How to Download the StackOverflow database via BitTorrent.

The database is segmented into three downloads:

  • Large (41GB expands to 312GB)
  • Medium (10GB expands to 50GB)
  • Small (1GB expands to 10GB)

Each one has certain tables included like badges and post history. It's probably best to determine what data you find relevant and download the appropriate version.

Chinook Database

Finally, we have the Chinook database which represents a digital media store, including tables for artists, albums, media tracks, invoices, and customers.

This database supports not only SQL Server, but DB2, EffiProz, MySQL, Oracle, PostgreSQL, SQL Server Compact, and SQLite Data Model.

Conclusion

This was a collection I felt necessary to create because of all of the different flavors of databases you can use to test without damaging your own database.

Did I miss a database? Which one is your favorite? Post your comments below and let's discuss.

Database MySQL

Published at DZone with permission of Jonathan Danylko, DZone MVB. See the original article here.

Opinions expressed by DZone contributors are their own.

Related

  • How to Repair Corrupt MySQL Database Tables Step-by-Step
  • Harnessing the Power of AWS Aurora for Scalable and Reliable Databases
  • Optimizing MySQL Performance: Best Practices for Database Efficiency
  • Fine-Tuning Performance, Resolving Common Issues in FinTech Application With MySQL

Partner Resources

×

Comments
Oops! Something Went Wrong

The likes didn't load as expected. Please refresh the page and try again.

ABOUT US

  • About DZone
  • Support and feedback
  • Community research
  • Sitemap

ADVERTISE

  • Advertise with DZone

CONTRIBUTE ON DZONE

  • Article Submission Guidelines
  • Become a Contributor
  • Core Program
  • Visit the Writers' Zone

LEGAL

  • Terms of Service
  • Privacy Policy

CONTACT US

  • 3343 Perimeter Hill Drive
  • Suite 100
  • Nashville, TN 37211
  • support@dzone.com

Let's be friends:

Likes
There are no likes...yet! 👀
Be the first to like this post!
It looks like you're not logged in.
Sign in to see who liked this post!