Managing SQL Server Database Maintenance

Database backups, index maintenance, and integrity checks are crucial tasks in any SQL Server environment. This course covers what database maintenance is, why it is necessary, why you should plan it, and how you can optimize it.
Course info
Level
Beginner
Updated
Dec 30, 2019
Duration
1h 42m
Table of contents
Description
Course info
Level
Beginner
Updated
Dec 30, 2019
Duration
1h 42m
Description

Your SQL Server environment should have backups, index maintenance, and database integrity checks implemented and scheduled to run regularly. If these are missing or not carefully planned, it can cause problems at many levels. In this course, Managing SQL Server Database Maintenance, you will gain the ability to understand the importance of these tasks and implement them with the Ola Hallengren scripted maintenance solution. First, you will learn about SQL Server backups, what the main backup types are, why planning backups is important, and how you can restore these backups in case of a disaster, both on-premises and in Azure. Next, you will discover the three main pillars of index maintenance: index rebuild, index reorganize, and statistics update, along with how you can optimize these tasks. Finally, you will explore how to address database corruptions in SQL Server, detect corruptions, and lower the impact of regular integrity checks in your production environment. When you are finished with this course, you will have the skills and knowledge of SQL Server database maintenance needed to keep your data safe in case of a disaster, optimize workload performance, and ensure data integrity.

About the author
About the author

Viktor is a SQL Server database developer and DBA having major experience with large enterprise environments and customers. He mainly worked in the financial industry and also at Microsoft in the Premier Support organization for 10 years

More from the author
Managing SQL Server Database Performance
Intermediate
2h 51m
Jul 30, 2019
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hi everyone. My name is Viktor Suha, and welcome to my course, Managing SQL Server Database Maintenance. I am currently a database developer and DBA at GSGroup. Have you seen SQL Server environments where database backups were simply missing or the existing backups could not be restored, causing data loss for the customer? Have you had troubles implementing index maintenance to resolve query performance problems? How would you manage a database corruption that can occur at any time? In this course, we are going to explore what database maintenance is, why planning it is important, what tools you can use to implement and optimize it. Some of the major topics that we'll cover include the importance of database backups, index maintenance, and integrity checks; understanding backup types, recovery models, and restoring backups; implementing and optimizing an index rebuild, reorganize, and statistics update; detecting and managing database corruptions. By the end of this course, you'll know why database maintenance is important, why you should plan it, and how to implement and optimize the various maintenance tasks, both with your on‑premises SQL Server and with Azure SQL Database. Before beginning the course, you should be familiar with using SQL Server Management Studio to be able to run queries against any version of SQL Server. From here, you should feel comfortable diving into database maintenance and indexing with courses on SQL Server indexing and index fragmentation internals, automatic tuning in Azure SQL Database, SQL Server maintenance plans. I hope you'll join me on this journey to learn about database maintenance with the Managing SQL Server Database Maintenance course, at Pluralsight.