About the Presentation
Asynchronous T-SQL processing
Many times an application needs to launch into execution a T-SQL script, but it is not interested in waiting until the script is finished. Traditionally such a task would be accomplished using a SQL Agent job. I will present an approach that leverages SQL Service Broker Activation mechanism and go over the advantages and disadvantages of this alternative.
Session Level: Intermediate
Remus Rusanu
Remus Rusanu provides consulting for database application development and for SQL Server administration, deployment and performance troubleshooting. He has been writing database applications for 15 years and is a former member of the SQL Server development team. He maintains a blog focused on Service Broker issues.
Contact URL:
http://rusanu.com