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 Video Tutorial Home  Subscriber Videos  

SQL Server Tutorial: Pt. 3 - Testing the Event Notification and Viewing the Windows Application Event Log

   Chapter: Miscellaneous - Topics That Do Not Fit Anywhere Else!
Download! Skill Level: 500 (Advanced)
Duration: 14:00
Size: 11.6MB
Versions/Editions Covered: SQL Server 2005
Added/Updated: May 02, 2007
Staff Pick!
Download this video
This is the 3rd of five very excellent advanced videos detailing out specific information towards Service Brokers SQL Server. This video starts out with the necessary resolutions to common real life errors to previously written store procedure as well as the following
  • Basic overview of event and xml logs
  • Basic introductory overview for error 18456 Login Failed
  • Properly reading the SQL related events in the event log within the Windows Operating System
  • Introduction to proper utilization of the COUNT() statement
  • Possible Filter Addons for the previously written stored procedure
The final video in the series of three adds a phenomenal closure and addons to the stored procedures. Scott provides us with written and useful code that is sure to make your life easier whether you are trying to learn about writing TSQL or just would like to utilize the code for your own purposes. This video series is for the advanced SQL Server users.

NOTE: This video's description was written by one of our members, Wayne Leiser. Thanks, Wayne!
Tags for this video: application event log count () event notification service brokers  
< Back Download this video
AddThis Social Bookmark Button
People Who Downloaded this Video Also Downloaded:
TitleSkillDownload
Part 1 - An Overview of the Default SQL Server Installation 100 Download
Part 2 - My How Things Have Changed - A Video Walk-Through of Some of the New To... 200 Download
Pt. 1 - Introduction to Stored Procedure Concepts and Common Usage 200 Download
Creating Database Diagrams in SQL Server Management Studio 200 Download
Performance Tuning Query Tips That Everyone Should Know - Using DBCC and SET Com... 300 Download
This video is part of the following video series: "Event Notifications in SQL Server 2005: How to Perform Extensive Auditing of All Logins"
This series will be detailing out specific information towards Service Brokers in SQL Server by starting out with an introduction to Event Notification, Service Broker, Routes, Auditing, Queues and Services. You will also learn about a complex stored procedure for logons, and about the testing of the event notification and application event log.

Highlights:
  • ENABLE_BROKER definition and explanation
  • Basic explanation to QUEUE creation
  • Basic explanation to ROUTE and SERVICE creation
  • Introduction to properly declared variables
  • TSQL IF and ELSE statements
  • Basic overview of event and xml logs

To view all videos in this series, click here

About the Instructor:
Scott Whigham Scott Whigham is the founder of LearnItFirst.com, one of the web's most extensive video training libraries focusing on technical training. Scott is also an experienced consultant, trainer, and author with more than a decade of hands-on experience working with SQL Server databases, writing and debugging applications using Visual Studio, and performance tuning. Scott designed the architecture (websites, class libraries, and database) for the LearnItFirst.com websites and, most re... (Scott Whigham's full bio can be found on the About the Author page)

   
 
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:05:06 AM