We have just deployed my first Service Broker project to the live environment and touch wood everything appears to have gone ok. Sure it took a little massaging to get it through and we certainly learned a few things along the way but thats all part of it right.
Working for a well known job board we are using service broker in conjunction with SQL CLR to do asynnchronous string manipulations to job adverts. Orignally this was something we did through replication but it became clear very quickly that fast as CLR is, replication latency would be effected. So instead we had a re-think and moved the process offline. We’re sure that there are many other applications for Service Broker within our business now.
