1 / 24

Solving Business Problems with SQL Server Notification Services Executive Briefing

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.

olympe
Download Presentation

Solving Business Problems with SQL Server Notification Services Executive Briefing

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Solving Business Problems with SQL Server Notification ServicesExecutive Briefing SQL Server Notification Services Microsoft Corporation October 2003

  2. Getting Information - PULLNo notifications – connected requestor Web News Request My Device ERP, CRM Response LOB, Rpt

  3. Getting Information - PUSHPush notifications – all or nothing Web News My Device Push SPAM ERP, CRM LOB, Rpt

  4. 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

  5. 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

  6. 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

  7. 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

  8. Surprise ! You’re probably already using Notification Services • MSN Autos • MSNBC • ESPN • NYTimes.com • Townsend Analytics • Slate • SmartMoney.com

  9. 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

  10. 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?

  11. Business Intelligence Applications • Track critical company data • Numeric data reaches a threshold • Focus on Key Performance Indicators

  12. 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

  13. Employee Communication • Keep employees informed • Updates to projects • Timely research • Alert to actions that may be required

  14. 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

  15. 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

  16. 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

  17. 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

  18. Why Invest in SQL Server Notification Services? • Rapid time to market • Ease of development • Rich feature set • Scalable and reliable • Flexible and extensible

  19. 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

  20. 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

  21. 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

  22. 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

  23. 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

  24. 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

More Related