Service Broker - SimonS Blog on SQL Server Stuff

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? if (socialButtons!=null) { socialButtons(); } - google_ad_client = "pub-9351707026400773"; google_alternate_color="FFDDAA"; google_ad_width...
Posted by simonsabin | 3 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 if (socialButtons!=null) { socialButtons(); } - google_ad_client...
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 if (socialButtons...
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 makes...
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. For this...
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 conversations...
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: , , ,
06 October 2006 10:45

TSQL turning into C#

Following my previous post about the requirement of semi-colons when using service broker statements, I have raised a suggestion to improve the "Incorrect syntax near ..." error message. If you find the above message less than helpful, then vote for the...
Posted by simonsabin | with no comments
Filed under: , , ,
03 October 2006 23:03

Service Broker - Enabling Service Broker requires exclusive database access

If your trying to enable service broker and it is just hanging then you must have other connections accessing your database. The enabling of service broker requires a database update lock, this is only possible if there are no other connections in the...
Posted by simonsabin | with no comments
Filed under: , ,
03 October 2006 18:52

Service Broker - Dont forget your semi colons

If you don't know semi colons have been made mandatory in some areas of SQL 2005 and it is likely that it will be required for many more going forward. Of all the areas I've touched in SQL 2005 Service Broker is the most sensitive to the use of semi colons...
Posted by simonsabin | 1 comment(s)
Filed under: , , ,
29 September 2006 00:04

Service Broker - Asynchronous Logging

One of the solutions I am looking to implement is an aysnchronous logging mechanism. Whilst this is not the a truly native messaging solution that Service Broker has all the bells and whistles for, it can still be achieved. There are a number of aspects...
Posted by simonsabin | with no comments
Filed under: , , ,
28 September 2006 12:59

Service Broker - Clean up your transmission queue

This isn't about changing your air filter, spark plugs or oil. Its about what to do when, like me, you don't get things right first time. If developing Service Broker applications and you misspell your services, forget to create a master key, or do any...
Posted by simonsabin | 1 comment(s)
Filed under: , , ,
More Posts Next page »