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

Accessing SQL Server resources

Now that we understand the authentication/authorization process, we can create more detailed user access policies on the server and/or database level. Also, we will go into more detail about fixed server-side and database roles.

Server-level permissions

SQL Server provides nine fixed server roles. The permissions that are granted to the fixed server roles cannot be changed. You can create user-defined server roles and add server-level permissions to those roles:

  • sysadmin: Members of the sysadmin fixed server role can perform any activity on the server.
  • serveradmin: Members of the serveradmin fixed server role can change server-wide configuration options and shut down the server.
  • securityadmin: Members of the securityadmin fixed server role manage logins and their properties. They can GRANT, DENY, and REVOKE server-level permissions. They can also GRANT, DENY, and REVOKE database-level permissions if they have access to a database.
  • processadmin: Members of the processadmin...
Previous Section
End of Section 4
Next Section