Asynchronous Processing with SQL Server Service Broker - A case Study

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]