120 likes | 248 Views
Demystifying MS SQL Server Notification Services. Andre Dovgal Senior Technology Architect, Visiphor Corporation. Agenda. Typical scenarios How SSNS works Configuring main components More customization Q&A. Notification Services. SMTP Server. Scenario #1. Stock Price Updates. Data
E N D
Demystifying MS SQL Server Notification Services Andre Dovgal Senior Technology Architect, Visiphor Corporation
Agenda • Typical scenarios • How SSNS works • Configuring main components • More customization • Q&A
Notification Services SMTP Server Scenario #1. Stock Price Updates Data Feed Database Server Web Server
System Administrator System Administrator Scenario #2. Electronic Data Processing System (EDPS) message statuses Notification Services delivery receipts exceptions SMTP Server
Common challenges • Dynamic subscribers • Dynamic subscriptions • Scalability • Event records management
Matching Creating Notifications Subscribers Real World Events Subscriptions Events Notification Services Notifications
Notification Services Subscriptions EP Event Provider Host Generator Distributor EP
Instance and Application • Notification Services instance – unit of deployment • Notification Services application – unit of development Sunny State Police IS Electronic Data Processing System (EDPS) Internal Approval System Collaboration System
Configuring Main Components • SSNS instance • SSNS application • Running a test
System Administrator System Administrator Electronic Data Processing System (EDPS) for Sunny State M M M M S M E31 message statuses Notification Services delivery receipts exceptions SMTP Server
.NET Libraries • Managing subscribers • Managing subscriptions • Adding event providers