001453457 000__ 05234cam\a2200517\i\4500 001453457 001__ 1453457 001453457 003__ OCoLC 001453457 005__ 20230314003352.0 001453457 006__ m\\\\\o\\d\\\\\\\\ 001453457 007__ cr\cn\nnnunnun 001453457 008__ 221203s2022\\\\caua\\\\o\\\\\000\0\eng\d 001453457 019__ $$a1352234824$$a1371108133 001453457 020__ $$a9781484288641$$q(electronic bk.) 001453457 020__ $$a1484288645 001453457 020__ $$z9781484288634 001453457 020__ $$z1484288637 001453457 0247_ $$a10.1007/978-1-4842-8864-1$$2doi 001453457 035__ $$aSP(OCoLC)1352975208 001453457 040__ $$aEBLCP$$beng$$erda$$cEBLCP$$dORMDA$$dGW5XE$$dYDX$$dEBLCP$$dOCLCF$$dUKAHL$$dOCLCQ$$dTEFOD$$dN$T 001453457 049__ $$aISEA 001453457 050_4 $$aQA76.76.M52 001453457 08204 $$a005.74$$223/eng/20230228 001453457 1001_ $$aCarter, Peter A.,$$eauthor. 001453457 24510 $$aPro SQL Server 2022 Administration :$$bA Guide for the Modern DBA /$$cPeter A. Carter. 001453457 250__ $$aThird edition. 001453457 264_1 $$aBerkeley, CA :$$bApress L. P.,$$c2022. 001453457 300__ $$a1 online resource (xxiii, 987 pages) :$$billustrations 001453457 336__ $$atext$$btxt$$2rdacontent 001453457 337__ $$acomputer$$bc$$2rdamedia 001453457 338__ $$aonline resource$$bcr$$2rdacarrier 001453457 500__ $$aDescription based upon print version of record. 001453457 5050_ $$aPart I: Installation and Configuration -- 1. Planning the Deployment -- 2. GUI Installation-3. Server Core Installation -- 4. Installation on Heterogeneous Operating Systems -- 5. Configuring the Instance.- -- Part II: Database Administration -- 6. Database Configuration -- 7. Table Optimizations -- 8. Indexes and Statistics -- 9. Database Consistency.- -- Part III: Security, Resilience, and Scaling Workloads -- 10. SQL Server Security Model -- 11. Auditing & Ledger -- 12. Encryption -- 13. Backups and Restores -- 14. High Availability and Disaster Recovery Concepts -- 15. Implementing AlwaysOn Availability Groups -- 16. Implementing Log Shipping -- 17. Scaling Workloads -- Part IV: Performance and Maintenance -- 18. SQL Server Metadata -- 19. Locking and Blocking -- 20. Extended Events -- 21. Monitoring & Managing a Hybrid Environment -- 22. Query Store -- 23. Automating Maintenance Routines -- 24. Policy-Based Management -- 25. Resource Governor. 001453457 506__ $$aAccess limited to authorized users. 001453457 520__ $$aGet 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. 001453457 63000 $$aSQL server. 001453457 650_0 $$aClient/server computing. 001453457 650_0 $$aSQL (Computer program language) 001453457 650_0 $$aDatabase management. 001453457 655_0 $$aElectronic books. 001453457 77608 $$iPrint version:$$aCarter, Peter A.$$tPro SQL Server 2022 Administration$$dBerkeley, CA : Apress L. P.,c2022$$z9781484288634 001453457 852__ $$bebk 001453457 85640 $$3Springer Nature$$uhttps://univsouthin.idm.oclc.org/login?url=https://link.springer.com/10.1007/978-1-4842-8864-1$$zOnline Access$$91397441.1 001453457 909CO $$ooai:library.usi.edu:1453457$$pGLOBAL_SET 001453457 980__ $$aBIB 001453457 980__ $$aEBOOK 001453457 982__ $$aEbook 001453457 983__ $$aOnline 001453457 994__ $$a92$$bISE