Book

SQL Server 2019 Administrator's Guide

This book will give you all the information you need to become an expert database administrator and master the administrative aspects of SQL Server 2019. From setting up and configuring your SQL Server instance to fine-tuning your database, this extensive guide will teach you the nitty-gritty of SQL Server 2019 administration.

Offered byPackt Logo

Difficulty Level

Intermediate

Completion Time

17h24m

Language

English

About Book

Who Is This Book For?

This book is for database administrators, database developers, and anyone who wants to administer large and multiple databases single-handedly using Microsoft's SQL Server 2019. Basic awareness of database concepts and experience with previous SQL Server versions is required.

Book content

chapters 17h24m total length

Setting Up SQL Server 2019

Keeping Your SQL Server Environment Healthy

Implementing Backup and Recovery

Securing Your SQL Server

Working with Disaster Recovery Options

Indexing and Performance

Planning Migration and Upgrade

Automation - Using Tools to Manage and Monitor SQL Server 2019

Configuring Always On High Availability Features

In-Memory OLTP - Why and How to Use it

Combining SQL Server 2019 with Azure

Taming Big Data With SQL Server

Related Resources

Access Ready-to-Use Books for Free!

Get instant access to a library of pre-built books—free trial, no credit card required. Start training your team in minutes!

No credit card required