Rachit's Blog : Service Broker

Missing Microsoft.SqlServer.SmoEnum Dll

rachitp — Wed, 29 Jul 2009 16:12:09 GMT

I like this SSB (Sql Server Broker) Admin tool but every time I refer this to somebody they come back to me with the questions that some of the DLLs are missing and they can’t launch the application. You should be able to find all the missing Dlls on...(read more)

Learning SQL Server Broker

rachitp — Fri, 16 May 2008 23:48:37 GMT

Working on some project, I have started delving a lot with Microsoft SQL Server Broker for 2005. I can see that the initial learning curve is very very steep and it's very easy to give up on SSB initially. But if you are like myself, learning SSB, be patient. IMHO, the possible reasons of "not liking" SSB initially are as follows:

Not having a decent GUI to develop it. (We are used to VS.Net, here you have only SSMS (SQL Server Management Studio (you can use Notepad or TextPad) and .sql file)
No Project template/Wizard available (at least I don't know at the time of writing this) in SSMS.
Very hard to debug when you try to implement the SSB on the distributed (remote) servers, especially when you deal with stored procs within SSB.

Despite of all above reasons, there are compelling reasons to use SSB if you are looking for performance, queuing (alternative to MSMQ) and scalability.

I sincerely hope that Microsoft makes the using of SSB easier in the SQL Server 2008. Really...

In future, I'll write up a few articles about the configuration, security, etc. related to SSB. So, stay tuned.

SQL Server Service Broker & WCF

rachitp — Tue, 29 Apr 2008 13:50:06 GMT

I've started digging into SQL Server Service Broker 2005 and how I can use WCF with it. My current project requires some kind of reliable queuing and I've two choices: MSMQ & SSB. So, I'm trying to evaluate which way to go? There's a blog entry here mentioning that the WCF Channel for SSB bit will be available soon but I've not seen it anywhere yet. Can anybody from Microsoft comment on this?

Does anybody have any app running in production using SSB? Would you mind sharing your experience? Pros or cons why I should use MSMQ instead of SSB?