Member of the LearnItFirst.com Video Training Network Related Video Training Sites: · SSIS Training Videos · SQL Programming Tutorials
     
SQL Server Training Videos             * SSIS Training Videos
* SQL Programming Tutorials
* More Videobooks...
Email
Password
Register
LearnSqlServer.com Subscriber Videos
SQL Server DBA Videos By Category Home  Subscriber Videos  
Automating SQL Server: SQL Server Agent, Jobs, Email, Alerts and Scheduling - Video Category (all video categories)
Video Image SQL Servers around the world run jobs at scheduled times - it's just the way of the world. This video category will teach you how to create jobs, how to manage alerts, and how the SQL Server Agent works. This is an important set of videos for any SQL Server DBA.

This set of videos teaches you about:
  • Scheduling Backups and SQL Server Jobs
  • Database Mail, SQLMail, and Operators
  • Alerts for Proactive Administration
  • SQL Server Agent Internals
and much more

Versions/Editions Covered: SQL Server 2005
Videos in this Category: orange = video series 
blue = individual video 
Click "Download" to download the video or click the video title for more information
TitleSkillView / DownloadLength
Series (4 videos) - Maintenance Plans in SQL Server 2005   100 (Click for Videos) 47 mins.
Series (6 videos) - Automation Via Stored Procedures: Backup, Copy, and Restore   New! 300 (Click for Videos) 73 mins.
Series (6 videos) - How to Use Alerts in SQL Server 2005   300 (Click for Videos) 68 mins.
SQL DBA 101: How to Quickly Schedule a Backup Job   200 Download 7 mins.
Over 3 hours of SQL Server tutorials in this category
< Return to list of all videos
Miscellaneous Bits & Pieces:
Keyboard Shortcut for Query Analyzer: F8 brings up the always-useful Object Explorer
Performance Tip: Deadlocks are the bane of SQL programmers but can often be avoided by savvy programming. One technique you can use to minimize deadlocks is to use SET DEADLOCK_PRIORITY LOW for one transaction. When a deadlock is encountered SQL Server will rollback this transaction and allow the other transaction to finish it's work
Did you know that the database role "ddladmin" can TRUNCATE the table (delete all rows) but not SELECT?
Video search
Company News
Exchange 2007/2003 Training Videos
     
Home | About Us | Advertising | Become an Author | Contact Us | Privacy | System Req's | Terms | Testimonials | Work for Us! | Blogs | Site Map Refer a Friend and Get a Free Subscription!
© 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.
7/23/2008 10:23:00 PM