MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

SQL Server: Maintenance Plans

Course Summary

Proper database maintenance is critical for making sure that database workloads perform as well as possible. One of the simplest ways to implement database maintenance is to use the built-in Maintenance Plan functionality to schedule the critical database

  • +

    Course Syllabus

    ● Introduction
        ◦ Introduction
        ◦ Course Expectations
        ◦ Course Structure
    ● Approaches to Database Maintenance
        ◦ Introduction
        ◦ Core Maintenance Tasks
        ◦ Database Maintenance Plans
        ◦ SSIS Packages
        ◦ Custom Transact-SQL Scripts
        ◦ PowerShell Scripts
        ◦ Summary
    ● Configuring SQL Server Agent Settings
        ◦ Introduction
        ◦ Configuring Database Mail
        ◦ Demo: Configuring Database Mail
        ◦ Demo: Viewing/Modifying Database Mail Settings
        ◦ Configuring SQL Server Agent Mail Settings
        ◦ Demo: SQL Server Agent Mail Settings
        ◦ Configuring SQL Server Agent History Retention
        ◦ Demo: Configuring SQL Server Agent History Retention
        ◦ Demo: Managing Retention History with a Job
        ◦ Creating SQL Server Agent Alerts
        ◦ Demo: Creating SQL Server Agent Alerts
        ◦ Summary
    ● Common Maintenance Tasks
        ◦ Introduction
        ◦ Maintenance Plan Considerations
        ◦ Back Up Database Task (Full)
        ◦ Back Up Database Task (Transaction Log)
        ◦ Back Up Database Task (Differential)
        ◦ Demo: Back Up Database Task Configuration
        ◦ Check Database Integrity Task
        ◦ DBCC CHECKDB Options
        ◦ Dealing with Corruption
        ◦ Demo: Check Database Integrity Task
        ◦ Rebuild Index Task
        ◦ Rebuild Index Task (2)
        ◦ Demo: Rebuild Index Task
        ◦ Reorganize Index Task
        ◦ Demo: Reorganize Index Task
        ◦ Update Statistics Task
        ◦ Demo: Update Statistics Task
        ◦ History Cleanup Task
        ◦ Demo: History Cleanup Task
        ◦ Maintenance Cleanup Task
        ◦ Demo: Maintenance Cleanup Task
        ◦ Summary
    ● Other Tasks
        ◦ Introduction
        ◦ Shrink Database Task
        ◦ Demo: Shrink Database Task
        ◦ Execute SQL Server Agent Job Task
        ◦ Demo: Execute SQL Server Agent Job Task
        ◦ Execute T-SQL Statement Task
        ◦ Demo: Execute T-SQL Statement Task
        ◦ Notify Operator Task
        ◦ Demo: Notify Operator Task
        ◦ Summary
    ● Creating Maintenance Plans
        ◦ Introduction
        ◦ Maintenance Plan Wizard Introduction
        ◦ Demo: Maintenance Plan Wizard
        ◦ Maintenance Plan Designer Introduction
        ◦ Demo: Maintenance Plan Designer
        ◦ SQL Server Integration Services Packages
        ◦ Demo: SSIS Packages
        ◦ Options to Simplify Maintenance Plan Reuse
        ◦ Summary
    ● Maintenance Plan Challenges and Alternatives
        ◦ Introduction
        ◦ Index Maintenance Limitations
        ◦ Fragmentation-Based Analysis
        ◦ Michelle Ufford's Reindexing Script
        ◦ Demo: Michelle Uffords Reindex Script
        ◦ Ola Hallengren's Maintenance Scripts
        ◦ Ola Hallengren's Maintenance Scripts (2)
        ◦ Demo: Ola Hallengren's Scripts
        ◦ Summary


Course Fee:
USD 29

Course Type:


Course Status:



1 - 4 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top