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  

Event Notifications in SQL Server 2005: How to Perform Extensive Auditing of All Logins (Video Series)

Video Image Video Category: Miscellaneous - Topics That Do Not Fit Anywhere Else!

Skill Level: 500 (Advanced)

Versions/Editions Covered: SQL Server 2005
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

Videos in this Series:


Miscellaneous Bits & Pieces:
Tips and Tricks: Create your own customized MMCs (Microsoft Management Console) for easier administration. Go to the command-line and run the command "MMC" to launch the MMC window. All that's left is for you to add in the various snap-ins you want to work with and then save the file
Management Tip: Automation is your friend. Make good use of SQL Server jobs and alerts to build a proactive solution. Configure alerts for common scenarios such as backup failures, log filling up, deadlocks and more. Have these alerts fire off jobs that protect and react to the situation. For example, configure an alert that fires off a log backup job if the log of database "MyDb" gets 90% full
Keyboard Shortcut for SQL Server Management Studio: Shift+F1 brings up the context-sensitive help in Books Online

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!
 
11/20/2008 8:53:38 PM