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 SQL Blog (Weblog) by simonsabin on Thu, Jun 7 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 SQL Blog (Weblog) by simonsabin on Thu, Mar 29 2007
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 height=90;var width=720;

Posted to Simons SQL Blog (Weblog) by simonsabin on Tue, Dec 5 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...

Posted to Simons SQL Blog (Weblog) by simonsabin on Tue, Oct 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 SQL Blog (Weblog) by simonsabin on Tue, Oct 17 2006
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 database. This is because a connection to database...

Posted to Simons SQL Blog (Weblog) by simonsabin on Tue, Oct 3 2006
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. Simply put, you need semi colons at...

Posted to Simons SQL Blog (Weblog) by simonsabin on Tue, Oct 3 2006
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 that need to be addressed to turn implement such...

Posted to Simons SQL Blog (Weblog) by simonsabin on Fri, Sep 29 2006
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 of the many things that result in your messages...

Posted to Simons SQL Blog (Weblog) by simonsabin on Thu, Sep 28 2006
Service Broker Gotchas - Its case sensitive

I've started using service broker and its full of new terminology. This will be a set of posts of the gotchas I've found on the way. The first is "case". Most of us run SQL in case insensitive mode so we can refer to our tables and columns by what ever case is trendy at the time, camel...

Posted to Simons SQL Blog (Weblog) by simonsabin on Tue, Sep 26 2006

Page 1 of 1 (10 items)