Microsoft SQL Server 2005 Notification Services

ISBN: 0672327791
EAN: 2147483647

Year: 2006
Pages: 166

Authors: Shyam Pather

BUY ON AMAZON

Microsoft SQL Server 2005 Notification Services
Table of Contents
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
SYMBOL
A
B
C
D
E
F
G
H
I
J
L
M
N
O
P
Q
R
S
T
U
V
W
X