Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Overlord Tracking Changes, Real Time, in Your Environment

PASS Data Community Summit via YouTube

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

Reviews

Start your review of Overlord Tracking Changes, Real Time, in Your Environment

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.