Thank you so much for sharing! It doesn't really apply to much to what we're doing, but I'm pretty new to databases and step-by-step articles like this are really awesome. You've got great, clear explanations with good code examples.
You are right. For some special scenario, SSIS does not comply with very critical logic. So that we have used such implementation. Our system change most frequently specially the validation rule so there is a huge implication to use SSIS. However thanks a lot for your suggestion.
Thanks for your query. You know, this article's content is not compatible with SQL Express as SQL Agent is not available there. However, if you want to keep the asynchronous processing away from Database level then you can implement it through ADO.Net SqlClient object (SqlCommand.BeginExecuteNonQuery Method)
I have this king of async stored procedure execution implementation in one of my SSIS packages.
This is also very simple to implement, just prepare you SQL statements and run them through this method.
There is another way, using service broker, but I am not fan of broker so I will not help you in this regard. But you can have a look on the article.