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 |
|---|---|---|---|
| Parent folder | |||
| GetNVDIMMInventory.sh | 2017-03-16 | 739 Bytes | |
| ScanColumnStore.sql | 2017-03-15 | 273 Bytes | |
| SetOffline.sql | 2017-03-15 | 270 Bytes | |
| RestoreAdventureDB.sql | 2017-03-15 | 386 Bytes | |
| RestoreDBWithLogAndDataOnDisk.sql | 2017-03-15 | 505 Bytes | |
| RestoreDBWithLogAndDataOnPmem.sql | 2017-03-15 | 512 Bytes | |
| ODBC-CLI-uninstall.sh | 2017-03-15 | 399 Bytes | |
| ResetInMemoryWorkload.sql | 2017-03-15 | 240 Bytes | |
| MoveLogOnPmem.sql | 2017-03-15 | 357 Bytes | |
| ODBC-CLI-install.sh | 2017-03-15 | 3.1 kB | |
| DropAdventureWorks.sql | 2017-03-15 | 151 Bytes | |
| InMemoryWorkload.sh | 2017-03-15 | 303 Bytes | |
| InMemoryWorkload.sql | 2017-03-15 | 1.1 kB | |
| JoinQuery.sql | 2017-03-15 | 345 Bytes | |
| CreateTpccWithInMemoryOnPmem.sql | 2017-03-15 | 560 Bytes | |
| DetachAdventurWorks.sql | 2017-03-15 | 247 Bytes | |
| CreateTable.sql | 2017-03-15 | 113 Bytes | |
| CreateTpccOnPmem.sql | 2017-03-15 | 570 Bytes | |
| AttachAdventureWorksLogs-to-pmem.sql | 2017-03-15 | 244 Bytes | |
| BackupAdventureWorks.sql | 2017-03-15 | 143 Bytes | |
| ContinuousRecordUpdate.sql | 2017-03-15 | 345 Bytes | |
| CreateSampleTable.sql | 2017-03-15 | 421 Bytes | |
| AddColumnStore.sql | 2017-03-15 | 208 Bytes | |
| AttachAdventureWorksLogs-to-disk.sql | 2017-03-15 | 244 Bytes | |
| VerifyUpdatedRecord.sql | 2017-03-15 | 157 Bytes | |
| VerifyUsedColumnStore.sql | 2017-03-15 | 321 Bytes | |
| Table_stress.sql | 2017-03-15 | 903 Bytes | |
| test-persistency.sh | 2017-03-15 | 604 Bytes | |
| UpdateRecord.sql | 2017-03-15 | 145 Bytes | |
| SQLServer2014_InMemory_Sample.sql | 2017-03-15 | 71.2 kB | |
| StressDB.sql | 2017-03-15 | 223 Bytes | |
| SetOnlineWithLogOnPmem.sql | 2017-03-15 | 453 Bytes | |
| SimpleQuery.sql | 2017-03-15 | 125 Bytes | |
| StoredProcedure.sql | 2017-03-15 | 204 Bytes | |
| Totals: 34 Items | 86.1 kB | 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.