Book description
- 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
Product information
- Title: Pro SQL Server 2019 Administration: A Guide for the Modern DBA
- Author(s):
- Release date: October 2019
- Publisher(s): Apress
- ISBN: 9781484250891
You might also like
book
Microsoft SQL Server 2014 Unleashed
The industry’s most complete, useful, and up-to-date guide to SQL Server 2014. You’ll find start-to-finish coverage …
book
Microsoft SQL Server 2019: A Beginner's Guide, Seventh Edition, 7th Edition
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, …
book
Professional SQL Server High Availability and Disaster Recovery
Leverage powerful features of the SQL Server and watch your infrastructure transform into a high-performing, reliable …
book
Professional Azure SQL Database Administration - Second Edition
Leverage the features of Azure SQL database and become an expert in data management Key Features …