Automating SQL Server 2000 with the SQL Server Agent, Jobs, Alerts and Scheduling

Member of the LearnItFirst.com Video Training Network	Related Video Training Sites: · SQL DTS Training Videos · SQL Programming Videos

SQL Server 2000 Training Videos							* SQL DTS Training Videos * SQL Programming Videos * More Videobooks...	Search My Account More Videobooks Sign in
Home FREE Video Tutorials Subscriber Video Tutorials Subscriptions FAQs Our Other Sites About Us

Home
- Free Videos
- Subscriber Videos
- Buy Now (Subscriptions)
- More Video Websites
- Search for Videos
- Tag Cloud

Subscriptions
- Subscribe!
- Testimonials
- List of Videobooks

Quick Links
- About the Author
- Login
- FAQs

Site Map

An Overview of the Fixed Server Roles for SQL Server 2000

Creating SQL Server Authentication Logins in the Enterprise Manag...

Creating Windows Authentication Logins in the Enterprise Manager

How to Increase a Database's Size - Multiple Techniques for Incre...

How to Increase a Database's Size Using the SQL Server Enterprise...

SQL Server 2000 Videos By Category	Home Subscriber Videos

Automating SQL Server 2000 with the SQL Server Agent, Jobs, Alerts and Scheduling - Video Category (all video categories)

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

Versions/Editions Covered: SQL Server 2000

Videos in this Category:

orange = video series
blue = individual video

Click "Download" to download the video or click the video title for more information

Title	Skill	View / Download	Length
Alerts in SQL Server 2000 - What They Are, How to Use Them and Best Practices	300	Download	21 mins.
How SQL Server Logs Errors - The SQL Server Error Log and Configuration	300	Download	7 mins.

< Return to list of all videos

Related Links:

Microsoft SQL Server 2000 Performance Optimization and Tuning Handbook - Ken England gives a great treatise on execution plans, query tuning and index design in this SQL Server standard

Ken Henderson's "The Guru's Guide to Transact SQL" - You just can't find a better book on SQL Server. This was book could've been written in 1979 but it wouldn't matter; even when SQL Server 2010 (or whatever) comes out, it will still be relevant. A classic!

Microsoft SQL Server 2000 Bible - Paul Nielsen is a SQL guru - there's no question. This book is a huge tome of great SQL info and comes highly recommended for newbies and intermediate-level DBAs and developers

Miscellaneous Bits & Pieces:

nslookup is a great command-line tool to diagnose DNS issues

Most SQL Server adminstrators prefer to change the port of a default instance from 1433 to something unused. This prevents hackers and malicious software from connecting to port 1433 and locating a SQL Server. Bottom line: everyone knows that the default SQL Server port is 1433 so, to create a secure server, change the port number

Helpful Keyboard Shortcuts: "Windows key" + "D" shows the desktop

Company News

» We're also sponsoring the St Louis SQL Server User Group July 9

» We're sponsoring the Billings, Montana .NET User Group July 8

» We're sponsoring the San Antonio, TX Alamo Coders User Group June 10th

» Scott had a baby!


Home \| About Us \| Advertising \| Become an Author \| Contact Us \| Privacy \| System Req's \| Terms \| Testimonials \| Work for Us! \| \| 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.

7/3/2008 6:26:39 PM