- AdventureWorks Sample Databases and Scripts for SQL Server 2017, 2016, 2014 , 2012
- AdventureWorks for Analysis Services
- AdventureWorks Sample Databases and Scripts for SQL Server 2008 R2
- Microsoft SQL Server 2008 R2 SR1 Sample Databases
- Thinking Big (Adventure) (by Adam Machanic)
- WideWorldImporters Sample Database (Github Microsoft)
- IoT Smart Grid sample - demonstrates how SQL Server 2016 memory optimized databases could be used to ingest a very high input data rate (Github Microsoft)
- In-Memory OLTP (WWI Sales Orders) (Github Microsoft)
- Bigger Fact Table for Wide World Importers (by Koen Verbeeck)
- Contoso Retail Data Warehose (Github)
- How to Download the Stack Overflow Database via BitTorrent 2016-03 (by Brent Ozar)
- Stack Overflow Database version 2016-12-15
- Stackexchange Source files - xml files
- Amazon product data (This dataset contains product reviews and metadata from Amazon, including 142.8 million reviews spanning May 1996 - July 2014)
- Git repo for SQL Server Reporting Services samples and community projects
- SQLSkills sample databases (also include SAMPLE CORRUPT DATABASES)
- SQLIndexWorkbook Sample Database (by Little Kendra)
- Data.gov
- Itzik Ben-Gan Sample Databases (by Itzik Ben-Gan)
- Orders: Open Source Sample Database (by Brent Ozar)
- BabbyNames Database (by Kendra Little)
- SQL Server Sakila DB (by jOQO)
Some databases you can download from this repository: https://rebrand.ly/sample-db
| Name/Download backups | SQL Server Version | Type | .Bak, MB | .Mdf, MB | Table count | AVG Rows per table | Median rows per table | Max rows in table |
|---|---|---|---|---|---|---|---|---|
| StackOverflow Database | >=2012 | OLTP | 137000 | ? | ? | ? | ? | ? |
| WideWorldImporters OLTP | ? | OLTP | 121 | ? | ? | ? | ? | ? |
| [WideWorldImporters DWH] | ? | DWH | 47 | ? | ? | ? | ? | ? |
| AdventureWorks OLTP 2017 | 2017 | OLTP | 47 | ? | ? | ? | ? | ? |
| AdventureWorks OLTP 2016 | >=2016 | OLTP | 93 | ? | ? | ? | ? | ? |
| AdventureWorks OLTP 2016 Extended | >=2016 | OLTP | 125 | ? | ? | ? | ? | ? |
| AdventureWorks OLTP 2014 | >=2014 | OLTP | 44 | ? | ? | ? | ? | ? |
| AdventureWorks OLTP 2012 | >=2012 | OLTP | 44 | ? | ? | ? | ? | ? |
| AdventureWorks DWH 2017 | >=2017 | DWH | 22 | ? | ? | ? | ? | ? |
| AdventureWorks DWH 2016 | >=2016 | DWH | 21 | ? | ? | ? | ? | ? |
| AdventureWorks DWH 2016 Extended | >=2016 | DWH | 883 | ? | ? | ? | ? | ? |
| AdventureWorks DWH 2014 | >=2014 | DWH | 21 | ? | ? | ? | ? | ? |
| AdventureWorks DWH 2012 | >=2012 | DWH | 21 | ? | ? | ? | ? | ? |
| AdventureWorks Multidimensional Model | ? | AS | 21 | ? | ? | ? | ? | ? |
| AdventureWorks Tabular Model | ? | AS | 21 | ? | ? | ? | ? | ? |