Demystifying MS SQL Server Demystifying MS SQL Server Notification ServicesNotification Services

Andre Dovgal

Senior Technology Architect,

Visiphor Corporation

AgendaAgenda

• Typical scenarios • How SSNS works• Configuring main components• More customization• Q&A

Scenario #1. Stock Price UpdatesScenario #1. Stock Price Updates

SMTP Server

Web Server

Database Server

DataFeed

NotificationServices

Scenario #2. Electronic Data Scenario #2. Electronic Data Processing System (EDPS)Processing System (EDPS)

MessageLogs

message statuses

delivery receipts

exceptionsSMTP Server

NotificationServices

SystemAdministrator System

Administrator

Common challengesCommon challenges

Dynamic subscribersDynamic subscriptionsScalabilityEvent records management

Creating NotificationsCreating NotificationsReal World Events

Subscriptions

Notification Services

Notifications

Subscribers

Events

Matching

Notification ServicesNotification Services

Event Provider

Host

Subscriptions

Generator Distributor

EP

EP

Instance and ApplicationInstance 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 ComponentsConfiguring Main Components

SSNS instanceSSNS applicationRunning a test

Electronic Data Processing System Electronic Data Processing System (EDPS) for Sunny State(EDPS) for Sunny State

MessageLogs

message statuses

delivery receipts

exceptionsSMTP Server

NotificationServices

SystemAdministrator System

Administrator

MM

M M

SM

E31

.NET Libraries .NET Libraries

Managing subscribersManaging subscriptionsAdding event providers

Questions?Questions?