Chapter 28. Getting asynchronous with Service Broker
Mladen Prajdić
SQL Server Service Broker is an asynchronous messaging system built into the database engine. Because it resides in the database, it fully complies with ACID (atomicity, consistency, isolation, durability) principles. Messages are stored, they can’t be lost, and they’re a part of the transactional system. Having a system like this in the database engine opens up a world of new possibilities in database programming. Quite a few things are implemented on the Service Broker architecture inside the database engine, such as event notifications, database mail, server-to-client notifications of changed data, and database mirroring.
Service Broker has been a part of SQL Server since ...
Get SQL Server MVP Deep Dives, Volume 2 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
