Browse by Tags

All Tags » Service Broker (RSS)
07 June 2007 16:52

Service Broker - Asynchronous/Multi threaded File Upload

The code and slides from my presentation from today ( Service Broker - Asynchronous processing in SQL )are now online. The code is on codplex http://www.codeplex.com/MultiThreadedSQL , The slides are on http://sqlblogcasts.com/files/folders/servicebrokerpresentations...
Posted by simonsabin | 1 comment(s)
Filed under: , , , , , ,
07 June 2007 13:19

Service Broker - Reliable processing

I have just finished my presentation on asynchronous process/parallel processing using Service Broker at the Microsoft Technology Conference in Ireland . I was a bit tentative after deciding last night, after a few guinesses and whisky (thanks Barry ...
Posted by simonsabin | 2 comment(s)
Filed under: , , ,
20 April 2007 00:21

Are you using service broker?

I ask this because the SB newsgroup hasn't had a post for over 3 weeks. Which suggests not many people are using it? - var height=90;var width=720;
Posted by simonsabin | 5 comment(s)
Filed under: ,
29 March 2007 15:06

Free 2GB SQL Server USB Keys

We are holding the next UK SQL User group meeting in Central London on the 26th April from 6pm - 9pm (later if you fancy a drink) The eveneing will have a SQL event and BI event running side by side with 8 presenters and loads of giveaways including t...
Posted by simonsabin | with no comments
Filed under: , , , , , , , , , , ,
05 December 2006 22:15

Developer Day 4 Demo - Now available

The demo files associated with are now available. Make sure you read the description first as it includes how to deploy the demo. http://sqlblogcasts.com/files/folders/servicebrokerdemos/entry1472.aspx - var height=90;var width=720;
Posted by simonsabin | with no comments
Filed under: , , , , , , ,
05 December 2006 10:42

Asynchronous Processing in SQLServer 2005

My presentation from Developer Day 4 is now available here http://sqlblogcasts.com/files/folders/servicebrokerpresentations/default.aspx Please remember to fill in the feedback on Developer Day 4 at http://www.developerday.co.uk/ddd/feedback.asp - var...
Posted by simonsabin | with no comments
Filed under: , , , ,
23 November 2006 11:49

Developer Day 4

If you've never been to a developer day then your missing a great day. The day is split into a number of tracks with 5 sessions in each track. All the sessions are given by non-microsoft people and are generally based on real life experience, which...
Posted by simonsabin | with no comments
Filed under: , ,
07 November 2006 23:50

Service Broker - Always check @@rowcount

If you're using service broker you will may be using activation to have a stored procedue read messages off a queue. If you are make sure you are aware that you activation procedure will be activated at times even when they're are no messages...
Posted by simonsabin | with no comments
Filed under: ,
17 October 2006 00:16

SB - Its expensive to start a conversation

I've just mentioned Remus's post on service broker procedures . The other thing that came up when looking at the conversation group size was the time it took to load the queue. This set of figures shows the load time, the first is the number of...
Posted by simonsabin | with no comments
Filed under: , , ,
17 October 2006 00:03

Getting performance out of service broker procedures

Remus has written a great article on use of activation SPs and the way of achieving the best performance. http://blogs.msdn.com/remusrusanu/archive/2006/10/14/writing-service-broker-procedures.aspx I am looking into this as a means of asynchronous logging...
Posted by simonsabin | 2 comment(s)
Filed under: , , ,
More Posts Next page »