SQL Server 2022 Revealed: A Hybrid Data Platform Powered by Security, Performance, and Availability Paperback – 28 Oct. 2022

ConclusionThis book aims to explain the new features in SQL Server 2022, and certainly succeeds. The book is generally easy to read, with useful discussions, diagrams, inter-chapter links, helpful example code, and a vast number of useful website links for further information. The extensive weblinks could easily make this book 30-50 times larger.The most outstanding feature of the book is the author’s style of writing (often through stories), and his lucid explanations, which together make the book an almost effortless read.The book is largely concerned with the new features in SQL Server 2022, but also includes details of some perhaps less familiar areas (e.g. SQL Server on Linux, VMs). If you’re familiar with Azure SQL PaaS database offerings, you may recognise many of the new features. With new features, there are often functional limitations, and these are typically described, and will surely be eased in future editions.Many of the author’s insights are based on customer feedback and his extensive experience in using the product. Reading this book will allow you to take advantage of his experience, to give direction to your own projects.The book is aimed at DBAs and developers. SQL Server’s new features are often enhancement to existing features, so some experience of SQL Server (perhaps a few years) is advantageous.Using Azure Extension for SQL Server for on-prem, and IaaS extension agent for Azure VMs, shows Microsoft is keen to integrate your SQL Servers into the Azure environment, where you can take advantage of many automatic features.If you want to get up to speed with the latest SQL Server functionality, I can highly recommend this book.