O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Summary

Service Broker pushes SQL Server even further outside the bounds of being a pure database server and into the application server realm.

Because it is built directly into SQL Server databases, Service Broker inherently provides backup and restoration, replication and failover, and single-mode transactions, which together give Service Broker an edge over competing messaging technologies. Plus, as you’ve seen, it’s extremely easy to set up and begin coding because you need to do very little groundwork; all the ingredients are already “in there.”

One issue not covered in this chapter is the fact that service programs may be written in managed code that makes use of SQL Server CLR integration. At the time of this writing, there is no officially ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required