\nThis one is about SQL Server Service Broker. It's not necessarily a cool or sexy feature, but may be the most revolutionary feature in there. The problem with Service Broker is that most people don't get it. They think YAQS (yet another queuing system). It's more than that. It's already used for 3 features inside the server (query notifications, event notifications, and mailer), there could easily be more. A SQL Agent replacement comes to mind. But I digress, this is supposed to be a wish list. If you still don't get it, think harder. Or come talk to me. Or listen. Here's wishes.\n<\/p>\n
\nSSMS support. Currently only does display functionality. A "route, security, and message testing" piece and configuration would be nice too.\n<\/p>\n
\nMonolog support. So I won't have to keep explaining why it's "BEGIN DIALOG" but "END CONVERSATION".\n<\/p>\n
\nBroker support on SQL Server Mobile. For obvious reasons. It could be a discreet subset.\n<\/p>\n
\nObject model that works for internal activation, external activation, and clients. There's a nice one in engine samples; it should be officially supported. It would be cool if it was design type similar to JMS. Plus extensions.\n<\/p>\n
\nSupported auto-deployment. For each side of a service. Again, its been done, but not officially supported.\n<\/p>\n
\nSame (official support) for external activator.\n<\/p>\n
\nWCF channel. For transactional messages, broker doesn't use DTC. Makes it faster. Faster still when messaging combined with database operations.\n<\/p>\n
\nHTTP channel. Although that can be built by third parties too.\n<\/p>\n
\nWCF and WWF assemblies should be able to be marked as "SQL Server safe". Or they'll have to run in the external activator.\n<\/p>\n
\nHmmm…many\/most of these contained the word "support" somewhere.\n<\/p>\n
\nMore wishes to come.<\/p>\n","protected":false},"excerpt":{"rendered":"
This one is about SQL Server Service Broker. It's not necessarily a cool or sexy feature, but may be the most revolutionary feature in there. The problem with Service Broker is that most people don't get it. They think YAQS (yet another queuing system). It's more than that. It's already used for 3 features inside […]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[24,28],"tags":[],"class_list":["post-901","post","type-post","status-publish","format-standard","hentry","category-service-broker","category-sql-server-2005"],"yoast_head":"\n