SQL Server on Linux: Configuring and administering your SQL Server solution on Linux

✍ Scribed by Jasmin Azemovic

• Publisher: Packt Publishing
• Year: 2017
• Tongue: English
• Leaves: 215
• Category: Library

✦ Synopsis

Key Features

• Design and administer your SQL Server solution on the open source Linux platform
• Install, configure, and fine-tune your database application for maximum performance
• An easy-to-follow guide teaching you how to implement various SQL Server CTP 2.x offerings on Linux―from installation to administration

Book Description

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.

What you will learn

• Install and set up SQL Server CTP 2.x on Linux
• Create and work with database objects using SQL Server on Linux
• Configure and administer SQL Server on Linux-based systems
• Create and restore database back-ups
• Protect sensitive data using the built-in cryptographic features
• Optimize query execution using indexes
• Improve query execution time by

✦ Table of Contents

Cover
Copyright
Credits
About the Author
About the Reviewer
www.PacktPub.com
Customer Feedback
Table of Contents
Preface
Chapter 1: Linux Distributions
Supported Linux distributions
openSUSE
Installation procedure
Kubuntu
Installation procedure
Summary
Chapter 2: Installation and Configuration
Bash, really quick start
SQL Server installation on openSUSE
SQL Server installation on Kubuntu
Summary
Chapter 3: SQL Server Basics
Overview of SQL Server
Client-server architecture concepts
SQL Server components
How it works on Linux
SQL Server objects
System databases
Database objects
SQL Server data types
SQL/T-SQL basics
History of SQL/TSQL
Types of SQL statements
DDL - Data Definition Language
DCL - Data Control Language
DML - Data Manipulation Language
Working environments and tools
sqlcmd
bcp
Visual Studio code
SQL Server Management Studio (SSMS)
Summary
Chapter 4: Database in the Sandbox
DDL statements
Creating a new database
Creating new tables
DML statements
Data manipulation
Changing table definition
Dropping a table
Creating other database objects
Creating views
Creating stored procedures
Creating triggers
Summary
Chapter 5: Sample Databases
Relational database concepts
Normalization
First normal form
Second normal form
Third normal form
Northwind database
Pubs database
AdventureWorks database
Installing AdventureWorks
WideWorldImporters database
Summary
Chapter 6: A Crash Course in Querying
Retrieving and filtering data
Retrieving data from a table
String functions
Exercise
Filtering data
Comparison operators
String comparison
Logical operators
Working with NULL values
Manipulating query output
Overview of aggregate functions
Aggregate functions and NULL values
GROUP BY clause
HAVING clause
JOIN operators
INNER JOIN
OUTER JOIN
Multiple joins
Summary
Chapter 7: Backup and Recovery Operations
SQL Server recovery models
Simple recovery model
Full recovery model
Bulk-logged recovery model
How transaction log works
Elements of backup strategy
Who can create backups?
Backup media
Types of backup
Full database backups
Transaction log backups
Differential backups
Backup and restore
Summary
Chapter 8: User Management
Authentication process
Authorization process
Accessing SQL Server resources
Server-level permissions
Database-level permissions
Schema separation
Summary
Chapter 9: Implementing Data Protection
Crash course in cryptography
Symmetric cryptography
Asymmetric cryptography
What is a key?
SQL Server cryptographic elements
T-SQL functions
Certificates
Service Master Key
Database master key
Transparent Data Encryption
Backup encryption
Symmetric encryption
Row-level security
Dynamic data masking
Summary
Chapter 10: Indexing
Indexing concepts
Accessing the data
Index structure
Single and composite indexes
Ascending and descending indexes
Clustered index
What is a heap
Non-clustered index
Unique indexes
Columnstore index
Summary
Chapter 11: In-Memory OLTP
Elements of performance
The good
The bad
The ugly
What is In-Memory OLTP?
In-Memory OLTP quick start
How to create memory-optimized tables?
What is natively compiled stored procedure?
Summary
Chapter 12: Beyond SQL Server
Query store
Temporal tables
Mssql-scripter tool
DBFS tool
DBeaver – third party tool
Summary
Conclusion
Index