Messaging solutions are often complex to implement and frequently fall short of expectations. TwoConnect has developed a messaging solution which leverages the database itself as the messaging engine and allows data to flow directly to and from the database. The solution is based on Microsoft’s SQL Server Service Broker; an enabler to building secure, reliable and scalable applications. Service Broker is part of the database engine, and therefore administration of these applications is part of the routine management of the database. Service Broker provides queuing and reliable messaging for SQL Server, and is used for applications using single SQL Server instance and/or applications that distribute work across multiple instances.
Service Broker's features provide a number of significant benefits to database applications:
:: Enhances application performance and simplifies administration
:: Simplifies application development via message ordering and coordination
:: Workload flexibility is achieved through loose application coupling
:: Related message locking allows more than one instance of an application to process
messages from the same queue without explicit synchronization
:: Applications scale easily to meet message volume through automatic activation