Irish Microsoft Technology Conference 2007 - Service Broker and Asynchronous processing in SQL - by Simon Sabin
For those that could not make this years IMTC here is Simon Sabin's session on Service Broker and Asynchronous processing in SQL
[for full WMV download, click here]
Session Description: We all want to do more with our data, but sometimes we can't do it in TSQL, we also don't want to affect our users experience or affect the scalability of our database systems Whilst SQL Server 2005 bought us the CLR in SQL Server to be able to do very complex processing within the SQL Engine, many are concerned with running CLR code within the SQL Server process space, and there are still restrictions on what can be done with CLR. That also doesn't address the issue of impacting the users experience, doing complex processing synchronously is still not ideal Service Broker provides the developer with the opportunity to solve these problems. With service broker you can
perform processing asynchronously, so as to provide the best user experience
offload processing to an external process, to enable you to use what ever functionality you wish SMO, Web Services, etc
offload processing to additional servers, to allow your system to scale, allowing you external process to have it's own memory
In this session we will introduce you to the Service Broker concepts and show you how to use solve these challenges.
Simon Sabin's biography: Simon has worked with SQL Server for since 1998 having moved over from Oracle. He currently works for Totaljobs Group the largest internet job site company in the UK, and was awarded as an MVP in April 2006 He spcialises in the development of high performance Microsoft systems utilising the SQL Server. His recent focus has been on the development of high performance search systems using SQL Server, full text and text mining. Co-author SQL Server XML Distilled.
Visit Simon's blog - http://sqlblogcasts.com/blogs/simons
Visit the Totaljobs Group web site - http://www.totaljobs.com/ SO and SOA | SQL Server | Transactions | Web Services | imtc
Monday, July 09, 2007 4:03:26 PM UTC | | Disclaimer | |
|