240 likes | 336 Views
Solving Business Problems with SQL Server Notification Services Executive Briefing. SQL Server Notification Services Microsoft Corporation October 2003. Getting Information - PULL No notifications – connected requestor. Web. News. Request. My Device. ERP, CRM. Response. LOB, Rpt.
E N D
Solving Business Problems with SQL Server Notification ServicesExecutive Briefing SQL Server Notification Services Microsoft Corporation October 2003
Getting Information - PULLNo notifications – connected requestor Web News Request My Device ERP, CRM Response LOB, Rpt
Getting Information - PUSHPush notifications – all or nothing Web News My Device Push SPAM ERP, CRM LOB, Rpt
Getting Information - NOTIFYNotifications – subscriber preference Web Notification Application My Device(s) of Choice News ERP, CRM A new class of applications that deliver personalized and timely information to any device LOB, Rpt
Why Invest In Notifications • Send critical information to customers, partners, and employees • Form proactive relationships with customers and clients using personalized, timely services • Make it easier for customers to initiate business transactions with you • Empower employees with information whenever and wherever they need it
Key IndustriesLow Hanging Fruit in Abundance • Financial Services • Travel & Hospitality • Retail • Telecommunications • Government • Plus other large multi-departmental organizations • Manufacturing • Professional Services • System Integrators and Solution Partners
Key ApplicationsRapid Value-Add with Notifications • Electronic Commerce • Line of Business apps • Alert person or system when action required • Business Intelligence • Thresholds set upon Key Performance Indicators • Operational Health • Broaden beyond the Operations Center • Personalized Communication • Timely research, project updates, news channels
Surprise ! You’re probably already using Notification Services • MSN Autos • MSNBC • ESPN • NYTimes.com • Townsend Analytics • Slate • SmartMoney.com
Consumer Applications • Might scale to millions of subscriptions • Automatically send notifications to customers • Financial Services • Receive and react to personal portfolio changes and current market conditions • Travel and Hospitality • Flight arrivals, schedule changes • Electronic Commerce • Search criteria, buy and sell
Line of Business Applications • Monitor business data • Alert the appropriate person or system when action is required • Define the events that occur in the LOB application • Which events are of likely interest to subscribers or other applications?
Business Intelligence Applications • Track critical company data • Numeric data reaches a threshold • Focus on Key Performance Indicators
Operational Health Notifications • Co-exist with existing monitoring • Would not replace a monitoring solution • Broaden notification range beyond the console to devices like cell phones • Assembly line machine needs attention • Production server event log receives a critical error
Employee Communication • Keep employees informed • Updates to projects • Timely research • Alert to actions that may be required
SQL Server Notification ServicesA Notification Platform • Platform to develop and deploy rich, highly scalable notification applications • Declarative programming model • Based upon XML and T-SQL • Execution engine • Based upon SQL Server 2000 and .NET Framework • Maintenance tasks built in
Incoming Events • Events produced by new or existing system(s) • Use Events API to write them into the notification application • Native managed API • COM interoperability layer • Numerous real life examples Note: in the common case of schedule-driven subscriptions, events may be unnecessary
Generating Notifications With Match Rules Cubs 3 Giants 1 (final) Subscribers want to know whenever event occurs Can add relevant info to it Notifications trigger whenever event occurs Triggered by event Occurrence 9:00a each Mon-Fri Time zones built-in Calendar recurrence patterns Settable intervals between notifications Notifications trigger however subscriber requests them Triggered by day and time Highest MSFT price today Often combined with Day and Time schedule rules Can pull info from cumulative events Sensitive to event history Wait a day to repeat Often combined with Day and Time schedule rules Can control intervals between notifications Sensitive to subscription history
Distributing NotificationsFormatting and Delivery • Choice of content formatting (CF) • Device specific • Language specific Rich Formatting • To application server, cell phone, wireless PDA, desktop PC, and/or e-mail account Combine notifications sent to the same user into one notification Digest Notifications • Send daily summary of my portfolio • Send summary of docs modified since I last connected • Same message to many subscribers • Format once, deliver to many ‘Multicast’ Notifications • Weather report for New Orleans area • Traffic on I-95 • Corporate newswire
Why Invest in SQL Server Notification Services? • Rapid time to market • Ease of development • Rich feature set • Scalable and reliable • Flexible and extensible
Rapid Time To Market • Low or no additional licensing cost • Included in SQL Server license • Notification Services framework provides most of the core infrastructure • Leverage existing systems • No need to rip and replace • Heterogeneous environments okay Prototype, build and deploy scalable notification applications quickly
Ease Of Development • Use well-known tools and techniques • Integrated experience with Visual Studio • Leverage SQL Server expertise • Developing T-SQL procedures • Tuning the relational database • Managing a SQL Server database • Full .NET Application Short learning curve, leverage existing development experience
It’s a .NET ApplicationLeveraging SQL Server Capabilities • Color legend: • SQL Server 2000 • .NET Application • Developer Choice Subscription Management Application Subscription Management Objects Persistent Data Store Data Changes External Delivery Subscribers Subscriber Devices Subscriptions Notifications Events Distributor Event Provider Generator Delivery Protocol Content Formatter Email XSLT CF Executes Stored Procs SQLMatchRule EventProviderHost File System Watcher File HttpExt Custom CF SQL Server provider .NET Alerts* Custom DP Custom EP
Rich Feature Set • Management features • Queue management • Failures and retry logic • Windows services • Application features • Varied options for incoming events • Rich match rules to generate notifications • Rich formatting and delivery options Rich application model with various notification application features, plus manageability
Scalable And Reliable • Notification Services generation exceeds any protocol delivery • Read performance whitepaper for details • Standard best practices for tuning SQL Server databases • Support for various deployment configurations • H/W to balance workload, high availability Scalable and reliable notification engine out-of-the-box
Resources • Notification Services Website • http://www.microsoft.com/sql/ns • Explore the Technical Resources page • Technical Discussions • microsoft.public.sqlserver.NotificationSvcs • URL:http://communities.microsoft.com/newsgroups/default.asp?icp=SQL • DevelopMentor offers a 3-day course • http://www.develop.com/dm/course.asp?id=163 • Product Suggestions • mailto:nswish@microsoft.com