# SQL Server Sample Databases and Datasets Some databases you can download from this repository: https://rebrand.ly/sample-db ## Sample databases information | Name / Download links | SQL Server Version | Type | .Bak, MB | .Mdf, MB | Table count | |-----------------------------------------|--------------------|----------|---------:|---------:|------------:| | [StackOverflow 2010 Database] | >=2012 | OLTP | 9360 | 9104 | 9 | | [StackOverflow Database] | >=2012 | OLTP | 137000 | | 9 | | [WideWorldImporters OLTP] | ? | OLTP | 121 | 1024 | 29 | | [WideWorldImporters DWH] | ? | DWH | 47 | 2048 | 48 | | [AdventureWorks OLTP 2017] | 2017 | OLTP | 47 | 264 | 71 | | [AdventureWorks OLTP 2016] | >=2016 | OLTP | 93 | 208 | 96 | | [AdventureWorks OLTP 2016 Extended] | >=2016 | OLTP | 125 | 386 | 71 | | [AdventureWorks OLTP 2014] | >=2014 | OLTP | 44 | 205 | 71 | | [AdventureWorks OLTP 2012] | >=2012 | OLTP | 44 | 192 | 71 | | [AdventureWorks DWH 2017] | >=2017 | DWH | 22 | 136 | 31 | | [AdventureWorks DWH 2016] | >=2016 | DWH | 21 | 170 | 31 | | [AdventureWorks DWH 2016 Extended] | >=2016 | DWH | 883 | 1466 | 33 | | [AdventureWorks DWH 2014] | >=2014 | DWH | 21 | 170 | 31 | | [AdventureWorks DWH 2012] | >=2012 | DWH | 21 | 124 | 31 | | [AdventureWorks Multidimensional Model] | ? | AS | 21 | ? | ? | | [AdventureWorks Tabular Model] | ? | AS | 21 | ? | ? | | [Northwind Database][1] | 2000 | OLTP | - | ? | ? | | [Pub Database][1] | 2000 | OLTP | - | ? | ? | [StackOverflow 2010 Database]:https://www.brentozar.com/archive/2015/10/how-to-download-the-stack-overflow-database-via-bittorrent/ [StackOverflow Database]:https://www.brentozar.com/archive/2015/10/how-to-download-the-stack-overflow-database-via-bittorrent/ [WideWorldImporters DWH]:https://github.com/Microsoft/sql-server-samples/releases/tag/wide-world-importers-v1.0 [WideWorldImporters OLTP]:https://github.com/Microsoft/sql-server-samples/releases/tag/wide-world-importers-v1.0 [AdventureWorks OLTP 2017]:https://github.com/Microsoft/sql-server-samples/releases/download/adventureworks/AdventureWorks2017.bak [AdventureWorks OLTP 2016]:https://github.com/Microsoft/sql-server-samples/releases/download/adventureworks/AdventureWorks2016.bak [AdventureWorks OLTP 2016 Extended]:https://github.com/Microsoft/sql-server-samples/releases/download/adventureworks/AdventureWorks2016_EXT.bak [AdventureWorks OLTP 2014]:https://github.com/Microsoft/sql-server-samples/releases/download/adventureworks/AdventureWorks2014.bak [AdventureWorks OLTP 2012]:https://github.com/Microsoft/sql-server-samples/releases/download/adventureworks/AdventureWorks2012.bak [AdventureWorks DWH 2017]:https://github.com/Microsoft/sql-server-samples/releases/download/adventureworks/AdventureWorksDW2017.bak [AdventureWorks DWH 2016]:https://github.com/Microsoft/sql-server-samples/releases/download/adventureworks/AdventureWorksDW2016.bak [AdventureWorks DWH 2016 Extended]:https://github.com/Microsoft/sql-server-samples/releases/download/adventureworks/AdventureWorksDW2016_EXT.bak [AdventureWorks DWH 2014]:https://github.com/Microsoft/sql-server-samples/releases/download/adventureworks/AdventureWorksDW2014.bak [AdventureWorks DWH 2012]:https://github.com/Microsoft/sql-server-samples/releases/download/adventureworks/AdventureWorksDW2012.bak [AdventureWorks Multidimensional Model]:https://github.com/Microsoft/sql-server-samples/releases/download/adventureworks-analysis-services/adventure-works-multidimensional-model-full-database-backup.zip [AdventureWorks Tabular Model]:https://github.com/Microsoft/sql-server-samples/releases/download/adventureworks-analysis-services/adventure-works-tabular-model-1200-full-database-backup.zip [1]:https://github.com/Microsoft/sql-server-samples/tree/master/samples/databases/northwind-pubs ## Datasets - [Data.gov](https://www.data.gov/) - [Amazon product data](http://jmcauley.ucsd.edu/data/amazon/) (This dataset contains product reviews and metadata from Amazon, including 142.8 million reviews spanning May 1996 - July 2014) ## Useful Links - [AdventureWorks Sample Databases and Scripts for SQL Server 2017, 2016, 2014 , 2012](https://github.com/Microsoft/sql-server-samples/releases/tag/adventureworks) - [AdventureWorks for Analysis Services](https://github.com/Microsoft/sql-server-samples/releases/tag/adventureworks-analysis-services) - [AdventureWorks Sample Databases and Scripts for SQL Server 2008 R2](https://github.com/Microsoft/sql-server-samples/releases/tag/adventureworks2008r2) - [Microsoft SQL Server 2008 R2 SR1 Sample Databases](https://sqlserversamples.codeplex.com/releases/view/72278) - [Thinking Big (Adventure)](http://sqlblog.com/blogs/adam_machanic/archive/2011/10/17/thinking-big-adventure.aspx) (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](https://github.com/Microsoft/sql-server-samples/releases/tag/iot-smart-grid-v2.0) (Github Microsoft) - [In-Memory OLTP (WWI Sales Orders)](https://github.com/Microsoft/sql-server-samples/releases/tag/wwi-sales-orders-v0.5) (Github Microsoft) - [Bigger Fact Table for Wide World Importers](http://www.sqlservercentral.com/blogs/koen-verbeeck/2016/08/12/bigger-fact-table-for-wide-world-importers/) (by Koen Verbeeck) - [Contoso Retail Data Warehose](https://github.com/Microsoft/sql-server-samples/tree/master/samples/databases/contoso-data-warehouse) (Github) - [How to Download the Stack Overflow Database via BitTorrent 2016-03](https://www.brentozar.com/archive/2015/10/how-to-download-the-stack-overflow-database-via-bittorrent/) (by Brent Ozar) - [Stack Overflow Database version 2016-12-15](https://www.brentozar.com/archive/2017/01/updating-stack-overflow-demo-database/) - [Stackexchange Source files - xml files](https://archive.org/download/stackexchange) - [Git repo for SQL Server Reporting Services samples and community projects](https://github.com/Microsoft/Reporting-Services) - [SQLSkills sample databases](https://www.sqlskills.com/sql-server-resources/sql-server-demos/) (also include SAMPLE CORRUPT DATABASES) - [SQLIndexWorkbook Sample Database](http://www.littlekendra.com/downloads/get-the-sqlindexworkbook-database/) (by Little Kendra) - [Itzik Ben-Gan Sample Databases](http://tsql.solidq.com/books/source_code/) (by Itzik Ben-Gan) - [Orders: Open Source Sample Database](https://www.brentozar.com/orders-open-source-sample-database/) (by Brent Ozar) - [BabbyNames Database](https://github.com/LitKnd/BabbyNames) (by Kendra Little) - [SQL Server Sakila DB](https://www.jooq.org/sakila) (by jOQO)