Ok so what SQL Server DBA doesn’t need sample databases for various project testing and demonstrations? Microsoft SQL Server installs have stopped installing sample databases since SQL Server 2005. However, Microsoft and a few others have developed several different free sample databases for SQL Server.
Here’s a list of various free sample databases you can use with SQL Server. I have also listed some helpful articles related to the free sample databases.
Microsoft SQL Server Sample databases
- AdventureWorks sample database
- Contoso Retail Data Warehouse sample database
- Northwind and Pubs Sample Databases for SQL Server 2000
- How to Install Pubs Database in SQL Server 2012 in 1 query
- Microsoft SQL Server historical sample database diagram tour
- WideWorldImporters Sample Database for SQL Server and Azure SQL Database
- WideWorldImportersDW Sample Database – How to Install New Sample Database
City of Chicago Parking Ticket Data Sample Database – SQL Server format by Bob Pusateri
Thinking Big (Adventure) Sample Database from Adam Mechanic
SQLskills.com – 7 Sample Databases
SQLskills.com – 5 Sample Databases that are corrupt (SQL Server version dependent)
Chinook Sample Database available for SQL Server, Oracle, MySQL, etc – Chris Woodruff
Stack Exchange Data Dump Sample Database
You get a free sample database! Everyone gets a free sample database! Right?
Advertisement
Amazon Prime Visa - Get a Amazon Gift Card instantly upon approval of Amazon Prime Visa
Chase Checking - Open your Chase checking account and get a bonus!
Chase Freedom Flex - Earn unlimited cash back with the Chase Freedom Flex credit card.
Chase Freedom Unlimited - Earn cash back with the Chase Freedom Unlimited credit card.
Chase Saphire - Open your Chase Saphire Preferred or Reserve and get bonus points and more!
Discover - Get a bonus when you open an eligible Discover account.
Marriott Bonvoy Credit card - Open your Marriott Bonvoy Credit card and get a new Cardmember bonus!
Rakuten - Sign up for Rakuten and earn cash back on your purchases at 3500+ stores. 20M+ members in the U.S. have earned over $3.2B in Cash Back at their favorite stores.
Schwab - Open a Schwab account and get up to $1,000 depending on your net deposit.
Xfinity - Open an Xfnity mobile or internet account and get a bonus