How to Use Alerts in SQL Server 2005 - Video Series Video Category: Automating SQL Server: SQL Server Agent, Jobs, Email, Alerts and Scheduling Skill Level: 300 (Intermediate) Versions/Editions Covered: SQL Server 2005 Alerts in SQL server are a very important piece for the administrator to understand; especially the DBAs who actively manage their server and want to be proactive with their management. Alerts allow you to define a response to an event or condition and in this introductory video tutorial your instructor Scott Whigham will divulge more on the world of alerts in SQL Server 2005.

Videos in this Series:

Title Skill Length Download Part 1 - How to Be a Proactive DBA: What Are Alerts?   200 12 mins. Download Part 2 - Using Event Alerts (Error Alerts) And RAISERROR for Custom Error Alerts   300 10 mins. Download Part 3 - How to Use Alerts with SQL Server System Error Messages and Events   300 10 mins. Download Part 4 - Performance Condition Alerts in SQL Server 2005   300 12 mins. Download Part 5 - Define a Performance Condition Alert to Keep Your Log From Filling Up   300 12 mins. Download Part 6 - SQL Server 2005 WMI Event Alerts: How to Write WQL for WMI   400 12 mins. Download

< Return to list of all videos

Miscellaneous Bits & Pieces:

SQL Server 2000 Resource Kit - More Helpful Tools: "Database Hammer" is a customizable tool for testing your database server with various loads Want to see what's going on in your log? Run DBCC log (<insert your database name here >) WITH TABLERESULTS Keyboard Shortcut for Query Analyzer: CTRL+SHIFT+C comments out the highlighted text while CTRL+SHIFT+R removes comments