Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Service Broker, SQL Server Express Rss

   Items 1 to 11 of 11   
 

Service Broker Poison Message Handling

Recent installments of our series dedicated to SQL Server 2005 Express Edition have focused on error handling techniques that leverage Service Broker's transactional nature. This article describes Poison Message detection characteristics and presents an example demonstrating its use.  Read more...
By Additional Articles 2009/04/02 | Source: Database Journal | Category: sql server express
Rating: (not yet rated)  Rate this |   Briefcase | 1,262 reads

Handling Service Broker Errors

The previous installment of the 'SQL Server 2005 Express Edition' series discussed using transactions to protect the integrity and consistency of Service Broker-based communication. Depending on the type of issue encountered by our code, the outcome might be different from expected. This article demonstrates a more robust approach to error handling and applies it to our target.  Read more...
By Additional Articles 2009/03/18 | Source: Database Journal | Category: service broker
Rating: (not yet rated)  Rate this |   Briefcase | 1,104 reads

Service Broker Transactional Support in SQL Server 2005 Express Edition

This article provides an overview and presents an example illustrating the role of transactions in processing Service Broker dialogs usage.   Read more...
By Additional Articles 2009/02/26 | Source: Database Journal | Category: service broker
Rating: (not yet rated)  Rate this |   Briefcase | 1,136 reads

Configuring Anonymous Dialog Security in SQL Server 2005 Express Service Broker Conversation

Recent installments of our series have discussed configuring Service Broker full dialog level security, which required a mechanism to facilitate the exchange of certificates between communication partners. In this article, we will present an alternative approach, which eliminates this requirement by relying on anonymous dialog security.  Read more...
By Additional Articles 2009/01/14 | Source: SQLServerCentral.com | Category: service broker
Rating: (not yet rated)  Rate this |   Briefcase | 1,066 reads

Conducting Service Broker Conversation Using Full Dialog Security in SQL Server 2005 Express Service

In the previous installment of our series covering the most relevant features of SQL Server 2005 Express Edition, we started an overview of Service Broker full dialog-level security. In this article, we will conclude this subject by describing the remaining prerequisites and a method to invoke a secure dialog.  Read more...
By Additional Articles 2009/01/06 | Source: Database Journal | Category: sql server express
Rating: (not yet rated)  Rate this |   Briefcase | 1,057 reads

Configuring Transport Encryption in SQL Server 2005 Express Service Broker Conversation

In the recent installments of our "SQL Server 2005 Express Edition" series we have been discussing mechanisms that facilitate authentication of distributed systems participating in Service Broker conversations. This article discusses use of digital certificates in encrypting their content on the transport level.  Read more...
By Additional Articles 2008/12/01 | Source: Database Journal | Category: sql server express
Rating:  Rate this |   Briefcase | 1,563 reads

Configuring Certificate-based Authentication in SQL Server Express' Distributed Service Broker Environment

Implementing a dialog between two services residing in a distributed environment requires the presence of an authentication mechanism. Windows-based Kerberos protocol limits the scope of systems participating in a Service Broker dialog to those residing in the same or trusted Active Directory domains. This article provides an overview of how to eliminate this limitation by employing certificates.  Read more...
By Additional Articles 2008/11/03 | Source: Database Journal | Category: security
Rating: (not yet rated)  Rate this |   Briefcase | 1,594 reads

SQL Server 2005 Express Edition - Part 32 - Distributed Service Broker Environment - Conducting Dialogs

This installment of our series focuses on establishing, conducting, and terminating a sample Service Broker dialog in a distributed environment, leveraging previously established routes and dialog-level permission.  Read more...
By Additional Articles 2008/10/21 | Source: Database Journal | Category: sql server express
Rating: (not yet rated)  Rate this |   Briefcase | 1,516 reads

SQL Server 2005 Express Edition - Part 30 - Distributed Service Broker Environment - Endpoints

In the latest articles of our series dedicated to SQL Server 2005 Express Edition, we have been discussing Service Broker. This article describes the initial setup of components required to demonstrate a distributed implementation, with initiator and target services residing on two separate computers.  Read more...
By Additional Articles 2008/09/18 | Source: Database Journal | Category: sql server express
Rating: (not yet rated)  Rate this |   Briefcase | 1,363 reads

SQL Server 2005 Express Edition - Part 27 - Implementing Basic Service Broker Objects

Marcin Policht explains the interaction of the primary elements of Service Broker's asynchronous messaging framework and describes a process of setting up the database objects necessary to demonstrate their sample implementation (which will be the subject of our next article).  Read more...
By Additional Articles 2008/08/07 | Source: Database Journal | Category: sql server express
Rating: (not yet rated)  Rate this |   Briefcase | 1,710 reads

SQL Server 2005 Express Edition - Part 26 - Introduction to Service Broker

This article is a brief overview of Service Broker's core features, which are available (in a somewhat limited capacity) in SQL Server 2005 Express Edition. The next installment will describe a sample application illustrating its operations and discuss its management, security, and routing characteristics.  Read more...
By Additional Articles 2008/07/17 | Source: Database Journal | Category: service broker
Rating: (not yet rated)  Rate this |   Briefcase | 2,268 reads
   Items 1 to 11 of 11   
 
Tags
security (3)    
certificates (1)    
encryption (1)    
error handling (1)