Pro SQL Server 2022 Administration: A Guide for the Modern DBA

This book provides comprehensive guidance for SQL Server DBAs,covering new features like Ledger for immutable record of table history,integration with cloud providers for hybrid cloud scenarios,performance optimizations,and security controls. It covers planning deployment,installing and configuring SQL Server,administering and optimizing database objects,and ensuring data security and availability. It also teaches advanced maintenance and tuning techniques,and explores SQL Server's hybrid cloud functionality. Ideal for on-premise SQL Server DBAs and those interested in learning advanced features.

Format: Paperback / softback
Length: 987 pages
Publication date: 29 November 2022
Publisher: APress

This comprehensive guide for SQL Server DBAs covers all the essential knowledge required for efficient daily work. Updated for SQL Server 2022, it includes extensive coverage of new features like Ledger, which provides an immutable record of table history to protect against malicious data tampering, and integration with cloud providers to support hybrid cloud scenarios. You'll also find new content on performance optimizations, such as query pan feedback, and security controls, such as new database roles, restructured for modern ways of working.

The guide takes DBAs through the entire process of planning their SQL Server deployment, installing and configuring the instance, administering and optimizing database objects, and ensuring data security and high availability. Readers will learn advanced maintenance and tuning techniques, as well as explore SQL Server's hybrid cloud functionality.

The book emphasizes best-practice installation, demonstrates scalability and high availability configuration, and covers a wide range of database-level maintenance tasks, including index maintenance, database consistency checks, and table optimizations. By mastering these skills, DBAs can optimize SQL Server performance, improve data security, and ensure the smooth operation of their databases.

Whether you're a seasoned DBA or just starting your journey in database administration, this guide is an invaluable resource for achieving success with SQL Server 2022.

Weight: 1886g
Dimension: 254 x 178 (mm)
ISBN-13: 9781484288634
Edition number: 3rd ed.