國立高雄大學圖資館 |

Language: English

Back

Pro SQL Server 2022 administrationa guide for the modern DBA /

Record Type:	Electronic resources : Monograph/item
Title/Author:	Pro SQL Server 2022 administrationby Peter A. Carter.
Reminder of title:	a guide for the modern DBA /
Author:	Carter, Peter A.
Published:	Berkeley, CA :Apress :2023.
Description:	xxiii, 987 p. :ill., digital ;24 cm.
Contained By:	Springer Nature eBook
Subject:	Client/server computing.
Online resource:	https://doi.org/10.1007/978-1-4842-8864-1
ISBN:	9781484288641$q(electronic bk.)

Pro SQL Server 2022 administrationa guide for the modern DBA /
Carter, Peter A.

Pro SQL Server 2022 administrationa guide for the modern DBA /[electronic resource] :by Peter A. Carter. - Third edition. - Berkeley, CA :Apress :2023. - xxiii, 987 p. :ill., digital ;24 cm.

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.

ISBN: 9781484288641$q(electronic bk.)

Standard No.: 10.1007/978-1-4842-8864-1doiSubjects--Uniform Titles:

SQL server.
Subjects--Topical Terms:

182238
Client/server computing.

LC Class. No.: QA76.76.M52

Dewey Class. No.: 005.74

Pro SQL Server 2022 administrationa guide for the modern DBA /
LDR:03175nmm a2200325 a 4500 001 645667
003 DE-He213
005 20221127200609.0
006 m d
007 cr nn 008maaau
008 231208s2023 cau s 0 eng d
020 $a 9781484288641$q(electronic bk.)
020 $a 9781484288634$q(paper)
024 7 $a 10.1007/978-1-4842-8864-1 $2 doi
035 $a 978-1-4842-8864-1
040 $a GP $c GP $e rda
041 0 $a eng
050 4 $a QA76.76.M52
072 7 $a UMP $2 bicssc
072 7 $a COM051380 $2 bisacsh
072 7 $a UMP $2 thema
082 0 4 $a 005.74 $2 23
090 $a QA76.76.M52 $b C324 2023
100 1 $a Carter, Peter A. $3 732024
245 1 0 $a Pro SQL Server 2022 administration $h [electronic resource] : $b a guide for the modern DBA / $c by Peter A. Carter.
250 $a Third edition.
260 $a Berkeley, CA : $b Apress : $b Imprint: Apress, $c 2023.
300 $a xxiii, 987 p. : $b ill., digital ; $c 24 cm.
520 $a 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.
630 0 0 $a SQL server. $3 199469
650 0 $a Client/server computing. $3 182238
650 0 $a SQL (Computer program language) $3 189402
650 0 $a Database management. $3 182428
650 1 4 $a Microsoft. $3 915087
650 2 4 $a Database Management. $3 273994
710 2 $a SpringerLink (Online service) $3 273601
773 0 $t Springer Nature eBook
856 4 0 $u https://doi.org/10.1007/978-1-4842-8864-1
950 $a Professional and Applied Computing (SpringerNature-12059)