Perth SQL Server User Group

We have meetings once a month on a Thursday. As of September 2013 the group will be meeting at the Enex 100 Seminar Room at 100 St George's Terrace.

We use EventBrite for meeting registrations - check out for a list of our previous events. Anyone is welcome to register, but please let us know at the meeting if you want to be added to the mailing list so you get email notifications of upcoming events.

We are always looking for local speakers, so if you want to try your hand at presenting feel free to let us know!

-- Jenny



Topic: Service Broker
Date: Thursday 22nd January, 5.00pm-7.00pm

Nick Jacobsen


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.

Speaker Bio:

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.