Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
How about an asynchronous queuing mechanism which doesn’t entail a customary two phase commit ?
How about, not worrying about dead locks,transactions, blockings, waits ?
How about scaling out/up your systems without any extra line of codes ?
How about not losing your peace of mind over data integrity/Consistency ?
How about simply adding your order to a queue and the system confirms the order with the order confirmation popping into your inbox ?
SQL Server answers it all with remarkable two words – “Service Broker” !
The vblog discusses a case study in < 15 mins, for an online ecommerce site, on how the orders can be asynchronously processed and confirmation emails be sent, all with the help of SQL Server Service Broker.
[View:https://www.youtube.com/watch?v=jXhTE5BY8eA]