SimonS' SQL Server Stuff

Service Broker - Asynchronous/Multi threaded File Upload

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Service Broker - Asynchronous/Multi threaded File Upload
The new RSS feed is here

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,

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Service Broker - Asynchronous/Multi threaded File Upload

Service Broker - Reliable processing

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Service Broker - Reliable processing
The new RSS feed is here

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.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Service Broker - Reliable processing

Are you using service broker?

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Are you using service broker?
The new RSS feed is here

I ask this because the SB newsgroup hasn't had a post for over 3 weeks. Which suggests not many people are using it?

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Are you using service broker?

Free 2GB SQL Server USB Keys

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Free 2GB SQL Server USB Keys
The new RSS feed is here

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.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Free 2GB SQL Server USB Keys

Developer Day 4 Demo - Now available

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Developer Day 4 Demo - Now available
The new RSS feed is here

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

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Developer Day 4 Demo - Now available

Asynchronous Processing in SQLServer 2005

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Asynchronous Processing in SQLServer 2005
The new RSS feed is here

My presentation from Developer Day 4 is now available here http://sqlblogcasts.com/files/folders/servicebrokerpresentations/default.aspx

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Asynchronous Processing in SQLServer 2005

Developer Day 4

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Developer Day 4
The new RSS feed is here

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.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Developer Day 4

Service Broker - Always check @@rowcount

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Service Broker - Always check @@rowcount
The new RSS feed is here

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.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Service Broker - Always check @@rowcount

SB - Its expensive to start a conversation

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/SB - Its expensive to start a conversation
The new RSS feed is here

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 conversation, and the final number, the time it took in seconds.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SB - Its expensive to start a conversation

Getting performance out of service broker procedures

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Getting performance out of service broker procedures
The new RSS feed is here

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

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Getting performance out of service broker procedures

TSQL turning into C#

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/TSQL turning into C#
The new RSS feed is here

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.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/TSQL turning into C#

Service Broker - Enabling Service Broker requires exclusive database access

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Service Broker - Enabling Service Broker requires exclusive database access
The new RSS feed is here

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 will place a shared lock on the database top make sure no one drops it. However this shared lock will block the update lock required to enable service broker.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Service Broker - Enabling Service Broker requires exclusive database access

Service Broker - Dont forget your semi colons

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Service Broker - Dont forget your semi colons
The new RSS feed is here

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.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Service Broker - Dont forget your semi colons

Service Broker - Objects reside in each database

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Service Broker - Objects reside in each database
The new RSS feed is here

One thing you learn very early on with Service Broker is that even though Services and Contracts at first may appear to be server wide configuration, they are actually database objects.

This makes sense as the service broker objects relate to a function i.e. application and the level of granularity for backing up and maintaining such a function is a database.

However the difference between normal objects and Service Broker objects (apart from the case sensitivity) is that when you create Service Broker objects you can't specify the database or a schema. This means you have to be in the database you want to create