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

Mssql-scripter tool

Microsoft is pushing really hard to fill in the gaps in the world of Linux regarding SQL Server on Linux. In the Windows environment, it has it all, from the official application over third-party and other commercial, non-commercial, and open source tools.

In this phase of development, CTP 1.3 - RC1, Microsoft started two open source projects on GitHub to help the Linux community become quicker and more productive using SQL Server on Linux. One of them is mssql-scripter (https://github.com/Microsoft/sql-xplat-cli)

It is a cross-platform, command-line interface with the purpose of generating DDL and DML scripts. If you are dealing with databases, then you will appreciate this quite impressive tool. With a simple command, you can export schema from your database, for example, AdventureWorks, and recreate it on the other server. Also, it is easy to script all the database data and insert it into a new environment. We can say that mssql-scripter can be used even in the ETL...

Previous Section
End of Section 4
Next Section