RE: [SQLDownUnder] Service Broker

Last post 07-11-2008, 2:23 PM by Paul Nielsen. 0 replies.
Sort Posts: Previous Next
  •  07-11-2008, 2:23 PM 9674

    RE: [SQLDownUnder] Service Broker

    Look at the Rational Guide to Service Broker, it has a good reputation.

    -Paul Nielsen
    SQL Server MVP
    www.SQLServerBible.com
    sign up for my free e-Newsletter

    -----Original Message-----
    From: SQLDownUnderList@...
    [mailto:SQLDownUnderList@...] On Behalf Of
    rjempo@...
    Sent: Friday, July 11, 2008 12:05 AM
    To: SQLDownUnder@...
    Subject: [SQLDownUnder] Service Broker

    Hello,

    I was wondering if anyone can point me at some material, or offer any
    suggestions regarding the Service Broker.

    I am evaluating whether the Service Broker can be used as a fire and forget
    style 'message bus'.

    By which I mean whether it has the capability to call external services (say
    a WCF service) / programs, and what the best practice is for architecting
    such an infrastructure.

    eg, Does it offer the follow features :


    some app or 3rd party -> WCF -> message on a queue -> message filtered /
    processed based on a 'policy' -> message passed onto a different 3rd party
    service (WCF) -> acknowledgement -> retry ....


    OR

    is it more useful as a simple queue that can pass messages between SQLServer
    instances

    I realise you could hand-roll the processing / filtering and forwarding of
    messages to a 3rd party service, and use the Service Broker as the
    underlying queue, but wondered if it could offer more?

    Cheers.

    Ross



    to unsubscribe to this list, please send a message back to the list with
    'unsubscribe' as the subject. Powered by mailenable.com - List managed by
    http://www.readify.net



    __________ Information from ESET NOD32 Antivirus, version of virus signature
    database 3260 (20080710) __________

    The message was checked by ESET NOD32 Antivirus.

    http://www.eset.com



    __________ Information from ESET NOD32 Antivirus, version of virus signature
    database 3260 (20080710) __________

    The message was checked by ESET NOD32 Antivirus.

    http://www.eset.com




    to unsubscribe to this list, please send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com - List managed by http://www.readify.net
View as RSS news feed in XML