Overview
Discover how to track and monitor real-time changes in your SQL Server environment using Event Notifications. Learn to become the database Overlord by implementing a system that alerts you to unreported changes, preventing unexpected errors, performance issues, and failed audits. Explore the native SQL Server feature of Event Notifications, understand Event Types and Event Groups, and gain hands-on experience with production-ready code. Master the process of setting up automated notifications via email, reports, or even source control. Dive into topics such as processing new events, managing multiple servers, security and authentication, and troubleshooting techniques. Equip yourself with the knowledge to maintain control over your database environment and proactively address potential issues before they impact your systems.
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
Taught by
PASS Data Community Summit