Table of Contents
Preface
Section 1: Provisioning the SQL Server Environment
Chapter 1: Setting Up SQL Server 2019
Overview of the Microsoft SQL Server 2019 technology 16
Understanding SQL Server DE 18
SSIS 19
SSAS 20
SSRS 22
Machine Learning Services 23
SQL Server Agent 24
Preparing the SQL Server 2019 installation on Windows 24
Edition comparison 25
Pre-installation tasks 25
Installing SQL Server 2019 on Windows 30
Installation options 30
Checking the completed installation 40
Installing SQL Server 2019 on Linux 46
Preparing the test environment 46
Installing SQL Server 47
Testing connection to SQL Server on Linux 48
Installing SQL Server 2019 on containers 49
Summary 50
Chapter 2: Keeping Your SQL Server Environment Healthy ...
Get SQL Server 2019 Administrator's Guide - Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
