Marcin Policht

In the recent installments of our series covering topics related to SQL Server 2005 Express Edition, we have been focusing on specifics of its Service Broker implementation. Throughout our discussions, we have been applying a certain degree of simplification, primarily for the sake of clarity and conciseness. It is important, however, to note that some […]

In the previous installment of our series dedicated to the most prominent features of SQL Server 2005 Express Edition, we discussed one of the Service Broker-related technologies known as internal activation. As we have explained, its primary purpose is to trigger execution of an arbitrary stored procedure associated with a Service Broker queue, whenever there […]

In the recent installments our series dedicated to the most prominent features of SQL Server 2005 Express Edition, we have been discussing Service Broker functionality, focusing in particular on methods of securing its conversations. In the examples demonstrating their implementation, we took a somewhat simplified approach, which relied on interactive invocation of individual T-SQL statements […]

In the recent installments of our series dedicated to the most relevant features of SQL Server 2005 Express Edition, we have described the steps necessary to configure Service Broker full dialog level security. As we have explained, this not only resulted in encryption of all messages that were part of the same conversation with a […]

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. As we have pointed out, its primary advantages include the ability to encrypt individual conversations as well as to identify and authorize their participants. In order to […]

In the previous installment of our series dedicated to the most prominent features of SQL Server 2005 Express Edition, we discussed the role of transport-level encryption in securing communication between distributed Service Broker endpoints. As we mentioned at that point, a considerably more flexible mechanism not only provides similar functionality on the dialog level, but […]

In the recent installments of our series dedicated to the most prominent features of SQL Sever 2005 Express Edition, we have been discussing mechanisms that facilitate authentication of distributed systems participating in a Service Broker conversation. As we have explained, such goal can be accomplished by employing either Windows-based protocols (NTLM or Kerberos) or digital […]

In the previous installment of our series covering features available in SQL Server 2005 Express Edition, we started discussing the use of certificates in authenticating Service Broker conversations in a distributed environment, where communication partners reside on separate hosts. As we have pointed out, some sort of authentication mechanism is needed in such scenarios in […]

In the recent articles of our series dedicated to the most prominent features incorporated into SQL Server 2005 Express Edition, we have been discussing Service Broker functionality. So far we have presented a couple of scenarios demonstrating implementation of a sample dialog between two services residing in the same database and an equivalent arrangement taking […]

In the recent articles of our series covering features available in SQL Server 2005 Express Edition, we have introduced asynchronous, queue-based messaging functionality offered by the Service Broker component. So far, in addition to providing a general overview of its characteristics, we have described a simplified example of a conversation between two services residing in […]

In the previous installment of our series covering features available in SQL Server 2005 Express Edition, we began an overview of a distributed Service Broker environment, by describing the most essential requirements for its sample implementation. For the sake of simplicity, we decided to exclude (for the time being) more advanced functionality such as encryption […]

In the latest articles of our series dedicated to SQL Server 2005 Express Edition, we have been discussing Service Broker, providing an overview of its basic concepts and presenting characteristics of its dialog protocol, which facilitates session-level features responsible for asynchronous, secure, and reliable message exchange. For the sake of clarity, we have postponed coverage […]