April 2005 - Posts

SQL Server Service Broker (SSB) is in my mind one of the coolest features of SQL Server 2005, and I have done quite a lot with it. What is most frustrating with it though is the lack of GUI. In other words, to use it – you have to create all your objects in scripts.

So, a while ago – quite a long time ago as a it was, I thought that I should create an application which would help me with creation/management of SSB objects. This application is SSB Admin (I should have called it SSB Explorer, but Dan already took that name). 

SSB Admin is a GUI application for managing and creating SQL Server 2005 Service Broker (SSB) Objects on networked SQL Server 2005 Servers. Some of the features of the product are:

  • Viewing networked SQL Server 2005 instances and their SSB objects.
  • Creating new SSB objects through a GUI.
  • Deploying SSB Objects to other instances/databases than where they originally were created.
  • Sending messages between services and on conversations.
  • View messages.

If anyone is interested in testing it, you can download it from here.

Any comments/feedback/suggestions for improvements are always welcome. Either email them to me or leave a comment here.

Well, it has been a while since I blogged last (way too long). There are many reasons for this, mostly personal so let’s just leave it at that. From now on I hope I’ll be able to post more regularly. With the release of the SQL Server 2005 April CTP, .NET framework Beta 2 I should have enough to post for a while.