DAT325 SQL Server 2005 (code named "Yukon"): Using the Service Broker to Build Asynchronous, Queued Database Applications
Good to see many people attending considering when the session this session
happened.
- Service broker is a platform for building asynch, queued database
application
- Queue are first class database objects, which the queue operations
expressed in TSQL. Message processing is transactional. All this leads to
reliable distributed queuing
- Asynch provides loose coupling, better performance, load distribution,
batch processing and scale out.
- Demonstrated HelloWorld with a SvcBroker app written in T-SQL.
- Queued apps are hard to write because
- Message Integrity -- you have to know it was transmitted and
received.
- Queueing is important
- Good example of parent-child queuing
- Talked about the dialog protocol -- there will be authentication and
encryption support
- Doesn't use SSL, nor is the destination encrypted for efficiency
reasons
- Messaging is itself is hard
- Writing queues are hard
- Why do messaging in the database?
- Integrated API for the message and the data
- Integrated management, deployment and operations
- Better performance in many cases
- Different features than what is in BizTalk
- Did a demo where he used XQuery to pull data out of message. Cool!
I'm really impressed with Roger's skill as a speaker and the demo. Folks, you
really should be at least looking at this technology.