July 2008 - Posts

25 July 2008
Reusing dialogs with a dialog pool
As noted in various Service Broker sources, it is often advantageous to minimize the overhead of creating dialogs to send messages on. This blog shows how to create a shared pool of dialogs to be able to reuse dialogs instead of creating new ones. The Read More...
14 July 2008
Using multiple routes in Service Broker
One of main Service Broker components is routing. Whenever you want your messages to leave the database they originate in, you need to provide routes. Setting up routes may become complicated, so if you're making your first steps in Service Broker area, Read More...
09 July 2008
Real Time Data Integration with Service Broker and Other SQL Techniques
This article discusses how to use various SQL technologies to accomplish real time data integration between SQL Server instances. It provides a set of sample code to help users with their development. The document focuses on the usage of each technology Read More...
Page view tracker