Member of the
LearnItFirst.com Video Training Network
Related Video Training Sites:
·
SSIS Training Videos
·
SQL Programming Tutorials
Create a free account
·
Sign In
SQL Server DBA Videos in Series
Home
Subscriber Videos
Maintenance Plans in SQL Server 2005 (Video Series)
Video Category:
Automating SQL Server: SQL Server Agent, Jobs, Email, Alerts and Scheduling
Skill Level:
100 (Beginner)
Versions/Editions Covered:
SQL Server 2005
This series shows you all the changes to Maintenance Plans and the Maintenance Plan Wizard in SQL Server 2005 including the new SSIS-based interface for modifying Maintenance Plans. Because Maintenance Plans have been so vastly improved in SQL Server 2005, even experienced administrators should consider reviewing this series of videos.
Videos in this Series:
Title
Skill
Length
Download
Pt. 1 - Introduction to SQL Server 2005 Maintenance Plans
200
12 mins.
Download
Pt. 2 - Index-Related Tasks in SQL Server 2005 (the Rebuild Index, Reorganize In...
200
18 mins.
Download
Pt. 3 - The Cleanup History, Execute SQL Server Agent job, and Back Up Database ...
200
12 mins.
Download
Pt. 4 - Modifying Maintenance Plans
200
5 mins.
Download
Miscellaneous Bits & Pieces:
SQL Server 2000 Service Pack 3 Additions/Changes: Error reporting built into SQL Server
Keyboard Shortcut for Query Analyzer: CTRL+N opens a new query window
Don't forget that calls to @@ERROR and @@ROWCOUNT change after each statement. Most programmers prefer to store these global variables in a local variable immediately for later processing
About Us
·
Corporate Philosophy
·
Advertise With Us
·
Become an Author
·
Contact Us
Video Playback
·
System Requirements
·
TSCC Codec
(to play videos)
·
Troubleshooting/Problems
Subscriptions
·
Pricing/Buy Now
·
Testimonials
·
Privacy
·
Terms of Service
More Video Training
·
SSIS Training Videos
·
SQL Programming Tutorials
·
All of Our Websites
More
·
FAQs
·
Search for videos
·
Site Map
© Copyright 2004-2008 LearnItFirst.com LLC. All rights reserved. All trademarks remain the property of their respective owners. This site is not affiliated in any way with the Microsoft Corporation.
9/7/2008 9:00:44 PM