Muutke küpsiste eelistusi

Pro SQL Server 2019 Administration: A Guide for the Modern DBA 2nd ed. [Pehme köide]

4.20/5 (5 hinnangut Goodreads-ist)
  • Formaat: Paperback / softback, 940 pages, kõrgus x laius: 254x178 mm, kaal: 1805 g, 309 Illustrations, black and white; XXV, 940 p. 309 illus., 1 Paperback / softback
  • Ilmumisaeg: 19-Oct-2019
  • Kirjastus: APress
  • ISBN-10: 1484250885
  • ISBN-13: 9781484250884
Teised raamatud teemal:
  • Pehme köide
  • Hind: 70,74 €*
  • * saadame teile pakkumise kasutatud raamatule, mille hind võib erineda kodulehel olevast hinnast
  • See raamat on trükist otsas, kuid me saadame teile pakkumise kasutatud raamatule.
  • Kogus:
  • Lisa ostukorvi
  • Tasuta tarne
  • Lisa soovinimekirja
Pro SQL Server 2019 Administration: A Guide for the Modern DBA 2nd ed.Suurem pilt
  • Formaat: Paperback / softback, 940 pages, kõrgus x laius: 254x178 mm, kaal: 1805 g, 309 Illustrations, black and white; XXV, 940 p. 309 illus., 1 Paperback / softback
  • Ilmumisaeg: 19-Oct-2019
  • Kirjastus: APress
  • ISBN-10: 1484250885
  • ISBN-13: 9781484250884
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9781484250884.html
Intermediate-Advanced user level

Use this comprehensive guide for the SQL Server DBA, covering all that practicing database administrators need to know to get their daily work done. Updated for SQL Server 2019, this edition includes coverage of new features such as Memory-optimized TempDB Metadata, and Always Encrypted with Secure Enclaves. Other new content includes coverage of Query Store, resumable index operations, installation on Linux, and containerized SQL.

Pro SQL Server 2019 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. Finally, readers will learn how to perform advanced maintenance and tuning techniques.

This book teaches you to make the most of new SQL Server 2019 functionality, including Data Discovery and Classification. The book promotes best-practice installation, shows how to configure for scalability and high workloads, and demonstrates the gamut of database-level maintenance tasks such as index maintenance, database consistency checks, and table optimizations. 


What You Will Learn
  • Install and configure SQL Server on Windows through the GUI and with PowerShell 
  • Install and configure SQL Server on Linux and in Containers
  • Optimize tables through in-memory OLTP, table partitioning, and the creation of indexes
  • Secure and encrypt data to protect against embarrassing data breaches
  • Ensure 24x7x365 access through high-availability and disaster recovery features
  • Back up your data to ensure against loss, and recover data when needed
  • Perform routine maintenance tasks such as database consistency checks  
  • Troubleshoot and solve performance problems in SQL queries and 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 Query Store, Extended Events, Distributed Replay, and Policy-Based Management, or those who need to install SQL Server in a variety of environments.
About the Author xix
About the Technical Reviewer xxi
Acknowledgments xxiii
Introduction xxv
Part I Installation and Configuration
1(162)
Chapter 1 Planning the Deployment
3(26)
Editions and License Models
3(3)
Hardware Considerations
6(11)
Specifying Strategic Minimum Requirements
7(1)
Storage
7(10)
Operating Systems Considerations
17(1)
Configuring the Operating System
18(4)
Setting the Power Plan
18(1)
Optimizing for Background Services
18(1)
Assigning User Rights
19(3)
Selecting Features
22(5)
Database Engine Service
23(1)
Analysis Services
24(1)
Machine Learning Server
24(1)
Data Quality Client
25(1)
Client Connectivity Tools
25(1)
Integration Services
25(1)
Client Tools Backward Compatibility
25(1)
Client Tools SDK
26(1)
Distributed Replay Controller
26(1)
Distributed Replay Client
26(1)
SQL Client Connectivity SDK
26(1)
Master Data Services
27(1)
Summary
27(2)
Chapter 2 GUI Installation
29(44)
Installation Center
29(10)
The Planning Tab
29(2)
The Installation Tab
31(1)
The Maintenance Tab
32(2)
The Tools Tab
34(1)
The Resources Tab
35(1)
The Advanced Tab
36(3)
The Options Tab
39(1)
Installing a Stand-Alone Database Engine Instance
39(31)
Preparation Steps
40(5)
The Feature Selection Page
45(3)
The Instance Configuration Page
48(2)
Selecting Service Accounts
50(3)
Choosing the Collation
53(6)
Provisioning Instance Security
59(2)
Configuring the Instance
61(6)
Configuring Distributed Replay
67(1)
Completing the Installation
68(2)
Summary
70(3)
Chapter 3 Server Core Installation
73(28)
Installing an Instance
73(18)
Required Parameters
74(3)
Role Parameter
77(1)
Basic Installation
77(2)
Smoke Tests
79(3)
Troubleshooting the Installation
82(3)
Optional Parameters
85(4)
Product Update
89(2)
Using a Config File
91(4)
Automatic Installation Routines
95(5)
Enhancing the Installation Routine
96(2)
Production Readiness
98(2)
Summary
100(1)
Chapter 4 Installation on Heterogeneous Operating Systems
101(26)
Installing SQL Server on Linux
101(10)
Installing SQL Server Manually
102(3)
Configuring SQL Server
105(3)
Unattended Installation
108(3)
Installing SQL Server in a Docker Container
111(14)
Running a Microsoft-Supplied Docker Image
111(2)
Creating a Simple Docker Image for SQL Server
113(6)
Creating a Configurable Docker Image for SQL Server
119(6)
Kubernetes Support
125(1)
Summary
125(2)
Chapter 5 Configuring the Instance
127(36)
Instance Configuration
127(19)
Using sp_configure
127(2)
Processor and Memory Configuration
129(12)
Trace Flags
141(5)
Ports and Firewalls
146(6)
Process of Communication
146(2)
Ports Required by SQL Server
148(1)
Configuring the Port That the Instance Will Listen On
149(3)
System Databases
152(7)
Mssqlsystemresource (Resource)
152(1)
MSDB
153(1)
Master
153(1)
Model
154(1)
TempDB
154(5)
Buffer Pool Extension
159(2)
Hybrid Buffer Pool
161(1)
Summary
162(1)
Part II Database Administration
163(164)
Chapter 6 Database Configuration
165(40)
Datastorage
165(18)
Filegroups
166(4)
Filestream Filegroups
170(7)
Memory-Optimized Filegroups
177(3)
Strategies for Structured Filegroups
180(2)
Strategies for Memory-Optimized Filegroups
182(1)
File and Filegroup Maintenance
183(7)
Adding Files
183(3)
Expanding Files
186(1)
Shrinking Files
187(3)
Database Scoped Configurations
190(1)
Log Maintenance
191(11)
Recovery Model
192(1)
Log File Count
193(1)
Shrinking the Log
194(1)
Log Fragmentation
195(7)
Summary
202(3)
Chapter 7 Table Optimizations
205(40)
Table Partitioning
205(18)
Partitioning Concepts
206(3)
Implementing Partitioning
209(7)
Monitoring Partitioned Tables
216(2)
Sliding Windows
218(3)
Partition Elimination
221(2)
Table Compression
223(9)
Row Compression
224(1)
Page Compression
225(2)
Columnstore Compression
227(1)
Implementing Compression
228(4)
Memory-Optimized Tables
232(12)
Durability
233(1)
Creating and Managing Memory-Optimized Tables
233(3)
Performance Profile
236(4)
Table Memory Optimization Advisor
240(1)
Natively Compiled Objects
241(3)
Summary
244(1)
Chapter 8 Indexes and Statistics
245(48)
Clustered Indexes
245(8)
Tables Without a Clustered Index
246(1)
Tables with a Clustered Index
247(1)
Clustering the Primary Key
248(1)
Administering Clustered Indexes
249(4)
Nonclustered Indexes
253(8)
Covering Indexes
254(1)
Administering Nonclustered Indexes
255(5)
Filtered Indexes
260(1)
Indexes for Specialized Application
261(11)
Columnstore Indexes
261(2)
Clustered Columnstore Indexes
263(2)
Nonclustered Columnstore Indexes
265(1)
In-Memory Indexes
266(6)
Maintaining Indexes
272(12)
Missing Indexes
273(2)
Index Fragmentation
275(5)
Resumable Index Operations
280(3)
Partitioned Indexes
283(1)
Statistics
284(3)
Filtered Statistics
286(1)
Incremental Statistics
287(1)
Managing Statistics
287(3)
Summary
290(3)
Chapter 9 Database Consistency
293(34)
Consistency Errors
293(15)
Understand Consistency Errors
293(2)
Detecting Consistency Errors
295(9)
System Database Corruption
304(4)
DBCC CHECKDB
308(15)
Checking for Errors
308(5)
Fixing Errors
313(2)
Emergency Mode
315(3)
Other DBCC Commands for Corruption
318(5)
Consistency Checks on VLDBs
323(2)
DBCC CHECKDB with PHYSICALJMLY
324(1)
Backing Up WITH CHECKSUM and DBCC CHECKALLOC
324(1)
Splitting the Workload
324(1)
Offloading to a Secondary Server
325(1)
Summary
325(2)
Part III Security, Resilience, and Scaling Workloads
327(294)
Chapter 10 SQL Server Security Model
329(42)
Security Hierarchy
329(3)
Implementing Instance-Level Security
332(9)
Server Roles
334(3)
Logins
337(3)
Granting Permissions
340(1)
Implementing Database-Level Security
341(10)
Database Roles
341(4)
Schemas
345(3)
Creating and Managing Contained Users
348(3)
Implementing Object-Level Security
351(1)
Server Audit
352(13)
Creating a Server Audit
353(3)
Creating a Server Audit Specification
356(2)
Enabling and Invoking Audits
358(1)
Database Audit Specifications
359(5)
Auditing the Audit
364(1)
Security Reports
365(4)
SQL Data Discovery and Classification
365(2)
Vulnerability Assessment
367(2)
Summary
369(2)
Chapter 11 Encryption
371(38)
Encryption Hierarchy
371(6)
Encryption Concepts
371(1)
SQL Server Encryption Concepts
372(5)
Transparent Data Encryption
377(9)
Implementing TDE
378(6)
Managing TDE
384(2)
Managing Cell-Level Encryption
386(6)
Accessing Encrypted Data
391(1)
Always Encrypted
392(15)
Implementing Always Encrypted
394(9)
Administering Keys
403(4)
Summary
407(2)
Chapter 12 Backups and Restores
409(48)
Backup Fundamentals
409(9)
Recovery Models
409(3)
Changing the Recovery Model
412(3)
Backup Types
415(1)
Backup Media
416(2)
Backup Strategies
418(3)
Full Backup Only
419(1)
Full and Transaction Log Backups
419(1)
Full, Differential, and Transaction Log Backups
420(1)
Filegroup Backups
420(1)
Partial Backup
421(1)
Backing Up a Database
421(10)
Backing Up in SQL Server Management Studio
421(3)
Backing UpviaT-SQL
424(7)
Restoring a Database
431(10)
Restoring in SQL Server Management Studio
431(5)
Restoring via T-SQL
436(5)
Restoring to a Point in Time
441(4)
Restoring Files and Pages
445(6)
Restoring a File
446(2)
Restoring a Page
448(3)
Piecemeal Restores
451(3)
Summary
454(3)
Chapter 13 High Availability and Disaster Recovery Concepts
457(28)
Availability Concepts
458(6)
Level of Availability
458(3)
Recovery Point Objective and Recovery Time Objective
461(1)
Cost of Downtime
462(1)
Classification of Standby Servers
463(1)
High Availability and Recovery Technologies
464(19)
AlwaysOn Failover Clustering
464(7)
AlwaysOn Availability Groups
471(6)
Log Shipping
477(3)
Combining Technologies
480(3)
Summary
483(2)
Chapter 14 Implementing AlwaysOn Availability Groups
485(48)
Implementing AlwaysOn Availability Groups
486(22)
Configuring SQL Server
492(2)
Creating the Availability Group
494(14)
Availability Groups on Linux
508(7)
Distributed Availability Groups
515(3)
Managing AlwaysOn Availability Groups
518(12)
Failover
518(6)
Synchronizing Uncontained Objects
524(1)
Monitoring
525(3)
Other Administrative Considerations
528(2)
Summary
530(3)
Chapter 15 Implementing Log Shipping
533(36)
Implementing Log Shipping for DR
533(24)
GUI Configuration
536(10)
T-SQL Configuration
546(11)
Log Shipping Maintenance
557(9)
Failing Over Log Shipping
557(1)
Switching Roles
558(6)
Monitoring
564(2)
Summary
566(3)
Chapter 16 Scaling Workloads
569(52)
Database Snapshots
569(8)
Implementing Database Snapshots
572(4)
Recovering Data from a Snapshot
576(1)
Replication
577(30)
Replication Concepts
577(2)
Types of Replication
579(3)
Implementing Transactional Replication
582(25)
Adding AlwaysOn Readable Secondary Replicas
607(11)
Benefits and Considerations
608(1)
Implementing Readable Secondaries
608(10)
Summary
618(3)
Part IV Performance and Maintenance
621(302)
Chapter 17 SQL Server Metadata
623(36)
Introducing Metadata Objects
623(3)
Server-Level and Instance-Level Metadata
626(5)
Exposing Registry Values
627(1)
Exposing Service Details
628(1)
Analyzing Buffer Cache Usage
629(2)
Metadata for Capacity Planning
631(8)
Exposing File Stats
631(4)
Using File Stats for Capacity Analysis
635(4)
Metadata for Troubleshooting and Performance Tuning
639(8)
Retrieving Perfmon Counters
639(5)
Analyzing Waits
644(3)
Database Metadata
647(5)
Metadata-Driven Automation
652(5)
Dynamically Cycling Database Snapshots
652(3)
Rebuilding Only Fragmented Indexes
655(2)
Summary
657(2)
Chapter 18 Locking and Blocking
659(40)
Understanding Locking
659(9)
Lock Granularity
659(2)
Locking Behaviors for Online Maintenance
661(5)
Lock Compatibility
666(1)
Lock Partitioning
667(1)
Understanding Deadlocks
668(2)
How Deadlocks Occur
668(2)
Minimizing Deadlocks
670(1)
Understanding Transactions
670(11)
Transactional Properties
671(10)
Transaction with In-Memory OLTP
681(6)
Isolation Levels
682(2)
Cross-Container Transactions
684(2)
Retry Logic
686(1)
Observing Transactions, Locks, and Deadlocks
687(9)
Observing Transactions
687(4)
Observing Locks and Contention
691(4)
Observing Deadlocks
695(1)
Summary
696(3)
Chapter 19 Extended Events
699(40)
Extended Events Concepts
699(5)
Packages
700(1)
Events
700(1)
Targets
701(1)
Actions
702(1)
Predicates
702(1)
Types and Maps
702(2)
Sessions
704(1)
Creating an Event Session
704(13)
Using the New Session Dialog Box
707(6)
Using T-SQL
713(4)
Viewing the Collected Data
717(10)
Analyzing Data with Data Viewer
717(6)
Analyzing Data with T-SQL
723(4)
Correlating Extended Events with Operating System Data
727(9)
Correlating Events with Perfmon Data
727(2)
Integrating Event Sessions with Operating System-Level Events
729(7)
Summary
736(3)
Chapter 20 Query Store
739(20)
Enabling and Configuring Query Store
739(7)
Working with Query Store Data
746(10)
SSMS Reports
747(4)
Query Store T-SQL Objects
751(5)
Resolving Issues with Query Store
756(1)
Summary
757(2)
Chapter 21 Distributed Replay
759(50)
Distributed Replay Concepts
760(1)
Distributed Replay Components
760(1)
Distributed Replay Architecture
761(1)
Configuring the Environment
761(7)
Configuring the Controller
762(1)
Configuring Clients
763(2)
Configuring the Replay
765(3)
Working with Distributed Replay
768(39)
Synchronizing the Target
772(1)
Creating a Trace
773(30)
Replaying the Trace
803(4)
Summary
807(2)
Chapter 22 Automating Maintenance Routines
809(54)
SQL Server Agent
809(39)
SQL Server Agent Concepts
810(4)
SQL Server Agent Security
814(3)
Creating SQL Server Agent Jobs
817(25)
Monitoring and Managing Jobs
842(3)
Creating Alerts
845(3)
Multiserver Jobs
848(12)
Configuring the MSX and TSX Servers
848(6)
Creating Master Jobs
854(2)
Managing Target Servers
856(4)
Summary
860(3)
Chapter 23 Policy-Based Management
863(30)
PBM Concepts
863(3)
Facets
863(1)
Conditions
864(1)
Targets
864(1)
Policies
865(1)
Evaluation Modes
865(1)
Central Management Servers
866(8)
Creating Policies
874(11)
Creating Simple Policies
874(9)
Creating an Advanced Policy
883(2)
Managing Policies
885(5)
Importing and Exporting Policies
886(1)
Enterprise Management with Policies
887(2)
Evaluating Policies with PowerShell
889(1)
Summary
890(3)
Chapter 24 Resource Governor
893(30)
Resource Governor Concepts
893(3)
Resource Pool
893(2)
Workload Group
895(1)
Classifier Function
895(1)
Implementing Resource Governor
896(13)
Creating Resource Pools
896(4)
Creating Workload Groups
900(3)
Creating a Classifier Function
903(5)
Testing the Classifier Function
908(1)
Monitoring Resource Governor
909(12)
Monitoring with Performance Monitor
909(4)
Monitoring with DMVs
913(8)
Summary
921(2)
Index 923
Peter Carter 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.