Главная
Study mode:
on
1
Intro
2
Technical Assistance
3
PASS SUMMIT 2015
4
The Questions We'll Answer Today
5
How? What are our options?
6
What are Event Notifications?
7
What are Event Types & Event Groups?
8
What's needed for a simple example
9
Processing new events
10
What do we need for additional servers?
11
Security & Authentication
12
Adding a new server
13
Setting it up automatically
14
SSMS Reports
15
Caveats
16
Troubleshooting
17
System Views
18
Michael Bourgon
Description:
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.

Overlord Tracking Changes, Real Time, in Your Environment

PASS Data Community Summit
Add to list
00:00
-00:50