Presented by Allen White
Total Running Time: 201 minutes
Service Broker was introduced in SQL Server 2005 to help developers build asynchronous, loosely coupled applications in which independent components work together to accomplish a task. This class is aimed at breaking down the barriers to understanding Service Broker and implementing it with ease.
In this 3-hour training course, Allen White will focus on asynchronous messaging in your database applications, designing business applications to use asynchronous messaging for non-critical updates, and real time data integration using Service Broker.
By the end of this course, you will learn:
- Understand the Service Broker architecture
- Understand the need for real-time updates
- Demonstrate how the non-critical updates are best handled asynchronously
- Demonstrate how the real-time updates can be accomplished with Service Broker and Transact-SQL
Session 1: Demystifying Asynchronous Messaging
Service Broker is seldom used because it isn't well understood. In this session, Allen will walk you through the basics of Service Broker, including the components involved in getting messages sent from one place to another. He will talk about both normal and external activation, where an application – rather than a stored procedure – receives and processes the messages, and he'll discuss strategies to handle various problems like poison messages.
Session 2: Insuring Successful Business Data Delivery with Service Broker
How your business applications interact with the corporate database directly can have a dramatic impact on how successful you are, and one of the biggest issues is performance with large databases. By designing the application to use asynchronous messaging for non-critical updates you can focus performance concerns to where the timeliness is critical. SQL Server Service Broker handles the asynchronous requests quickly and efficiently, and minimizes the conflicts with your critical updates. This session will walk you through the steps to get Service Broker up and running and provide a consistent delivery of your business data.
Session 3: Using Service Broker to do ETL from an OLTP Database
Most of the time you'll see Extract, Transform, Load (ETL) being done with a tool such as SSIS, but what if you need near-real time reporting? This session will demonstrate how to keep your data warehouse updated using Service Broker messages from your OLTP database.
About Our Instructor:
Allen White is a Microsoft SQL Server MVP and Practice Leader at UpSearch. Allen has been working with relational database systems for over 20 years. He has architected database solutions in application areas like retail point-of-sale (POS), POS audit, loss prevention, logistics, school district information management, purchasing and asset inventory and runtime analytics. He is the past President of the Ohio North SQL Server User Group, the Cleveland, OH based chapter of the Professional Association for SQL Server (PASS). Contact Allen at upsearch.com. Follow Allen on Twitter: @SQLRunr
Need to be invoiced or interested in registering 2 or more people? Please contact our customer service team at firstname.lastname@example.org or by phone at 800-262-1954 or 913-967-1719. Invoicing options and group discounts are available.