Perth Microsoft Data and Analytics User Group

Event

Next Meeting: Thu, Jan 22 2015

Service Broker

Language: English
Event Type: In-Person
Online Meeting URL: None
RSVPURL: https://www.eventbrite.com/e/pssug-service-broker-nick-jacobsen-tickets-15297275563

With the advent of Service Oriented Architectures (SOA) and Enterprise Service Buses (ESB), the SQL Server product team responded by providing an enabling technology called Service Broker.  Despite being a standard feature of the core SQL Server product since SQL Server 2005, Service Broker has often been overlooked regardless of the powerful tool that it is. Initially touted as a queuing technology in the vein of MSMQ and IBM WebSphere MQ it’s tight coupling to a database server is what sets it apart. In this session we’ll start with an overview and work through multiple examples of practical real world scenarios and solutions to get you started using Service Broker now. 

While generally pushed as a reliable asynchronous messaging solution a few tweaks can provide such benefits as transaction segregation, multi-threaded database processing and asynchronous processing, all of which can increase scalability and maintain responsive user interfaces.


 

When

iCal
UTC : Thu, Jan 22 2015 09:00 - 11:00
Event Time : Thu, Jan 22 2015 17:00 - 19:00 (UTC+08:00) Perth
Your Local Time: Thu, Jan 22 2015 09:00 - 11:00

Where

2 Mill St
Perth, WA

Direction: None

Featured Presentation

Service Broker

Speaker: Nick Jacobsen, Senior SQL DBA Oncall DBA

Summary: With the advent of Service Oriented Architectures (SOA) and Enterprise Service Buses (ESB), the SQL Server product team responded by providing an enabling technology called Service Broker. Despite being a standard feature of the core SQL Server product since SQL Server 2005, Service Broker has often been overlooked regardless of the powerful tool that it is. Initially touted as a queuing technology in the vein of MSMQ and IBM WebSphere MQ it’s tight coupling to a database server is what sets it apart. In this session we’ll start with an overview and work through multiple examples of practical real world scenarios and solutions to get you started using Service Broker now. While generally pushed as a reliable asynchronous messaging solution a few tweaks can provide such benefits as transaction segregation, multi-threaded database processing and asynchronous processing, all of which can increase scalability and maintain responsive user interfaces.

About Nick: Nick Jacobsen has been administering databases and developing applications utilising SQL Server since 1998. During that time he has developed a myriad of applications utilising SQL Server 6.5 to SQL Server 2012. Nick has provided consulting services on database design and infrastructure to various organisations for the past 10 years. Currently he is designing and developing a Corporate Data Layer for the Department of Training and Workforce Development’s internal applications utilising SQL Server 2012, Service Broker and C#. The corporate data layer controls master data as well as integrates applications on SQL 2005, SQL 2008R2, SQL 2012, Microsoft CRM Dynamics 2011, Sharepoint and provides BI feeds to Cognos and SSAS. Nick is a Senior SQL DBA at OnCall DBA and holds numerous Microsoft Certifications; MCSE in SQL 2012, MCSA, MCITP and MCTS.

Attachments

PASSChapterLogo100.jpg 

PASS provides the Perth SQL Server User Group with this website and other resources.

Microsoft provides us with a venue in which to host our meetings once a month.

OnCall DBA provides us with complimentary refreshments each month.

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids