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
Rating
(17)
Level
Beginner
Updated
Dec 30, 2019
Duration
1h 43m
Table of contents
Description
Course info
Rating
(17)
Level
Beginner
Updated
Dec 30, 2019
Duration
1h 43m
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
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
[Autogenerated] Hi, everyone. My name is Victor. Sure, and we'll come to my course managing secret server database maintenance. I am currently a date of his developer and D B A. G s group. Have you seen secrets of environments where database backups were simply missing or the existing backups could not be restored, causing data loss for the customer? Heavy had troubles implementing index maintenance to resolve Cleary performance problems. How would you manage a date of his corruption that can occur at any time? In this course, we are going to explore what take a base. Maintenance is why planning it is important what tools you can use to implement and optimize it. Some of the major topics that we recover include the importance of database backups, index maintenance and integrity checks, understanding backup types, recovery models and restoring backups. Implementing and optimizing index, rebuild, reorganized and statistics update detecting and managing database corruptions. By the end of this course, you know why database maintenance is important, why you should plan it and how to implement and optimize the various maintenance tasks both video on premises, secret server and with azure secret database. Before beginning the course, you should be familiar with using Secret Server Management studio to be able to run queries against any version off secret server. From here, you should feel comfortable diving into database maintenance and indexing with courses on secrets ever indexing and index fragmentation internals automatic tuning in Asia Sequel databases. Secrets of a Maintenance plans. I hope you'll join me on this journey to learn about database maintenance with the managing secrets of a database maintenance course at Plural Side.