Yesterday I delivered a session for the PASS DBA Virtual Chapter on Service Broker. In preparing for the session I was having trouble with my demo environment. Since early this year, after I upgraded my laptop to a Lenovo W510 with 10GB RAM, I've been using VM Workstation for my demo and test machines, replacing the Microsoft Virtual PC demos ...

Last week I introduced the Service Broker Basics. Today I'd like to cover some of the ''plumbing'' - the components that allow communication between different servers running Service Broker. Endpoints. There needs to be a channel for the communications coming in and out of the server, and in the IP world that channel exists in the form of a ...

I'm currently implementing a Service Broker solution at a client site, and it's been an interesting challenge, because there's not a lot of information out there to help guide you through the process. Here I'd like to walk you through the basics. Message Types. Service Broker sends messages asynchronously from one database to another. You can ...