Microsoft SQL Server 2005 Notification Services

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]

data files (database systems)

     separating from log files 2nd

data flows

     efficiency of

    normalizing

         notification data 2nd

         overview 2nd

         subscription data 2nd

    prefiltering events

         overview 2nd 3rd

     streamlining 2nd

data layer (SMIs)

     connecting to the logic layer 2nd

     description of 2nd

Data Protection API (DP API)

     hosted engines

Database class

     AddSubscriptions program

database objects

     application configurations 2nd

     changing manually

    creating

         for membership providers (ASP.NET) 2nd

     delivery channels 2nd

     delivery protocols 2nd

    examing

         with nscontrol create 2nd

     instance metadata 2nd

     instances 2nd

     Registry keys 2nd

    storing in database systems. [See filegroups]

     subscriber data 2nd

     subscriber locale tables

     timezones tables

database permission

     deployment process 2nd

database permissions

     music store application (SMIs) 2nd 3rd

     user-defined logic security 2nd

database permissions. 2nd [See also permissions]

database roles 2nd

     database security 2nd

     distributors 2nd 3rd

     event provider security 2nd

database systems

     deployment security and 2nd

database systems (deployment configurations)

    filegroups

         creating 2nd 3rd 4th

         creating with T-SQL 2nd

         file sizes, choosing 2nd

         overview 2nd

         specifying for database objects 2nd 3rd

     overview 2nd

    physical database files

         data and log files, separating 2nd

         file sizes, managing 2nd

         hardware considerations 2nd

         overview 2nd

         tempdb, separating and sizing 2nd

     recovery models, setting 2nd

database tables

     stored procedures

Databases node (Object Explorer)

databases, exploring 2nd

debugging (rules)

     development process and 2nd

     generators, reenabling after 2nd

     overview 2nd 3rd

     preparing for 2nd 3rd

     quantum clocks, setting for 2nd 3rd 4th

    rule firing

         executing 2nd 3rd

         preparing for 2nd

     semantic errors 2nd

     syntax errors 2nd

     with scheduled subscription debugging stored procedures 2nd 3rd 4th

declarative programming frameworks (SQL-NS)

default filegroups

delegates

     NSInstance.Error event handlers

Delete() method

     subscriber devices

     subscriber objects 2nd

     subscription operations 2nd

DeliverNotification() method

     IDeliveryProtocol interface 2nd 3rd 4th 5th 6th 7th

delivery channels 2nd 3rd 4th

     BodyEncoding delivery channel

     creating for custom delivery protocols 2nd

    declaring

         in the ICF 2nd

     device records

     routing notifications to 2nd

    SMTP delivery channels

         creating 2nd 3rd 4th 5th

     subscriber devices, adding 2nd

     Subscriber Management APIs

    troubleshooitng

         subscriber devices 2nd

     troubleshooting 2nd 3rd 4th

     versus delivery endpoints

     versus delivery protocols 2nd 3rd 4th

delivery channels. [See also distributos [NPN]]

delivery endpoints

     versus delivery channels

delivery failures 2nd

delivery protocols 2nd

     [brkt-]DeliveryChannels[-brkt] element

     application development process 2nd

     building 2nd

     debugging

    declaring

         in the ICF 2nd

         support for in the ADF 2nd

     declaring in the ICF 2nd

    delivery channels

         creating for custom delivery protocols 2nd

     delivery failures 2nd

     digest/multicast delivery 2nd

     distributors 2nd

     distributors invocation of

     HTTP-based protocols 2nd

     IDeliveryProtocol interface 2nd 3rd 4th

     implementing 2nd 3rd 4th 5th

     Message Queuing

    music store application

         instances, re-creating 2nd

         preparing for 2nd

         service account permissions, changing 2nd

         SMTP Service, installing 2nd

         supporting components, building 2nd

    non-starting

         troubleshooting 2nd

    notification classes

         supporting in 2nd 3rd

         testing 2nd 3rd

     notification distribution views 2nd 3rd 4th

     operation of 2nd

     overview 2nd

     performance optimization 2nd

     SMTP delivery protocol. [See also SMTP delivery protocol]

     troubleshooting 2nd 3rd 4th

     versus delivery channels 2nd 3rd 4th

delivery protocols. [See also distributors [NPN]]

DeliveryChannel class

     containment relationships

DeliveryChannelArgument class

     StockBrokerNMO sample

deployment configurations

    database systems for. [See database systems (deployment configurations)]

     high availability configurations 2nd

    multiserver configurations

         overview 2nd

     overview 2nd

    scaling out

         SQL-NS engines 2nd

     scaling the server 2nd

    single machine deployment

         overview 2nd

     SMIs and event providers, separating 2nd

     specifying in the ICF and ADFs 2nd

deployment configurations (instances)

deployment machines

     SQL-NS, installing on 2nd

deployment machines. [See also deployment configurations]

deployment process

     application database instances, creating 2nd

     application database instances, registering 2nd

    custom components

         overview 2nd

     enabling instances 2nd

     event providers 2nd

     overview 2nd

     permissions, grating 2nd 3rd 4th

     SMIs 2nd

     specifying server configurations 2nd

     SQL-NS, installing 2nd

     starting instances 2nd

deployment security

     accountsa and authentication 2nd

     database access, controlling 2nd

     overview 2nd

     security policies

     sensitive information, guarding 2nd

     throttles, utilizing 2nd 3rd 4th

deployment servers. [See also deployment configurations]

design questions (application development process) 2nd

details (subscribers)

     overview. 2nd [See also records (subscribers)]

developer-defined logic

     overview

     versus user-defined logic 2nd 3rd 4th

developer-defined matching logic

     overview

development accounts

     setting up 2nd

development enviornments

    root directories

         NewInstances, creating 2nd

development environements

    instances

         adding codes to new instances 2nd

         creating directories/files for 2nd 3rd

         running new instances 2nd

development environments

     command-line tools 2nd

     computers for 2nd

    directory layouts

         overview 2nd

     environment variables, setting up 2nd 3rd

     installing SQL Server components 2nd

     local SQL Server configurations

     overview

     remote SQL Server configurations

    service accounts

         creating 2nd 3rd

    source code

         installing 2nd

     source files, customizing 2nd

     SQL Server 2005 Management Studio 2nd

    SQL Server authentications

         development accounts 2nd

         overview 2nd

         setting up 2nd

         test accounts 2nd

     testing 2nd

     user account security 2nd

     Visual Studio .NET 2005 2nd

         installing 2nd

    Windows Server authentications

         overview 2nd

         setting up 2nd 3rd 4th 5th

development machines versus SQL Servers

development process (applications). [See application development process]

device records

     notification batches

device types (content formatters)

device-specific formatting

     device types, specifying 2nd

     enabling in music store application 2nd 3rd

     overview 2nd 3rd

     subscribers/subscriptions, adding 2nd

device-specific XSL transforms

     directory layouts 2nd

     music store application 2nd 3rd

     overview

     testing 2nd 3rd

DeviceName column

DeviceName fields

     overview 2nd

devices (subscribers), manipulating. [See subscriber device operations]

diagnostic reports 2nd

digest delivery

     application development process 2nd

     content formatting 2nd

     delivery protocols 2nd

digest messages

digest parameter (content formatters) 2nd

dilvery channel arguments

     encrypting 2nd

directories

    creating

         for new instances 2nd 3rd

directory structures

     new instances

Disable() method

     NMOs

disable_generator.cmd

DisableEscaping arguments 2nd 3rd

DisableSubscribers() method

     NMOs

DisableSubscriptions() method

     NMOs

distribution (notification application phase) 2nd

distribution logs

     distributor optimization 2nd 3rd

distribution pipelines

     overview 2nd

Distributor class

     StockBrokerNMO

distributor logging

     timeouts, troubleshooting

     versus event logs

distributor logging options

     distributor optimization 2nd 3rd

Distributor name

     StockBrokerNMO

distributor polling intervals. [See distributor quantums]

distributor quantums 2nd

distributor work items

     incomplete distributor work items, troubleshooting 2nd

     overview 2nd

distributors

     database roles 2nd 3rd

     multiple distributors 2nd

    optimizing

         delivery protocol performance 2nd

         distributor logs and 2nd 3rd

         distributor quantums and 2nd

         overview 2nd

         thread pool sizes and 2nd

         with multicast delivery 2nd

         with notification batch size control 2nd 3rd

     overview

    troubleshooting

         batch files, failure generating 2nd

         content formatters/delivery protocols/non-starting 2nd

         device names 2nd

         duplicate notification delivery 2nd

         duplicate notification generation 2nd

         generator fall-behind 2nd

         incomplete distributor work items 2nd

         non-enabled distributors 2nd

         non-starting distributors 2nd

         notification expirations 2nd

         SQL-NS services, non-starting

         subscribe device names 2nd

         subscriber device configurations 2nd

         subscriber devices 2nd

         time zones 2nd

         timeouts 2nd 3rd

     versus content formatters 2nd

distributors. [See also delivery protocols]

DoEventSubmission() method

     MQHostedEventProvider class 2nd

domain accounts

     creating 2nd

     versus local accounts 2nd

DP API (Data Protection API)

     hosted engines

DP APIs

DROP TABLE statements

Drop() method

     NMOs

duplicate notifications

    troubleshooting

         delivery of 2nd

         generation of 2nd

duration data types (XSD) 2nd

dynamic instance definitions. [See also instances]