imported>Cander0000: replaced official url with archive url as a reference and external link

2024-11-22T05:52:53Z

replaced official url with archive url as a reference and external link

New page

'''SQL Server Notification Services''' is a platform developed by Microsoft for the development and deployment of [[Notification service|notification applications]] based on [[Microsoft SQL Server|SQL Server technology]] and the [[Microsoft]] [[.NET Framework]]. Notification Services offers a scalable server engine on which to run notification applications, with multi-server capability-providing flexibility and scalability for deploying applications.<ref>{{cite web|url=http://www.microsoft.com/sqlserver/2005/en/us/notification-services.aspx#FAQ |title=SQL Server 2017 on Windows and Linux |publisher=Microsoft |access-date=2019-04-08}}</ref>

Notification Services was designed to ease the pain of developing and deploying notification applications that generate personalized, timely information to subscribers.<ref>{{cite web |url=http://www.microsoft.com:80/sql/technologies/notification/default.mspx |title=Microsoft SQL Server: Notification Services |archive-url=https://web.archive.org/web/20080408184034/http://www.microsoft.com:80/sql/technologies/notification/default.mspx |archive-date=2008-04-08}}</ref>

To design, code and test all of the components that make up a robust Notification Services Application-such as notification scheduling, failure detection, retry logic, time zone management, notification grouping, and queue management, adding Notification Services to software applications can be a daunting task.

==Background==
Over the years the term '''Notification applications''' has been superseded with the term [[Complex event processing|Complex Event Processing (CEP)]]. The idea is that the user defines a set of Rules (or Queries) in advance, and then push data through those rules. Should the data fit any of the criteria of the Rules then some action is fired. For example: A rule may state "If car speed through sensor is above 100 km/h, take photo and record" otherwise all other data is discarded.

This approach is much faster than the traditional OLTP design of; Insert the row(s) into the database while constantly polling the data to see if something relevant has happened. It is especially suited to situations where you have high speed inputs, a fixed set of fairly simple queries and may not need to keep all the data.{{Citation needed|date=January 2012}} e.g.: Some industries measure the voltage, current and other attributes of hundreds of electric motors in their conveyor belts, 100 times each second. Then compare each measurement to its average, plant operators are alerted should a sudden change occur.

==Release history==
SQL Server Notification Services was one of the many components that comprised Microsoft SQL Server. It was first released in Microsoft SQL Server 2000 Service Pack 2 (2003). An enhanced release shipped in SQL Server 2005.
It was discontinued and removed from SQL Server 2008,<ref>{{cite web|url=http://social.msdn.microsoft.com/forums/en-US/sqlnotificationservices/thread/3f2dbd91-f223-411d-9c66-07be3ffcfed2/ |title=What happend [sic] with NS in 2008? |publisher=Social.msdn.microsoft.com |access-date=2019-04-08}}</ref> although SQL Server 2005 SP3 allows for the '''Notification Services''' components to be run against the SQL Server 2008 Database Engine.<ref>{{cite web|url=https://msdn.microsoft.com/en-us/library/dd353312(SQL.90).aspx |title=What's New in SQL Server 2005 SP3 | Microsoft Docs |publisher=Msdn.microsoft.com |date=2008-11-17 |access-date=2019-04-08}}</ref>
It has been replaced by StreamInsight which first shipped as a component of SQL 2008 R2. StreamInsight is a separate install and not visible as a part of a regular SQL Server setup.

==Extensibility and programmability==
A programming framework based on [[Transact-SQL]] and [[XML]], provides a declarative programming model, and lends itself to quick prototyping and deployment of robust notification applications.

An [[Application programming interface|API]] for creating subscription management applications is provided, plus standard components for collecting event data from files and SQL Server databases, for formatting notifications using [[XSLT]], and for sending notifications via [[Simple Mail Transfer Protocol]] (SMTP) or by writing notifications to a file.

If the standard components do not meet the needs of an application, Notification Services is extendable by building custom components using the .NET family of programming languages, such as [[C Sharp (programming language)|Microsoft Visual C# .NET]] and [[Visual Basic|Microsoft Visual Basic .NET]].

Finally, Notification Services can communicate with a wide variety of Microsoft, third-party, and custom-built event providers and delivery protocols, enabling Notification Services to communicate with existing systems in heterogeneous environments.

==See also==
* [[Apple Push Notification Service]]
* [[Google Cloud Messaging]]
* Boomerang Software Framework

==References==
{{Reflist}}

==Further reading==
* ''Microsoft SQL Server 2005 Notification Services'', Shyam Pather, Sams Publishing, {{ISBN|978-0-672-32779-7}}
* ''The Rational Guide to SQL Server Notification Services'', Rational Press, {{ISBN|978-0-9726888-1-9}}

==External links==
* [https://web.archive.org/web/20060507201118/http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=97&SiteID=1 Forums]
* {{webarchive |url=https://web.archive.org/web/20080408184034/http://www.microsoft.com:80/sql/technologies/notification/default.mspx |title=Microsoft Official Website |archive-date=2008-04-08}}
* [https://www.microsoft.com/technet/prodtechnol/sql/2005/technologies/ntfcsvcs.mspx TechNet]

{{MS DevTools}}

[[Category:Microsoft database software]]
[[Category:Push technology]]

SQL Server Notification Services - Revision history

imported>Cander0000: replaced official url with archive url as a reference and external link