Overlord Tracking Changes, Real Time, in Your Environment

Learn to use SQL Server Event Notifications to track database changes in real time and report them through email, reports, or source control. The course covers event processing, multi-server setup, security, and troubleshooting.

Syllabus

Intro
Technical Assistance
PASS SUMMIT 2015
The Questions We'll Answer Today
How? What are our options?
What are Event Notifications?
What are Event Types & Event Groups?
What's needed for a simple example
Processing new events
What do we need for additional servers?
Security & Authentication
Adding a new server
Setting it up automatically
SSMS Reports
Caveats
Troubleshooting
System Views
Michael Bourgon