2013
Pluralsight
Jonathan Kehayias
2h 39m
English
Learn how to properly configure and control essential SQL Server database maintenance using Maintenance Plans.
This course is applicable to anyone responsible for SQL Server databases, with any level of SQL Server experience.
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 maintenance tasks - backups, consistency checking, statistics maintenance and index maintenance.
The course starts by explaining how to configure Database Mail, and Operator, and alerts, all within SQL Server Agent.
It then describes all the commonly-required maintenance tasks and shows how to configure them, along with do's and don'ts, plus some of the less commonly used tasks.
After that it shows how to pull these tasks together into Maintenance Plans using the Maintenance Plan Wizard, the Maintenance Plan Designer, and through Integration Services packages.
Finally the course discusses some of the alternative methods of implementing database maintenance through freely-available scripts.
This course is perfect for anyone who is responsible for SQL Server databases, with any level of experience, from SQL Server 2005 onward.
FileName Size Length Bit rate Data rate Resolution Frame Rate Parent Folder
01.Introduction 1.97 MB 0:01:15 128kbps 135.00 1024x768 15 frames/second 01.Introduction
02.Course Expectations 2.27 MB 0:01:25 128kbps 191.00 1024x768 15 frames/second 01.Introduction
03.Course Structure 1.00 MB 0:00:42 128kbps 89.00 1024x768 15 frames/second 01.Introduction
01.Introduction 1.41 MB 0:00:55 128kbps 146.00 1024x768 15 frames/second 02.Approaches to Database Maintenance
02.Core Maintenance Tasks 4.42 MB 0:02:50 128kbps 210.00 1024x768 15 frames/second 02.Approaches to Database Maintenance
03.Database Maintenance Plans 3.28 MB 0:02:10 128kbps 169.00 1024x768 15 frames/second 02.Approaches to Database Maintenance
04.SSIS Packages 3.43 MB 0:02:19 128kbps 192.00 1024x768 15 frames/second 02.Approaches to Database Maintenance
05.Custom Transact-SQL Scripts 3.83 MB 0:02:33 128kbps 184.00 1024x768 15 frames/second 02.Approaches to Database Maintenance
06.PowerShell Scripts 2.05 MB 0:01:26 128kbps 99.00 1024x768 15 frames/second 02.Approaches to Database Maintenance
07.Summary 1.24 MB 0:00:50 128kbps 119.00 1024x768 15 frames/second 02.Approaches to Database Maintenance
01.Introduction 2.28 MB 0:01:28 128kbps 149.00 1024x768 15 frames/second 03.Configuring SQL Server Agent Settings
02.Configuring Database Mail 1.96 MB 0:01:20 128kbps 150.00 1024x768 15 frames/second 03.Configuring SQL Server Agent Settings
03.Demo - Configuring Database Mail 10.9 MB 0:06:18 128kbps 352.00 1024x768 15 frames/second 03.Configuring SQL Server Agent Settings
04.Demo - Viewing-Modifying Database Mail Settings 2.51 MB 0:01:30 128kbps 219.00 1024x768 15 frames/second 03.Configuring SQL Server Agent Settings
05.Configuring SQL Server Agent Mail Settings 2.63 MB 0:01:42 128kbps 209.00 1024x768 15 frames/second 03.Configuring SQL Server Agent Settings
06.Demo - SQL Server Agent Mail Settings 5.06 MB 0:03:15 128kbps 189.00 1024x768 15 frames/second 03.Configuring SQL Server Agent Settings
07.Configuring SQL Server Agent History Retention 2.81 MB 0:01:53 128kbps 172.00 1024x768 15 frames/second 03.Configuring SQL Server Agent Settings
08.Demo - Configuring SQL Server Agent History Retention 2.91 MB 0:01:50 128kbps 179.00 1024x768 15 frames/second 03.Configuring SQL Server Agent Settings
09.Demo - Managing Retention History with a Job 5.33 MB 0:03:19 128kbps 186.00 1024x768 15 frames/second 03.Configuring SQL Server Agent Settings
10.Creating SQL Server Agent Alerts 2.05 MB 0:01:24 128kbps 109.00 1024x768 15 frames/second 03.Configuring SQL Server Agent Settings
11.Demo - Creating SQL Server Agent Alerts 4.65 MB 0:02:36 128kbps 268.00 1024x768 15 frames/second 03.Configuring SQL Server Agent Settings
12.Summary 2.02 MB 0:01:22 128kbps 144.00 1024x768 15 frames/second 03.Configuring SQL Server Agent Settings
01.Introduction 1.65 MB 0:01:05 128kbps 127.00 1024x768 15 frames/second 04.Common Maintenance Tasks
02.Maintenance Plan Considerations 3.97 MB 0:02:44 128kbps 152.00 1024x768 15 frames/second 04.Common Maintenance Tasks
03.Back Up Database Task (Full) 3.18 MB 0:02:11 128kbps 160.00 1024x768 15 frames/second 04.Common Maintenance Tasks
04.Back Up Database Task (Transaction Log) 3.66 MB 0:02:25 128kbps 215.00 1024x768 15 frames/second 04.Common Maintenance Tasks
05.Back Up Database Task (Differential) 3.28 MB 0:02:09 128kbps 174.00 1024x768 15 frames/second 04.Common Maintenance Tasks
06.Demo - Back Up Database Task Configuration 5.63 MB 0:03:32 128kbps 161.00 1024x768 15 frames/second 04.Common Maintenance Tasks
07.Check Database Integrity Task 2.24 MB 0:01:28 128kbps 191.00 1024x768 15 frames/second 04.Common Maintenance Tasks
08.DBCC CHECKDB Options 3.87 MB 0:02:23 128kbps 246.00 1024x768 15 frames/second 04.Common Maintenance Tasks
09.Dealing with Corruption 2.96 MB 0:01:55 128kbps 215.00 1024x768 15 frames/second 04.Common Maintenance Tasks
10.Demo - Check Database Integrity Task 2.42 MB 0:01:29 128kbps 148.00 1024x768 15 frames/second 04.Common Maintenance Tasks
11.Rebuild Index Task 3.24 MB 0:02:10 128kbps 158.00 1024x768 15 frames/second 04.Common Maintenance Tasks
12.Rebuild Index Task (2) 3.22 MB 0:02:06 128kbps 194.00 1024x768 15 frames/second 04.Common Maintenance Tasks
13.Demo - Rebuild Index Task 5.01 MB 0:03:04 128kbps 160.00 1024x768 15 frames/second 04.Common Maintenance Tasks
14.Reorganize Index Task 2.80 MB 0:01:55 128kbps 149.00 1024x768 15 frames/second 04.Common Maintenance Tasks
15.Demo - Reorganize Index Task 3.02 MB 0:01:48 128kbps 147.00 1024x768 15 frames/second 04.Common Maintenance Tasks
16.Update Statistics Task 4.47 MB 0:02:51 128kbps 206.00 1024x768 15 frames/second 04.Common Maintenance Tasks
17.Demo - Update Statistics Task 3.01 MB 0:01:56 128kbps 144.00 1024x768 15 frames/second 04.Common Maintenance Tasks
18.History Cleanup Task 2.21 MB 0:01:31 128kbps 137.00 1024x768 15 frames/second 04.Common Maintenance Tasks
19.Demo - History Cleanup Task 3.36 MB 0:02:07 128kbps 135.00 1024x768 15 frames/second 04.Common Maintenance Tasks
20.Maintenance Cleanup Task 1.90 MB 0:01:19 128kbps 122.00 1024x768 15 frames/second 04.Common Maintenance Tasks
21.Demo - Maintenance Cleanup Task 5.08 MB 0:03:20 128kbps 138.00 1024x768 15 frames/second 04.Common Maintenance Tasks
22.Summary 2.08 MB 0:01:23 128kbps 165.00 1024x768 15 frames/second 04.Common Maintenance Tasks
01.Introduction 1.66 MB 0:01:05 128kbps 120.00 1024x768 15 frames/second 05.Other Tasks
02.Shrink Database Task 4.03 MB 0:02:39 128kbps 195.00 1024x768 15 frames/second 05.Other Tasks
03.Demo - Shrink Database Task 3.94 MB 0:02:35 128kbps 137.00 1024x768 15 frames/second 05.Other Tasks
04.Execute SQL Server Agent Job Task 2.09 MB 0:01:29 128kbps 113.00 1024x768 15 frames/second 05.Other Tasks
05.Demo - Execute SQL Server Agent Job Task 2.71 MB 0:01:44 128kbps 143.00 1024x768 15 frames/second 05.Other Tasks
06.Execute T-SQL Statement Task 1.84 MB 0:01:16 128kbps 171.00 1024x768 15 frames/second 05.Other Tasks
07.Demo - Execute T-SQL Statement Task 2.08 MB 0:01:21 128kbps 138.00 1024x768 15 frames/second 05.Other Tasks
08.Notify Operator Task 2.25 MB 0:01:30 128kbps 167.00 1024x768 15 frames/second 05.Other Tasks
09.Demo - Notify Operator Task 3.09 MB 0:02:04 128kbps 131.00 1024x768 15 frames/second 05.Other Tasks
10.Summary 1.37 MB 0:00:58 128kbps 113.00 1024x768 15 frames/second 05.Other Tasks
01.Introduction 2.83 MB 0:01:47 128kbps 192.00 1024x768 15 frames/second 06.Creating Maintenance Plans
02.Maintenance Plan Wizard Introduction 3.50 MB 0:02:13 128kbps 229.00 1024x768 15 frames/second 06.Creating Maintenance Plans
03.Demo - Maintenance Plan Wizard 11.9 MB 0:06:31 128kbps 311.00 1024x768 15 frames/second 06.Creating Maintenance Plans
04.Maintenance Plan Designer Introduction 3.16 MB 0:02:00 128kbps 218.00 1024x768 15 frames/second 06.Creating Maintenance Plans
05.Demo - Maintenance Plan Designer 12.8 MB 0:06:43 128kbps 268.00 1024x768 15 frames/second 06.Creating Maintenance Plans
06.SQL Server Integration Services Packages 1.93 MB 0:01:18 128kbps 143.00 1024x768 15 frames/second 06.Creating Maintenance Plans
07.Demo - SSIS Packages 10.9 MB 0:05:53 128kbps 280.00 1024x768 15 frames/second 06.Creating Maintenance Plans
08.Options to Simplify Maintenance Plan Reuse 3.88 MB 0:02:27 128kbps 205.00 1024x768 15 frames/second 06.Creating Maintenance Plans
09.Summary 2.90 MB 0:01:55 128kbps 159.00 1024x768 15 frames/second 06.Creating Maintenance Plans
01.Introduction 1.72 MB 0:01:05 128kbps 151.00 1024x768 15 frames/second 07.Maintenance Plan Challenges and Alternatives
02.Index Maintenance Limitations 2.27 MB 0:01:28 128kbps 164.00 1024x768 15 frames/second 07.Maintenance Plan Challenges and Alternatives
03.Fragmentation-Based Analysis 2.19 MB 0:01:20 128kbps 216.00 1024x768 15 frames/second 07.Maintenance Plan Challenges and Alternatives
04.Michelle Ufford's Reindexing Script 3.48 MB 0:02:12 128kbps 214.00 1024x768 15 frames/second 07.Maintenance Plan Challenges and Alternatives
05.Demo - Michelle Uffords Reindex Script 25.2 MB 0:05:30 128kbps 3618.00 1024x768 15 frames/second 07.Maintenance Plan Challenges and Alternatives
06.Ola Hallengren's Maintenance Scripts 2.36 MB 0:01:36 128kbps 181.00 1024x768 15 frames/second 07.Maintenance Plan Challenges and Alternatives
07.Ola Hallengren's Maintenance Scripts (2) 2.59 MB 0:01:40 128kbps 169.00 1024x768 15 frames/second 07.Maintenance Plan Challenges and Alternatives
08.Demo - Ola Hallengren's Scripts 17.3 MB 0:05:04 128kbps 1526.00 1024x768 15 frames/second 07.Maintenance Plan Challenges and Alternatives
09.Summary 1.05 MB 0:00:40 128kbps 116.00 1024x768 15 frames/second 07.Maintenance Plan Challenges and Alternatives
Download File Size:230.58 MB
|
