SQL Server Maintenance Plans
4.4 (15 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
192 students enrolled
Wishlisted Wishlist

Please confirm that you want to add SQL Server Maintenance Plans to your Wishlist.

Add to Wishlist

SQL Server Maintenance Plans

Learn how to use SQL Server maintenance plans to perform common maintenance tasks against your databases.
4.4 (15 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
192 students enrolled
Created by Shaun Stuart
Last updated 4/2014
English
Current price: $10 Original price: $40 Discount: 75% off
13 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
By the end of this course, you will be able to create maintenance plans to keep your SQL Server databases running at peak efficency
You will be able to idenify which maintenance operations are well-suited for maintenance plans and whch 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.
View Curriculum
Requirements
  • Basic knowledge of SQL Server Management Studio is helpful.
Description

This course will teach you all about SQL Server's maintenance plans and what they can (and can't) do. The course starts out briefly covering SQL Server Agent and Database Mail, two components of SQL Server that work in concert with Maintenance Plans. Next, you'll learn about every option available in maintenance plans and how to configure each option. You'll then see video demonstrations that will walk you through every step in the process of creating a maintenance plan using two different methods. And finally, you'll learn the limitations of maintenance plans and where to go next when your systems grow to the point of requiring a more complex maintenance solution. The course is taught using SQL Server 2012, but the content is applicable to SQL 2008 R2, SQL 2008, and SQL 2005. The entire course is over 1.5 hours.

Who is the target audience?
  • This course is intended for beginner to intermdiate level database administrators or those who must support a SQL Server environment but have little to no experience with SQL Server.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 38 Lectures Collapse All 38 Lectures 01:50:43
+
Introduction To The Course
2 Lectures 01:23
+
Database Maintenace Methodologies
6 Lectures 04:22
+
Configuring SQL Server Agent
8 Lectures 27:10
Introduction
00:42

Configuring Database Mail
09:42

Configuring SQL Server Agent To Use Database Mail
01:30

Configuring Operators And Alerts
05:06

Demo Of SQL Event Alert
04:48

Demo Of SQL Performance Alert
02:10

Configuring SQL Agent History Retention
02:32

Summary
00:40
+
Basic Maintenance Tasks
8 Lectures 28:51

Back Up Database Task - Full Backup
09:05

Back Up Database Task - Differential Backup
02:09

Back Up Database Task - Transaction Log Backup
03:06

Check Database Integrity Task
02:20


Reorganize Index Task
02:00

Update Statistics Task
03:30
+
Miscellaneous Maintenance Tasks
7 Lectures 15:12

Execute SQL Agent Job Task
00:48

Execute T-SQL Statement Task
01:35

History Cleanup Task
02:27

Maintenance Cleanup Task
03:24

Notify Operator Task
01:31

Shrink Database Task
05:01
+
Putting It All Together: Creating Maintenance Plans
3 Lectures 22:50
Introduction
00:27

Database Maintenance Plan Wizard
09:08

Database Maintenance Plan Designer
13:15
+
Maintenance Plan Limitations And Alternatives
3 Lectures 09:59
Introduction
00:36

Limitations Of Maintenance Plans
02:56

Maintenance Plan Alternatives
06:27
+
Course Wrap Up
1 Lecture 00:56
Summary
00:56
About the Instructor
Shaun Stuart
4.3 Average rating
96 Reviews
1,131 Students
4 Courses
Senior SQL Server Database Administrator And Author

Shaun J. Stuart is a Database Administrator with over 15 years experience with SQL Server. He holds the following Microsoft certifications: MCTS: SQL Server 2005, MCTS: SQL Server 2008, MCITP: Database Administrator 2008, and MCSA: SQL Server 2012. He is the senior Database Administrator at the largest credit union in Arizona and a co-author of the book Tribal SQL: New Voices In SQL Server, published by Red Gate. He holds a Bachelors degree in electrical engineering.