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/

Monday, July 09, 2007 4:03:26 PM UTC |  | Disclaimer | Comments [0] | 

Hi all,

       we are only a few days away from having of yearly big conference, lots of great sessions, speakers and a brillant venue!! This is one not to miss.

You can register over at this link, just look at the agenda/sessions below!! How could you not attend :)

Hope to see you there,

/Paul 

ps

Note the agenda is subject to change.

Time Intervals				Screen 1		Screen 2		Screen 3
09:00	-	09:15		Registration and Breakfast
09:15	-	09:30
09:30	-	09:45
09:45	-	10:00		Welcome Address
10:00	-	10:15		10:00 - 11:15 Service Broker - processing work asynchronously Simon Sabin		10:00 - 11:00 SDLC the Team System Way Ronan Gray		10:00 - 11:15 Building Silverlight Applications using .NET (Part 1 of 2) Tim Sneath
10:15	-	10:30
10:30	-	10:45
10:45	-	11:00
11:00	-	11:15
11:15	-	11:30				11:15 - Microsoft's Virtualisation Strategy and Products Dave Northey
11:30	-	11:45		11:30 - 12:45 How to Use Indexes to Speed Up Your SQL Server Database Hugo Kornelis				11:30 - 12:45 Building Silverlight Applications using .NET (Part 2 of 2) Tim Sneath
11:45	-	12:00
12:00	-	12:15