Get your daily work done efficiently using this comprehensive guide for SQL Server DBAs that covers all that a practicing database administrator needs to know. Updated for SQL Server 2022, this edition includes coverage of new features, such as Ledger, which provides an immutable record of table history to protect you 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, which are restructured for modern ways of working. Coverage also includes Query Store, installation on Linux, and the use of containerized SQL.

Pro SQL Server 2022 Administration takes DBAs on a journey that begins with planning their SQL Server deployment and runs through installing and configuring the instance, administering and optimizing database objects, and ensuring that data is secure and highly available. Readers will learn how to perform advanced maintenance and tuning techniques, and discover SQL Server's hybrid cloud functionality.

This book teaches you how to make the most of new SQL Server 2022 functionality, including integration for hybrid cloud scenarios. The book promotes best-practice installation, shows how to configure for scalability and high availability, and demonstrates the gamut of database-level maintenance tasks, such as index maintenance, database consistency checks, and table optimizations.

What You Will Learn

Integrate SQL Server with Azure for hybrid cloud scenarios
Audit changes and prevent malicious data changes with SQL Server’s Ledger
Secure and encrypt data to protect against embarrassing data breaches
Ensure 24 x 7 x 365 access through high availability and disaster recovery features in today’s hybrid world
Use Azure tooling, including Arc, to gain insight into and manage your SQL Server enterprise
Install and configure SQL Server on Windows, Linux, and in containers
Perform routine maintenance tasks, such as backups and database consistency checks
Optimize performance and undertake troubleshooting in the Database Engine

Who This Book Is For

SQL Server DBAs who manage on-premise installations of SQL Server. This book is also useful for DBAs who wish to learn advanced features, such as integration with Azure, Query Store, Extended Events, and Policy-Based Management, or those who need to install SQL Server in a variety of environments.

"Synopsis" may belong to another edition of this title.

WorldofBooks

Goring-By-Sea, WS, United Kingdom

5-star seller

AbeBooks seller since March 16, 2007

Shipping rates from United Kingdom to U.S.A.

Item	7 to 12 business days	5 to 9 business days
First item	US$ 7.48	US$ 16.02

Delivery times are set by sellers and vary by carrier and location. Orders passing through Customs may face delays and buyers are responsible for any associated duties or fees. Sellers may contact you regarding additional charges to cover any increased costs to ship your items.

Payment methods

Store description

In 2002, World of Books Group was founded on an ethos to do good, protect the planet and support charities by enabling more goods to be reused. Since then, we've grown into to a global company pioneering the circular economy. Today, we drive the circular economy through three re-commerce brands: - Wob: Through Wob, we sell. We provide affordable, preloved books and media to customers all over the world. A book leaves our collection of over seven million titles and begins a new chapter every two seconds, enabling more goods to be reused. - Ziffit: Through Ziffit, we buy. We give people around the world the opportunity to contribute to the circular economy, earn money and protect the planet, by trading their unwanted books and media. - Shopiago: Through Shopiago, we help others. By sharing the technology that has grown World of Books Group into the business it is today, we’re helping charities increase revenue and reduce waste through re-commerce.…

Specialty

COOKERY, RECYCLE, CHARITY, USED BOOKS, MODERN, HISTORY, CHILDRENS, FICTION, CHEAP BOOKS, NON -FICTION

Seller's business information

World of Books Ltd

Mulberry House, Woods Way Trading Estate
Goring-By-Sea, United Kingdom BN12 4QY

View this seller's itemsView seller's storefront

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

Item description from seller

Bibliographic details

Synopsis

About the title

About the Author

WorldofBooks

Shipping rates from United Kingdom to U.S.A.

Payment methods

Store description

Specialty

Seller's business information

Terms of sale

Shipping terms