Skip to content

Commit 186003b

Browse files
ktaranovktaranov
committed
Create separate Sample Databases folder, fix some issues
1 parent 3f3040a commit 186003b

3 files changed

Lines changed: 57 additions & 35 deletions

File tree

‎README.md‎

Lines changed: 6 additions & 34 deletions
Original file line numberDiff line numberDiff line change
@@ -3,7 +3,6 @@
33
<a name="header01"></a>
44
<a name="header02"></a>
55
<a name="header020"></a>
6-
<a name="header03"></a>
76
<a name="header04"></a>
87
<a name="header05"></a>
98
<a name="header06"></a>
@@ -34,7 +33,6 @@ Headers:
3433
- [Repo Folders and Files](#repo-folders-and-files)
3534
- [SQL Server Web Resources](#sql-server-web-resources)
3635
- [BIML Resources and Bloggers](#biml-resources-and-bloggers)
37-
- [SQL Server Sample Databases and Datasets](#sql-server-sample-databases-and-datasets)
3836
- [PowerShell and SQL Server](#powershell-and-sql-server)
3937
- [TSQL Format Code](#tsql-format-code)
4038
- [SQL Server Test Data Generation](#sql-server-test-data-generation)
@@ -57,17 +55,13 @@ Headers:
5755
- [SplitterB_CLR](/CLR/SplitterB_CLR.sql)
5856
- [Extended Events](/Extended_Events)
5957
- [Known Errors](/Errors)
58+
- [SQL Server Sample Databases and Datasets](#Sample_Databases)
6059
- [Solution](/Solution)
6160
- [dbWarden](/Solution/dbWarden) a free SQL Server Monitoring Package (by Stevie Rounds and Michael Rounds)
6261
- [Base line Collector script](/Solution/BaselineCollector) (by Robert Virag)
6362
- [Ola Maintenance Solution](/Solution/Ola_Maintenance_Solution) (by Ola Hallengren)
6463
- [SQLQueryStress](/Solution/SQLQueryStress) (by Adam Machanic)
6564
- [SysJobHistory](/Solution/SysJobHistory) (by David Wentzel)
66-
- [SSMS](/SSMS)
67-
- [SSMS addins](/SSMS/SSMS_Addins.md) (**34 useful free and paid SSMS Addins**)
68-
- [SSMS Snippets](/SSMS/SSMS_Snippets)
69-
- [SSMS Shortcuts](/SSMS/SSMS_Shortcuts.md) (**More than 300 Shortcuts**)
70-
- [SSMS Tips](/SSMS/SSMS_Tips.md) (**Complete guide about hidden gems of SSMS**)
7165
- [Scripts](/Scripts)
7266
- **Awesome SQL Server Diagnostic Information Queries** (by Glenn Alan Berry)
7367
- [SQL Server 2017 Diagnostic Information Queries](/Scripts/SQL%20Server%202017%20Diagnostic%20Information%20Queries.sql)
@@ -80,6 +74,11 @@ Headers:
8074
- [Foreign Key batch rename](/Scripts/Foreign%20Key%20batch%20rename.sql) (by Wes Henriksen)
8175
- [Count character matches](/Scripts/Count%20character%20matches.sql)
8276
- and many others...
77+
- [SSMS](/SSMS)
78+
- [SSMS addins](/SSMS/SSMS_Addins.md) (**34 useful free and paid SSMS Addins**)
79+
- [SSMS Snippets](/SSMS/SSMS_Snippets)
80+
- [SSMS Shortcuts](/SSMS/SSMS_Shortcuts.md) (**More than 300 Shortcuts**)
81+
- [SSMS Tips](/SSMS/SSMS_Tips.md) (**Complete guide about hidden gems of SSMS**)
8382
- [Stored Procedure](/Stored_Procedure)
8483
- [sp_DBPermissions](/Stored_Procedure/sp_DBPermissions.sql) (by Kenneth Fisher)
8584
- [sp_SrvPermissions](/Stored_Procedure/sp_SrvPermissions.sql) (by Kenneth Fisher)
@@ -370,33 +369,6 @@ BIML Bloggers
370369
[*Back to top*](#header020)
371370

372371

373-
## SQL Server Sample Databases and Datasets
374-
Alternative download link for some sample databases: http://bit.ly/ya-ssk
375-
376-
- [AdventureWorks Sample Databases and Scripts for SQL Server 2017, 2016, 2014 , 2012](https://github.com/Microsoft/sql-server-samples/releases/tag/adventureworks)
377-
- [Microsoft SQL Server 2008 R2 SR1 Sample Databases](https://sqlserversamples.codeplex.com/releases/view/72278)
378-
- [Thinking Big (Adventure)](http://sqlblog.com/blogs/adam_machanic/archive/2011/10/17/thinking-big-adventure.aspx) (by Adam Machanic)
379-
- [WideWorldImporters Sample Database](https://github.com/Microsoft/sql-server-samples/releases/tag/wide-world-importers-v1.0) (Github Microsoft)
380-
- [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-v1.0) (Github Microsoft)
381-
- [In-Memory OLTP (WWI Sales Orders)](https://github.com/Microsoft/sql-server-samples/releases/tag/wwi-sales-orders-v0.5) (Github Microsoft)
382-
- [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)
383-
- [Contoso Retail Data Warehose](https://github.com/Microsoft/sql-server-samples/tree/master/samples/databases/contoso-data-warehouse) (Github)
384-
- [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)
385-
- [Updating the Stack Overflow Demo Database version 2016-12-15](https://www.brentozar.com/archive/2017/01/updating-stack-overflow-demo-database/)
386-
- [Stackexchange Source files - xml files](https://archive.org/download/stackexchange)
387-
- [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)
388-
- [Git repo for SQL Server Reporting Services samples and community projects](https://github.com/Microsoft/Reporting-Services)
389-
- [SQLSkills sample databases](https://www.sqlskills.com/sql-server-resources/sql-server-demos/) (also include SAMPLE CORRUPT DATABASES)
390-
- [SQLIndexWorkbook Sample Database](http://www.littlekendra.com/downloads/get-the-sqlindexworkbook-database/) (by Little Kendra)
391-
- [Data.gov](https://www.data.gov/)
392-
- [Itzik Ben-Gan Sample Databases](http://tsql.solidq.com/books/source_code/) (by Itzik Ben-Gan)
393-
- [Orders: Open Source Sample Database](https://www.brentozar.com/orders-open-source-sample-database/) (by Brent Ozar)
394-
- [BabbyNames Database](https://github.com/LitKnd/BabbyNames) (by Kendra Little)
395-
- [SQL Server Sakila DB](https://www.jooq.org/sakila) (by jOQO)
396-
397-
[*Back to top*](#header03)
398-
399-
400372
## PowerShell and SQL Server
401373
- [SQL Server & Windows Documentation Using Windows PowerShell](https://sqlpowerdoc.codeplex.com/) (by Kendal Vandyke)
402374
- [Stairway to SQL PowerShell](http://www.sqlservercentral.com/stairway/91327/) (by Ben Miller)

‎SQL Server Version.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -170,7 +170,7 @@ FOR /R "d:\SQL Server" %I IN (*.exe) DO certUtil -hashfile "%I" sha1
170170
Alternative download link for all English x64 distributives: https://rebrand.ly/sql-server-distribs
171171

172172
| Direct x64 Download Link | File Name | Release Date | Build Number | Size, MB | SHA1 |
173-
|--------------------------------- |-------------------------------------------------------------------|--------------|--------------:|---------:|------------------------------------------|
173+
|---------------------------------------|-------------------------------------------------------------------|--------------|--------------:|---------:|------------------------------------------|
174174
| [SQL Server 2017] | SQLServer2017-x64-ENU-Dev.iso | 2017-10-02 | 14.0.1000.169 | 1476 | 0280ff6c1447d287a6bd3b86b81e459fe252d17a |
175175
| [SQL Server 2017 KB4052987] | SQLServer2017-KB4052987-x64.exe | 2018-01-03 | 14.0.3015.40 | 459 | a533b82e49cb9a5eea52cd2339db18aa4017587b |
176176
| [SQL Server 2016] | SQLServer2016-x64-ENU.iso | 2016-06-01 | 13.0.1601.5 | 2050 | ce21bf1c08ec1ac48ebb4988a8602c7813034ea3 |

‎Sample_Databases/README.md‎

Lines changed: 50 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,50 @@
1+
# SQL Server Sample Databases and Datasets
2+
Alternative download link for some sample databases:
3+
4+
- [AdventureWorks Sample Databases and Scripts for SQL Server 2017, 2016, 2014 , 2012](https://github.com/Microsoft/sql-server-samples/releases/tag/adventureworks)
5+
- [AdventureWorks Sample Databases and Scripts for SQL Server 2008 R2](https://github.com/Microsoft/sql-server-samples/releases/tag/adventureworks2008r2)
6+
- [Microsoft SQL Server 2008 R2 SR1 Sample Databases](https://sqlserversamples.codeplex.com/releases/view/72278)
7+
- [Thinking Big (Adventure)](http://sqlblog.com/blogs/adam_machanic/archive/2011/10/17/thinking-big-adventure.aspx) (by Adam Machanic)
8+
- [WideWorldImporters Sample Database](https://github.com/Microsoft/sql-server-samples/releases/tag/iot-smart-grid-v2.0) (Github Microsoft)
9+
- [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-v1.0) (Github Microsoft)
10+
- [In-Memory OLTP (WWI Sales Orders)](https://github.com/Microsoft/sql-server-samples/releases/tag/wwi-sales-orders-v0.5) (Github Microsoft)
11+
- [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)
12+
- [Contoso Retail Data Warehose](https://github.com/Microsoft/sql-server-samples/tree/master/samples/databases/contoso-data-warehouse) (Github)
13+
- [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)
14+
- [Stack Overflow Database version 2016-12-15](https://www.brentozar.com/archive/2017/01/updating-stack-overflow-demo-database/)
15+
- [Stackexchange Source files - xml files](https://archive.org/download/stackexchange)
16+
- [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)
17+
- [Git repo for SQL Server Reporting Services samples and community projects](https://github.com/Microsoft/Reporting-Services)
18+
- [SQLSkills sample databases](https://www.sqlskills.com/sql-server-resources/sql-server-demos/) (also include SAMPLE CORRUPT DATABASES)
19+
- [SQLIndexWorkbook Sample Database](http://www.littlekendra.com/downloads/get-the-sqlindexworkbook-database/) (by Little Kendra)
20+
- [Data.gov](https://www.data.gov/)
21+
- [Itzik Ben-Gan Sample Databases](http://tsql.solidq.com/books/source_code/) (by Itzik Ben-Gan)
22+
- [Orders: Open Source Sample Database](https://www.brentozar.com/orders-open-source-sample-database/) (by Brent Ozar)
23+
- [BabbyNames Database](https://github.com/LitKnd/BabbyNames) (by Kendra Little)
24+
- [SQL Server Sakila DB](https://www.jooq.org/sakila) (by jOQO)
25+
26+
Some databases you can download from this repository: https://rebrand.ly/sample-db
27+
28+
| Name/Download backups | SQL Server Version | OLTP/DWH | .Bac, MB | .Mdf, MB | Table count | AVG Rows per table | Median rows per table | Max rows in table |
29+
|-------------------------------------|--------------------|----------|---------:|---------:|------------:|-------------------:|-----------------------|-------------------|
30+
| [AdventureWorks OLTP 2017] | 2017 | OLTP | 47 | ? | ? | ? | ? | ? |
31+
| [AdventureWorks OLTP 2016] | >=2016 | OLTP | 93 | ? | ? | ? | ? | ? |
32+
| [AdventureWorks OLTP 2016 Extended] | >=2016 | OLTP | 125 | ? | ? | ? | ? | ? |
33+
| [AdventureWorks OLTP 2014] | >=2014 | OLTP | 44 | ? | ? | ? | ? | ? |
34+
| [AdventureWorks OLTP 2012] | >=2012 | OLTP | 44 | ? | ? | ? | ? | ? |
35+
| [AdventureWorks DWH 2017] | >=2017 | DWH | 22 | ? | ? | ? | ? | ? |
36+
| [AdventureWorks DWH 2016] | >=2016 | DWH | 21 | ? | ? | ? | ? | ? |
37+
| [AdventureWorks DWH 2016 Extended] | >=2016 | DWH | 883 | ? | ? | ? | ? | ? |
38+
| [AdventureWorks DWH 2014] | >=2014 | DWH | 21 | ? | ? | ? | ? | ? |
39+
| [AdventureWorks DWH 2012] | >=2012 | DWH | 21 | ? | ? | ? | ? | ? |
40+
41+
[AdventureWorks OLTP 2017]:https://github.com/Microsoft/sql-server-samples/releases/download/adventureworks/AdventureWorks2017.bak
42+
[AdventureWorks OLTP 2016]:https://github.com/Microsoft/sql-server-samples/releases/download/adventureworks/AdventureWorks2016.bak
43+
[AdventureWorks OLTP 2016 Extended]:https://github.com/Microsoft/sql-server-samples/releases/download/adventureworks/AdventureWorks2016_EXT.bak
44+
[AdventureWorks OLTP 2014]:https://github.com/Microsoft/sql-server-samples/releases/download/adventureworks/AdventureWorks2014.bak
45+
[AdventureWorks OLTP 2012]:https://github.com/Microsoft/sql-server-samples/releases/download/adventureworks/AdventureWorks2012.bak
46+
[AdventureWorks DWH 2017]:https://github.com/Microsoft/sql-server-samples/releases/download/adventureworks/AdventureWorksDW2017.bak
47+
[AdventureWorks DWH 2016]:https://github.com/Microsoft/sql-server-samples/releases/download/adventureworks/AdventureWorksDW2016.bak
48+
[AdventureWorks DWH 2016 Extended]:https://github.com/Microsoft/sql-server-samples/releases/download/adventureworks/AdventureWorksDW2016_EXT.bak
49+
[AdventureWorks DWH 2014]:https://github.com/Microsoft/sql-server-samples/releases/download/adventureworks/AdventureWorksDW2014.bak
50+
[AdventureWorks DWH 2012]:https://github.com/Microsoft/sql-server-samples/releases/download/adventureworks/AdventureWorksDW2012.bak

0 commit comments

Comments
 (0)