Browse by Tags

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/entry1885.aspx and a video of the...

Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 06-07-2007
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 ), to add a new feature to my presentation, failure...

Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 06-07-2007
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 = 728; google_ad_height = 90; google_ad_format...

Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 04-20-2007
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-shirts, books and USB keys. If you want to learn...

Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 03-29-2007
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 = "pub-9351707026400773"; google_alternate_color...

Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 12-05-2006
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 the content great. I'll be speaking this time...

Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 11-23-2006
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 reason your logic should always be, RECEIVE ......

Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 11-07-2006
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 and the second the number of messages per...

Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 10-17-2006
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 and so have taken Remus's script and expanded...

Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 10-17-2006
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 suggestion. https://connect.microsoft.com/SQLServer...

Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 10-06-2006

Page 1 of 2 (16 items) 1 2 Next >