SQL Server 2016 – Maintenance and Automation

Microsoft SQL Server 2016 is considered the largest leap in the data platform in the history of Microsoft, in the ongoing era of Big Data and Data Science. Compared to its predecessors, SQL Server 2016 offers developers a unique opportunity to leverage advanced features and build applications that are robust, scalable and easy to administer.

In this video tutorial, you will begin with the diving into the backup and recovery of your database. Here, you will learn to develop a backup strategy and carry out full database backups as well as differential database backups. You will explore the different options for restoring your system logs, and how to restore your database to a specific point in time. From there, you will move to Automating your Server. You will learn to create tasks and jobs for your system, and also set up operations and notifications. You will also learn to configure alerts and database emails for sending messages to users. After that, you will dive right into the High Availability and Disaster Recovery, where you will be database mirroring, log shipping, and availability groups. Finally,

By the end of this video tutorial, you will be well versed with automating and maintaining your own database using SQL Server.