An all-encompassing guide for the SQL Server DBA, covering the gamut of what any practicing database administrator needs to know to get their daily work done. Updated for SQL Server 2019, this edition of includes coverage of new features such as Static Data Masking, and the Hybrid Buffer Pool. Other new content includes coverage of Query Store, Installation on Linux, and resumable DDL operations. takes DBAs on a journey that begins with planning their SQL Server deployment and runs through to installing and configuring the instance, administering and optimizing database objects, and ensuring that data is secure and highly available. Finally, readers will learn how to perform advanced maintenance and tuning techniques. teaches how to make the most of new SQL Server 2019 functionality, including resumable online index creation and the Always Encrypted feature with secure enclaves. The book promotes best-practice installation, shows how to configure for scalability and high workloads, and demonstrates the gamut of database-level maintenance tasks such as index maintenance, database consistency checks, and table optimizations.  For SQL Server DBAs who are managing on-premise installations of SQL Server. Also useful for DBAs wishing to learn advanced features like Query Store, Extended Events, Distributed Replay and Policy-Based Management, or those who need to install SQL Server in a variety of environments. weiterlesen