Download Latest Version
sql-linux-lab.zip (1.2 MB)
Get an email when there's a new version of sql-linux-lab
| Name | Modified | Size | Downloads / Week |
|---|---|---|---|
| scripts | 2017-03-16 | ||
| sql-linux-lab.zip | 2018-03-13 | 1.2 MB | |
| Student-Guide-SQL-Linux.pdf | 2018-03-13 | 1.3 MB | |
| README.md | 2017-03-16 | 1.3 kB | |
| Totals: 4 Items | 2.4 MB | 0 |
Get started with SQL Server on Linux
Prerequisites
To play this lab, you will need RHEL 7.2+ server with graphics and VNC started. Place the scripts in a directory called /usr/kits/SQL-Linux.
Then, download the AdventureWorks 2014 database (in .zip format) and move it in the /usr/kits/SQL-Linux folder.
You need as well to download and install the latest version of the ilorest tool and the jq json tool from the EPEL repository.
Download as well the latest version of HammerDB for Linux (2.22+) in /usr/kits/SQL-Linux directory of your server. The installation will be performed in the Student guide.
Project Content:
Student guide: This guide explains how to install and use Microsoft SQL Server on Linux. Several use cases are presented including performance gain with the use of a persistent memory solution (HPE 8GB NVDIMM-N) for the database log file. In-Memory transactions are also possible with this early version of MS SQL Server on Linux.
script: Directory containing Transact-SQL and shell scripts used in the lab. Copy those scripts in your /usr/kits/SQL-Linux folder.