|SQL Server 2019 Administration Inside Out|
Page 1 of 2
Author: Randolph West et al
This book aims to update your DBA skills to cover SQL Server 2019, how does it fare?
Each version of SQL Server offers both new functionality and builds on existing features. This book aims to help SQL Server DBAs expand and update their skills to include SQL Server 2019. Although the book primarily focuses on SQL Server 2019, much of it is applicable to earlier versions too.
Part I. Introduction
This section is very much an introduction to features that are typically explained in greater detail in subsequent chapters.
The book opens naturally with an overview on SQL Server installation. This is followed with a brief discussion of various useful tools and services (e.g. Machine Learning Services). A helpful outline of the main admin tool, SQL Server Management Studio (SSMS) is provided, together with its developer-focused counterpart, Azure Data Studio.
The section next looks at an overview of various database server components. Starting with memory, CPU, storage, and network – discussing architecture, and salient features. This is followed with an overview of High Availability (HA) concepts, security, and virtualization. I found this chapter to be an odd assortment of disparate features to group together.
The final chapter in this section looks at database infrastructure, discussing data files and files groups, transaction log, partitioning, compression, tempdb, configuration settings (e.g. MAXDOP), and using containers with Kubernetes. For each topic, its main points are discussed, together with advice for the later versions of SQL Server. Only in the discussion of Kubernetes is a step-by-step usage example provided.
Typically, enough detail is provided on a given topic to get started, together with helpful tips on any common problems. Step-by-step walkthrough instructions are not provided, so it expects a certain amount of experience already. A great many incidental tips are provided in each section, especially relating to the newer features. It could be argued this is the core strength of this book, with the advice coming from experienced SQL Server 2019 DBAs.
Overall, the section is easy to read, with lots of helpful tips, together with links to other chapters and websites for further and deeper investigation. In many ways, the book feels like you are having a conversation with experienced SQL Server DBAs, pointing out best practises and common pitfalls. These traits apply to the whole of the book.
Part II. Deployment
This section first takes a deeper look at installing SQL Server. Various prerequisites are discussed (e.g. service accounts, patching, versions, licencing). Next, the process of installing a new instance is outlined, covering Azure, Windows, and Linux. There is a useful section on stand-alone installation, ideal for repeatability and eliminating human error. An overview of installing the various Business Intelligence features (e.g. SSIS) is also included. Finally, a useful post-installation configuration checklist is provided, and items discussed include: max memory, SQL Agent, Power Plan setting, and anti-virus exclusion.
|Last Updated ( Saturday, 21 November 2020 )|