Book description
Conquer SQL Server 2019 administration–from the inside out
Dive into SQL Server 2019 administration–and really put your SQL Server DBA expertise to work. This supremely organized reference packs hundreds of timesaving solutions, tips, and workarounds–all you need to plan, implement, manage, and secure SQL Server 2019 in any production environment: on-premises, cloud, or hybrid. Six experts thoroughly tour DBA capabilities available in SQL Server 2019 Database Engine, SQL Server Data Tools, SQL Server Management Studio, PowerShell, and Azure Portal. You’ll find extensive new coverage
of Azure SQL, big data clusters, PolyBase, data protection, automation, and more. Discover how experts tackle today’s essential tasks–and challenge yourself to new levels of mastery.
Explore SQL Server 2019’s toolset, including the improved SQL Server Management Studio, Azure Data Studio, and Configuration Manager
Design, implement, manage, and govern on-premises, hybrid, or Azure database infrastructures
Install and configure SQL Server on Windows and Linux
Master modern maintenance and monitoring with extended events, Resource Governor, and the SQL Assessment API
Automate tasks with maintenance plans, PowerShell, Policy-Based Management, and more
Plan and manage data recovery, including hybrid backup/restore, Azure SQL Database recovery, and geo-replication
Use availability groups for high availability and disaster recovery
Protect data with Transparent Data Encryption, Always Encrypted, new Certificate Management capabilities, and other advances
Optimize databases with SQL Server 2019’s advanced performance and indexing features
Provision and operate Azure SQL Database and its managed instances
Move SQL Server workloads to Azure: planning, testing, migration, and post-migration
Table of contents
- Cover
- Title Page
- Copyright Page
- Dedication Page
- Contents at a Glance
- Table of Contents
- About the authors
- Introduction
- Part I. Introduction
- Part II. Deployment
-
Part III. SQL Server management
-
Chapter 8. Maintaining and monitoring SQL Server
- Detecting, preventing, and responding to database corruption
- Maintaining indexes and statistics
- Managing database file sizes
- Monitoring activity by using DMOs
- Monitoring with the SQL Assessment API
- Utilizing extended events
- Capturing performance metrics with DMOs and Data Collectors
- Protecting important workloads by using Resource Governor
- Understanding the new servicing model
- Chapter 9. Automating SQL Server administration
- Chapter 10. Developing, deploying, and managing data recovery
- Chapter 11. Implementing high availability and disaster recovery
-
Chapter 8. Maintaining and monitoring SQL Server
- Part IV. Security
- Part V. Performance
-
Part VI. Cloud
- Chapter 16. Designing and implementing hybrid and Azure database infrastructure
- Chapter 17. Provisioning Azure SQL Database
-
Chapter 18. Provisioning Azure SQL Database managed instance
- What is a Managed Instance?
- Creating a managed instance
- Establishing a connection
- Migrating data to Managed Instance
- Deleting a Managed Instance
- Network requirements for Managed Instances
- Managed Instance administration features
- Azure SQL Analytics
- Security of Managed Instance
- Data protection features
- Chapter 19. Migrating to SQL Server solutions in Azure
- Part VII. Big Data and Machine Learning
- Index
- Code Snippets
Product information
- Title: SQL Server 2019 Administration Inside Out
- Author(s):
- Release date: March 2020
- Publisher(s): Microsoft Press
- ISBN: 9780135561034
You might also like
book
SQL Server 2022 Administration Inside Out
Conquer SQL Server 2022 and Azure SQL administration from the inside out! Dive into SQL Server …
book
SQL Server 2019 Administrator's Guide - Second Edition
Use Microsoft SQL Server 2019 to implement, administer, and secure a robust database solution that is …
book
Pro SQL Server 2019 Administration: A Guide for the Modern DBA
Use this comprehensive guide for the SQL Server DBA, covering all that practicing database administrators need …
video
SQL Server 2016 Fundamentals for the Accidental DBA LiveLessons
6+ Hours of Video Instruction Help non-DBAs learn the critical skills they need to manage SQL …