Saskatoon SQL Server User Group

Next Meeting




Meeting 3 of 2018

Meeting 3 will happen on Friday April 27th, 2018 at 1:30 PM at the Saskatoon Community Service Village.

RSVP link has been updated.

Featured Presentation:

Troubleshooting Service Broker

Brian Gale, DBA Vecima Networks Inc

Restoring service broker from a live system to a test system can give you strange results. From messages that refuse to send to messages that appear to send but never arrive. We will be troubleshooting using SQL profiler and some DMV’s to see what goes on in the background when service broker is misbehaving. Nothing more worrying than performing a disaster recovery and having service broker messages not send. We will also be doing a quick overview of what Service broker does and what is required for a service broker setup and some post restore troubleshooting. Once we have shown the profiler method of diagnosing problems, I will show a quicker and easier way to find and resolve most service broker issues.

About Brian:
Brian Gale is a DBA at Vecima Networks and has been in this position for approximately 8 years. He experience has been in query optimizing, random troubleshooting and administration of SQL Server. In his administrative tasks, he has been required to learn about various SQL things and currently is focusing on Service Broker and Query Store.


Upcoming PASS Sponsored Events:



  • 24 hours of PASS - here

    PASS BA Days - here
    BA Marathon - herePASS affiliated conferences - here

    And can't forget SQLSaturday (aka mini-Summit) - here

    Back to Top