Table of Contents

Microsoft® SQL Server 2005 Notification Services
By Shyam Pather
...............................................
Publisher: Sams
Pub Date: February 14, 2006
Print ISBN-10: 0-672-32779-1
Print ISBN-13: 978-0-672-32779-7
Pages: 720

Table of Contents  | Index

		Copyright
		About the Author
		Acknowledgments
		We Want to Hear from You!
		Introduction
			Who Should Read This Book
			Teaching Approach
			Organization of This Book
			About the CD-ROM
			Conventions
		Part I:  Notification Services Concepts
			Chapter 1.  An Overview of Notification Applications
				The Publish-Subscribe Phenomenon
				Components of a Pub-Sub System
				Challenges in Building Notification Applications
				SQL Server 2005 Notification Services
				Summary
			Chapter 2.  Getting Set Up
				Your Development Environment: The Big Picture
				Prerequisites and System Requirements
				Standard or Enterprise Edition?
				Setting Up Your Development Environment
			Chapter 3.  The Simplest Notification Application: Stock Quotes
				The SQL-NS Application Model
				Building the Stock Application's ADF
				Specifying Other Parts of the Stock Application
				Running the Stock Application
				Inside the Running Application
				What Has the SQL-NS Platform Provided?
				Cleaning Up the Instance and Application
				Summary
			Chapter 4.  Working with SQL-NS Instances
				What Is an Instance?
				Creating an Instance and Making It Run
				Examining the Parts of the Instance
				Deployment of SQL-NS Instances on Multiple Servers
				The Instance Configuration File in Detail
				Cleaning Up the Instance
				Summary
		Part II:  Notification Services Application Development
			Chapter 5.  Designing and Prototyping an Application
				What Is a SQL-NS Application?
				Stages in the Application Development Process
				Supporting the Sample Application
				Initial Design: Seven Important Questions About Your Application
				Building the Application Prototype
				Summary
			Chapter 6.  Completing the Application Prototype: Scheduled Subscriptions and Application State
				Scheduled Subscriptions in the Music Store Application
				Source Code for This Chapter
				Event State
				The Scheduled Subscription Class
				Testing Scheduled Subscriptions
				Final Testing of the Prototype
				Summary
			Chapter 7.  The SQL-NS Subscription Management API
				Overview of Subscription Management Interfaces
				Types of Subscription Management Interfaces
				The SQL-NS Subscription Management API
				Getting Set Up to Use the API
				Implementing the Logic Layer of a Subscription Management Application
				Building the User Interface
				Summary
			Chapter 8.  Event Providers
				Overview of Event Providers and Event Submission
				Event Provider Concepts
				Preparing to Work with the Source Code in This Chapter
				Using the Built-in Event Providers
				APIs for Building Custom Event Providers
				Building Custom Hosted Event Providers
				Building Standalone Event Providers
				Cleanup: Preparing for the Next Chapter
				Summary
			Chapter 9.  Content Formatters
				Overview of Content Formatting
				Preparing the SQL-NS Instance
				Using the XsltFormatter
				Building a Custom Content Formatter
				Summary
			Chapter 10.  Delivery Protocols
				Overview of Notification Delivery in SQL-NS
				Preparing to Work with Delivery Protocols
				Using the Built-in SMTP Delivery Protocol
				Building a Custom Delivery Protocol
				Restoring Your System
				Summary
			Chapter 11.  Debugging Notification Generation
				Debugging and the Development Process
				Inside the Notification Generator
				Using the SQL-NS Debugging Facilities
				Summary
		Part III:  Optimization, Deployment, and Administration
			Chapter 12.  Performance Tuning
				Overview of Performance Tuning in SQL-NS Applications
				Streamlining Data Flow
				Optimizing Notification Generation
				Optimizing Notification Distribution
				Summary
			Chapter 13.  Deploying a SQL-NS Instance
				Deployment Configurations
				Configuring a Database System for Deployment
				Vacuuming Old Data
				Deployment Security
				The Deployment Process
				Summary
			Chapter 14.  Administering a SQL-NS Instance
				Monitoring and Reporting
				Maintenance Techniques
				Backup and Restore
				Summary
			Chapter 15.  Troubleshooting SQL-NS Applications
				Using the Troubleshooting Information in This Chapter
				Troubleshooting Compilation
				Troubleshooting Event Submission
				Troubleshooting Notification Generation
				Troubleshooting Notification Distribution
				Summary
		Part IV:  Advanced Notification Services Concepts
			Chapter 16.  Using Notification Services Management Objects
				Overview of the NMO API
				An NMO Sample Application
				Using NMO to Define and Create an Instance
				Using NMO to Administer an Instance
				Testing the StockBrokerNMO Sample Application
				Using NMO to Reflect the Contents of an Instance
				Summary
			Chapter 17.  Hosting the SQL-NS Execution Engine
				Using the SQL-NS Hosting API
				EngineHost: A Sample Hosting Application
				Summary
			Chapter 18.  User-Defined Matching Logic in SQL-NS Applications
				Overview of User-Defined Matching Logic
				Building the Music Store Application with User-Defined Matching Logic
				Summary
		Part V:  Appendix
			Appendix A.  Creating a Development Environment for Your Own SQL-NS Applications
				The Structure of the Development Environment
				Extending the Development Environment
		Index