Managing SQL Server Database Maintenance

Focused View

Viktor Suha

1:39:18

50 View

01.Course Overview

01.01.Course Overview.mp4

02:26

02.Planning SQL Server Backups

02.01.The Role of Database Backups.mp4

03:21

02.02.Case Studies from the Field - Part 1.mp4

02:49

02.03.Case Studies from the Field - Part 2.mp4

03:50

02.04.Backup Types and Recovery Models.mp4

03:30

02.06.How to Restore Backups - Point-in-time Recovery.mp4

03:19

02.07.Backup Retentions and Tools.mp4

03:18

02.08.Demo Using the Ola Hallengren Backup Solution.mp4

05:39

02.09.SQL Server Backups in Azure.mp4

01:03

02.10.Demo Working with SQL Server Backups in Azure.mp4

04:16

02.11.Module Summary.mp4

02:25

03.Planning SQL Server Index Maintenance

03.01.The Role of Index Maintenance.mp4

01:18

03.02.Indexes in SQL Server.mp4

03:46

03.03.Index Fragmentation and Out-of-date Statistics Problems.mp4

02:50

03.04.Case Studies from the Field.mp4

02:53

03.05.Index Rebuild, Reorganize, and Statistics Update.mp4

02:15

03.06.Optimizing Index Maintenance.mp4

04:02

03.07.Index Maintenance Tools.mp4

01:23

03.08.Demo Using the Ola Hallengren Index Maintenance Solution.mp4

09:56

03.09.Index Maintenance in Azure.mp4

01:59

03.10.Module Summary.mp4

02:03

04.Planning SQL Server Database Consistency Checks

04.01.The Role of Database Integrity Checks.mp4

01:14

04.02.Database Corruptions, Reasons, and Symptoms.mp4

05:15

04.03.Preventing Database Corruptions.mp4

01:31

04.04.Case Studies from the Field.mp4

02:09

04.05.Addressing Corrupted Databases.mp4

03:37

04.06.Using DBCC CHECKDB.mp4

03:17

04.07.Demo Using the Ola Hallengren Integrity Check Solution.mp4

08:04

04.08.Database Integrity Check in Azure.mp4

01:49

04.09.Module Summary.mp4

02:47

04.10.Course Summary.mp4

01:14

Description

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.

What You'll Learn?

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

SQL Server

Microsoft SQL

Viktor Suha

Instructor's Courses

Viktor has been working with the Microsoft data platform, including the core SQL Server database engine, Reporting Services, and Integration Services for many years now. He has worked at Microsoft Premier Support for 10 years, supporting these technologies for large enterprise customers. He also gained some SharePoint infrastructure experience. Since his Microsoft years, he has been working both as a SQL Server database developer and a DBA, thus having experience in both worlds mainly in large enterprise environments. Viktor owns several MCP certifications, MCSA certification for SQL Server and he recently completed the Microsoft Professional Program for Data Science with a certificate to gain insights into machine learning and data science in general. He is keen to learn new technologies continuously and believes in ongoing personal development. His main professional interests are database technologies and trends including NoSQL platforms, but also BI solutions, MS Power BI, and MS Azure.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.