Book Image

SQL Server on Linux

Book Image

SQL Server on Linux

Overview of this book

Microsoft's launch of SQL Server on Linux has made SQL Server a truly versatile platform across different operating systems and data-types, both on-premise and on-cloud. This book is your handy guide to setting up and implementing your SQL Server solution on the open source Linux platform. You will start by understanding how SQL Server can be installed on supported and unsupported Linux distributions. Then you will brush up your SQL Server skills by creating and querying database objects and implementing basic administration tasks to support business continuity, including security and performance optimization. This book will also take you beyond the basics and highlight some advanced topics such as in-memory OLTP and temporal tables. By the end of this book, you will be able to recognize and utilize the full potential of setting up an efficient SQL Server database solution in your Linux environment.

Related Content you might be interested in

Current Title:

Small book image
SQL Server on Linux
Aug, 2017 | 222 pages
Small book image
SQL Server 2019 Administrator's Guide
Vladimir Muzny | Marek Chmel
Sep, 2020 | 522 pages
Small book image
SQL Server 2017 Administrator's Guide
Vladimir Muzny | Marek Chmel
Dec, 2017 | 434 pages
Small book image
Introducing Microsoft SQL Server 2019
Dave Noderer | Gregory Woody | Kellyn Gorman | James RowlandJones | Mitchell Pearson | Dustin Ryan | Allan Hirt | Arun Sirpal
Apr, 2020 | 488 pages
Table of Contents (19 chapters)
Title Page
Title Page
Credits
Credits
About the Author
About the Author
About the Reviewer
About the Reviewer
www.PacktPub.com
www.PacktPub.com
Customer Feedback
Customer Feedback
Preface
Preface
Free Chapter
1
Linux Distributions
Linux Distributions
Supported Linux distributions
openSUSE
Installation procedure
Kubuntu
Summary
2
Installation and Configuration
Installation and Configuration
Bash, really quick start
SQL Server installation on openSUSE
SQL Server installation on Kubuntu
Summary
3
SQL Server Basics
SQL Server Basics
Overview of SQL Server
How it works on Linux
SQL Server objects
SQL/T-SQL basics
Working environments and tools
Summary
4
Database in the Sandbox
Database in the Sandbox
DDL statements
DML statements
Summary
5
Sample Databases
Sample Databases
Relational database concepts
Normalization
Northwind database
Pubs database
AdventureWorks database
WideWorldImporters database
Summary
6
A Crash Course in Querying
A Crash Course in Querying
Retrieving and filtering data
Overview of aggregate functions
JOIN operators
Summary
7
Backup and Recovery Operations
Backup and Recovery Operations
SQL Server recovery models
How transaction log works
Elements of backup strategy
Backup and restore
Summary
8
User Management
User Management
Authentication process
Authorization process
Accessing SQL Server resources
Schema separation
Summary
9
Implementing Data Protection
Implementing Data Protection
Crash course in cryptography
Transparent Data Encryption
Backup encryption
Symmetric encryption
Row-level security
Dynamic data masking
Summary
10
Indexing
Indexing
Indexing concepts
Clustered index
What is a heap
Non-clustered index
Columnstore index
Summary
11
In-Memory OLTP
In-Memory OLTP
Elements of performance
What is In-Memory OLTP?
Summary
12
Beyond SQL Server
Beyond SQL Server
Query store
Temporal tables
Mssql-scripter tool
DBFS tool
DBeaver – third party tool
Summary
Conclusion

SQL Server installation on Kubuntu

The installation procedure on Kubuntu is identical to that in Ubuntu 16.04 and 16.10, which are officially supported by Microsoft. Kubuntu and Ubuntu share the same version numbering. My installation example is based on Kubuntu 16.10.

The whole installation procedure is command line-based. It means that you will be required to use bash.

Note

If you want to start installation, you will need minimum 3.25GB of memory to run SQL Server on Linux.

The following are the steps to install SQL Server on Linux on Kubuntu:

  1. The first step is to add GPG keys and register SQL Server Ubuntu repository:
        # curl https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -
        # curl https://packages.microsoft.com/config/ubuntu/16.04/mssql-server.list | sudo tee
        /etc/apt/sources.list.d/mssql-server.list
  1. Run the following two commands to install SQL Server. The first one is to refresh the packages list and the second one to start setting up:
        #...
Previous Section
End of Section 4
Next Section