Triad SQL Server User Group

The Triad SQL Server Users Group (TSSUG); is a forum where Microsoft SQL Server database administrators and developers meet to learn more about the product, share ideas and make contact with other similar individuals. Our group is run by SQL Server professionals for the benefit of anyone interested in participating in the group.
All of our meetings are free and open to anyone who is interested in sharing their knowledge of SQL Server. Our meetings are generally held on the last Tuesday of every other month, unless otherwise noted. Food is no longer being provided, however you are welcome to bring in your own.


Next Meeting: Thu, Aug 11 2011

Building and troubleshooting a basic Server Broker Application

Language: English
Event Type: In-Person
Online Meeting URL: None

Building and troubleshooting a basic Server Broker Application


UTC : Thu, Aug 11 2011 22:00 - 01:00
Event Time : Thu, Aug 11 2011 18:00 - 21:00 Eastern Daylight Time
Your Local Time: Thu, Aug 11 2011 22:00 - 01:00


4821 Koger Blvd
Greensboro, North Carolina

Direction: None

Featured Presentation

Building and troubleshooting a basic Server Broker Application

Speaker: Katherine Fraser, Data Architect Volvo

Summary: In this session you’ll see a case study of a production SQL Service Broker 2008 application currently sending up to 3.7 million messages per day. We’ll cover the basic database objects needed to build a Service Broker application—message types, queues, services and contracts—and see a demo showing how to create and connect these objects in a database. You will learn about establishing a Service Broker conversation and how optionally to implement dialog pooling. For troubleshooting, we’ll use SQL Profiler to show the events specific to Service Broker that can help diagnose problems and also the sys views that can help you see where messages go when they “disappear.” This brief overview should get you up and running with Service Broker and able to solve basic configuration and queuing problems.

About Katherine: Katherine Fraser has been working in the IT field since 1995, focusing on data modeling and visualization in multiple domains such as financial services, manufacturing, and logistics. In her current position as a BI data architect, she works with a global team to design and build data marts and reports to analyze information. Katherine has a Masters degree in Information Systems and a weird passion for data storage and retrieval.








Back to Top