{"product_id":"pro-sql-server-2022-administration-a-guide-for-the-modern-dba-9781484288634","title":"Pro SQL Server 2022 Administration: A Guide for the Modern DBA","description":"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.\u003cbr\u003e\u003cb\u003e\u003ci\u003ePro SQL Server 2022 Administration\u003c\/i\u003e\u003c\/b\u003e 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 issecure and highly available. Readers will learn how to perform advanced maintenance and tuning techniques, and discover SQL Server's hybrid cloud functionality.\u003cbr\u003eThis 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. \u003cp\u003e\u003c\/p\u003e\u003cb\u003eWhat You Will Learn\u003c\/b\u003e\u003cul\u003e\n\u003cli\u003eIntegrate SQL Server with Azure for hybrid cloud scenarios\u003c\/li\u003e\n\u003cli\u003eAudit changes and prevent malicious data changes with SQL Server's Ledger\u003c\/li\u003e\n\u003cli\u003eSecure and encrypt data to protect against embarrassing data breaches\u003c\/li\u003e\n\u003cli\u003eEnsure 24 x 7 x 365 access through high availability and disaster recovery features in today's hybrid world\u003c\/li\u003e\n\u003cli\u003eUse Azure tooling, including Arc, to gain insight into and manage your SQL Server enterprise\u003c\/li\u003e\n\u003cli\u003eInstall and configure SQL Server on Windows, Linux, and in containers \u003c\/li\u003e\n\u003cli\u003ePerform routine maintenance tasks, such as backups and database consistency checks \u003c\/li\u003e\n\u003cli\u003eOptimize performance and undertake troubleshooting in the Database Engine\u003c\/li\u003e\n\u003c\/ul\u003e\u003cbr\u003e\u003cb\u003eWho This Book Is For\u003c\/b\u003e\u003cbr\u003eSQL 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.\u003cbr\u003e\u003cbr\u003e\u003cbr\u003e\u003cbr\u003e\u003cb\u003eAbout the Author\u003c\/b\u003e\u003cbr\u003e\u003cb\u003ePeter Carter\u003c\/b\u003e is a SQL Server expert with over 15 years of experience in developing, administering, and architecting SQL Server platforms and data-tier applications. He was awarded an MCC by Microsoft in 2011 to sit alongside his array of MCTS, MCITP, MCSA, and MCSE certifications in SQL Server from version 2005 onward. Peter has written a number of books across a variety of SQL Server topics, including security, high availability, and automation.\u003cbr\u003e","brand":"Apress","offers":[{"title":"Default Title","offer_id":50454009086226,"sku":"9781484288634","price":57.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0831\/4771\/8930\/files\/img_925c3b5f-3935-4010-9a58-15207f7ab293.jpg?v=1729860454","url":"https:\/\/surprise-castle.myshopify.com\/products\/pro-sql-server-2022-administration-a-guide-for-the-modern-dba-9781484288634","provider":"Surprise Castle","version":"1.0","type":"link"}