Member of the LearnItFirst.com Video Training Network Related Video Training Sites: · SSIS Training Videos · SQL Programming Tutorials
   
SQL Server Training Videos
SQL Server DBA Videos in Series Home  Subscriber Videos  

How to Use Alerts in SQL Server 2005 (Video Series)

Video Image 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:


Miscellaneous Bits & Pieces:
You can use the table hint "WITH (NOLOCK)" to minimize the locks you place on resources during a SELECT statement - SELECT * FROM MyTable WITH (NOLOCK) places no "Shared" locks on MyTable
Book You Should Probably Own: Kalen Delaney's "Inside SQL Server 2005"
Security Tip: The "sa" account is probably best left unused in most organizations. Instead of using the "sa" account assign your Windows login to the "sysadmin" server role and use Windows Authentication to connect.

Other Websites We Offer
LearnVBProgramming.com
Don't Forget!
Become a Guru
 
   
 
About Us Video Playback Subscriptions More Video Training More
 
© 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. Refer a Friend and Get a Free Subscription!
 
8/28/2008 3:06:38 AM