SQL Server Maintenance Plans

Shaun Stuart

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
38 Videos (1h 51m)
    • Instructor Details

      0:38
    • Course Overview

      0:45
    • Database Maintenance Methodologies: Introduction

      0:28
    • Database Maintenance Methodologies: Why Perform Maintenance & Core Maintenance Tasks

      0:57
    • Database Maintenance Methodologies: Maintenance Plans

      0:45
    • Database Maintenance Methodologies: T-SQL Scripts

      0:49
    • Database Maintenance Methodologies: PowerShell Scripts

      0:47
    • Database Maintenance Methodologies: Summary

      0:36
    • Configuring SQL Server Agent: Introduction

      0:42
    • Configuring SQL Server Agent: Configuring Database Mail

      9:42
    • Configuring SQL Server Agent: Configuring SQL Server Agent To Use Database Mail

      1:30
    • Configuring SQL Server Agent: Configuring Operators And Alerts

      5:06
    • Configuring SQL Server Agent: Demo of SQL Event Alert

      4:48
    • Configuring SQL Server Agent: Demo Of SQL Performance Alert

      2:10
    • Configuring SQL Server Agent: Configuring SQL Agent History Retention

      2:31
    • Configuring SQL Server Agent: Summary

      0:40
    • Basic Maintenance Plans Tasks: Introduction

      0:52
    • Basic Maintenance Plans Tasks: Back Up Database Task - Full Backup

      9:05
    • Basic Maintenance Plans Tasks: Back Up Database Task - Differential Backup

      2:09
    • Basic Maintenance Plans Tasks: Back Up Database Task - Transaction Log Backup

      3:06
    • Basic Maintenance Plans Tasks: Check Database Integrity Task

      2:20
    • Basic Maintenance Plans Tasks: Rebuild Index Task

      5:49
    • Basic Maintenance Plans Tasks: Reorganize Index Task

      2:00
    • Basic Maintenance Plans Tasks: Update Statistics Task

      3:30
    • Miscellaneous Maintenance Tasks: Introduction

      0:26
    • Miscellaneous Maintenance Tasks: Execut SQL Agent Job Task

      0:48
    • Miscellaneous Maintenance Tasks: Execut T-SQL Statement Task

      1:34
    • Miscellaneous Maintenance Tasks: History Cleanup Task

      2:26
    • Miscellaneous Maintenance Tasks: Maintenance Cleanup Task

      3:24
    • Miscellaneous Maintenance Tasks: Notify Operator Task

      1:31
    • Miscellaneous Maintenance Tasks: Shrink Database Task

      5:01
    • Putting It All Together: Introduction

      0:27
    • Putting It All Together: Database Maintenance Plan Wizard

      9:08
    • Putting It All Together: Database Maintenance Plan Designer

      13:15
    • Maintenance Plan Limitations And Alternatives: Introduction

      0:36
    • Maintenance Plan Limitations And Alternatives: Limitations Of Maintenance Plans

      2:55
    • Maintenance Plan Limitations And Alternatives: Maintenance Plan Alternatives

      6:27
    • Course Wrap Up: Summary

      0:56

About This Class

By the end of this course, you will be able to create maintenance plans to keep your SQL Server databases running at peak efficiency. You will be able to identify which maintenance operations are well-suited for maintenance plans and which are not. You will be able to identify when your environment has grown to the point where maintenance plans might no longer be the best maintenance option.

This course is intended for beginner to intermediate level database administrators or those who must support a SQL Server environment but have little to no experience with SQL Server.

1

Student

--

Projects

0

Reviews (0)

Hello, I'm Shaun.

See full profile

Technology SQL Server Data Science