Managing SQL Server Database Maintenance

Managing SQL Server Database Maintenance
Managing SQL Server Database Maintenance
English | MP4 | AVC 1280×720 | AAC 44KHz 2ch | 1h 42m | 218 MB

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.

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.

Table of Contents

Course Overview
1 Course Overview

Planning SQL Server Backups
2 The Role of Database Backups
3 Case Studies from the Field – Part 1
4 Case Studies from the Field – Part 2
5 Backup Types and Recovery Models
6 How to Restore Backups – Point-in-time Recovery
7 Backup Retentions and Tools
8 Demo Using the Ola Hallengren Backup Solution
9 SQL Server Backups in Azure
10 Demo Working with SQL Server Backups in Azure
11 Module Summary

Planning SQL Server Index Maintenance
12 The Role of Index Maintenance
13 Indexes in SQL Server
14 Index Fragmentation and Out-of-date Statistics Problems
15 Case Studies from the Field
16 Index Rebuild, Reorganize, and Statistics Update
17 Optimizing Index Maintenance
18 Index Maintenance Tools
19 Demo Using the Ola Hallengren Index Maintenance Solution
20 Index Maintenance in Azure
21 Module Summary

Planning SQL Server Database Consistency Checks
22 The Role of Database Integrity Checks
23 Database Corruptions, Reasons, and Symptoms
24 Preventing Database Corruptions
25 Case Studies from the Field
26 Addressing Corrupted Databases
27 Using DBCC CHECKDB
28 Demo Using the Ola Hallengren Integrity Check Solution
29 Database Integrity Check in Azure
30 Module Summary
31 Course Summary