Administering Pro SQL Server 2019
Author: Peter Carter
Public: SQL Server DBA
Examiner: Kay Ewbank
SQL Server administration can seem like a dark art; this book aims to make it more transparent.
The roles of developer and administrator are usually (and fortunately) well separated, but many database developers have at some point had to struggle with administering a database server. This is an updated edition of a well regarded title, and it could be useful if you are able to try to keep (or keep running) SQL Server.
The first part of this book examines the installation and configuration of SQL Server, starting with deployment planning and installation of the GUI, installation of the server core, installation on a system of heterogeneous operation and instance configuration.
If you haven’t had to set up a system like SQL Server, spending 160 pages setting something up might seem like overkill, but the task deserves this coverage. There is good information on how to get SQL Server to work properly with Windows (something you hope is simple but can be problematic), and there are some handy PowerShell scripts to get you started.
Part II moves on to database administration, with chapters on database configuration, table optimization, indexes and statistics, and database consistency. There is good coverage of in-memory optimized features, including filegroups and tables. The consistency chapter includes how to use the DBCC checker and how to perform consistency checks on very large databases where it can be difficult to find the time to run DBCC.
Part III examines security, resiliency, and workload scaling, with chapters on the SQL Server security model, encryption, backups, and restores. This section also contains chapters on the concepts of high availability and disaster recovery, implementing permanent availability groups, sending logs, and scaling workloads.
The final part of the book discusses performance and maintenance, starting with SQL Server metadata (including its use for capacity planning). There is a good chapter on locking and blocking that examines deadlocks and transactions, including in-memory OLTP transactions. This is followed by a chapter on Extended Events and Event Sessions. A new chapter on the query store is followed by an overview of distributed replay. Chapters on automating maintenance routines, policy-based management, and resource governor complete the book.
This is a thick book of over 900 pages, which goes beyond what most developers hopefully should. However, it is comprehensive and explains the concepts well. The author gives many examples, tips and scripts to help you achieve your goals. If you need to administer an instance of SQL Server, this is a useful addition to your library.
SQL Server Pro Administration – an in-depth review by Ian Stirk of the SQL Server 2014 edition.