會員

SQL Server 2019 Administrator's Guide

更新時間：2021-06-11 18:11:38

開會員，本書免費讀 >

Asyouadvance,thebookcoversessentialtopicssuchasmigration,upgrading,andconsolidation,alongwiththetechniquesthatwillhelpyouwhenthingsgowrong.Onceyou’vegottogripswithintegrationwithAzureandstreamliningbigdatapipelines,you’lllearnbestpracticesfromindustryexpertsformaintainingahighlyreliabledatabasesolution.Whetheryouareanadministratororarelookingtogetstartedwithdatabaseadministration,thisSQLServerbookwillhelpyoudeveloptheskillsyouneedtosuccessfullycreate,design,anddeploydatabasesolutions.

目錄(88章)

倒序

封面
版權信息
Why subscribe?
Contributors About the authors
About the reviewers
Packt is searching for authors like you
Preface
Section 1: Provisioning the SQL Server Environment
Chapter 1: Setting Up SQL Server 2019
Overview of the Microsoft SQL Server 2019 technology
Preparing the SQL Server 2019 installation on Windows
Installing SQL Server 2019 on Windows
Installing SQL Server 2019 on Linux
Installing SQL Server 2019 on containers
Summary
Chapter 2: Keeping Your SQL Server Environment Healthy
Understanding SQL Server patching
Configuring SQL Server environment
Creating a performance baseline
Summary
Section 2: Server and Database Maintenance
Chapter 3: Implementing Backup and Recovery
Data structures and transaction logging
Accelerated Database Recovery
SQL Server recovery models
Designing a backup strategy
Using database and log restore
Summary
Chapter 4: Securing Your SQL Server
Configuring SQL Server service accounts
Configuring authentication and authorization
Encrypting SQL Server data
Data Discovery and Classification
SQL Server vulnerability assessment
Encrypting SQL Server connections
Summary
Chapter 5: Working with Disaster Recovery Options
Understanding the basics of disaster recovery
SQL Server options for high availability and disaster recovery
Configuring replication on SQL Server
Understanding database mirroring
Configuring log shipping
Summary
Chapter 6: Indexing and Performance
Explaining SQL Server internals
SQL Server protocols
Performance monitoring overview
Tools for monitoring performance
Indexes and maintenance
Common performance issue patterns
Summary
Section 3: High Availability and the Cloud with SQL Server 2019
Chapter 7: Planning Migration and Upgrade
The importance of keeping up with latest version
Planning the upgrade
Performing the upgrade
Migrating from other platforms
Summary
Chapter 8: Automation – Using Tools to Manage and Monitor SQL Server 2019
Using SQL Server Agent
Creating and editing maintenance plans
Creating SQL Server Agent objects
SQL Server Agent security
Summary
Chapter 9: Configuring Always On High Availability Features
Installing Windows Server Failover Cluster
Configuring Always On Failover Cluster Instances
Always On Availability Groups
Summary
Chapter 10: In-Memory OLTP – Why and How to Use it
In-Memory OLTP architecture
Creating in-memory tables and natively compiled stored procedures
In-Memory OLTP usage scenarios
Monitoring In-Memory OLTP
Summary
Chapter 11: Combining SQL Server 2019 with Azure
Beginning with technologies in Microsoft Azure
Microsoft SQL Server 2019 and hybrid scenarios
Quick overview of running SQL workloads in Azure
Migrating SQL Server workloads to Azure
Summary
Chapter 12: Taming Big Data with SQL Server
Big data overview
Accessing external data with PolyBase
Explaining the SQL Server Big Data Clusters architecture and deployment
Working with a SQL Server Big Data Clusters workload
Summary
Other Books You May Enjoy 更新時間：2021-06-11 18:11:38

官术网_书友最值得收藏!

SQL Server 2019 Administrator's Guide