SQLBits 2015

Going Asynchronous with Service Broker

This session will explain the benefits of asynchronous processing in Service Broker compared to other options like SQL Agent jobs or SSIS packages, and how to implement the basic components required.

Do you have complex operations that have already been tuned for optimum performance, but still run too long for a good end user application experience? If you do, Service Broker may be the solution. This session will explain the benefits of asynchronous processing in Service Broker compared to other options like SQL Agent jobs or SSIS packages, and how to implement the basic components required. Even in SQL Server 2014, Service Broker lacks a UI integration. Not to worry, this session will show you how to configure Service Broker correctly the first time so you can develop easy, foolproof deployments to solve complicated problems.

Jonathan Kehayias's previous sessions

This session will explain the benefits of asynchronous processing in Service Broker compared to other options like SQL Agent jobs or SSIS packages, and how to implement the basic components required.

Deadlocking for Mere Mortals

This session will look at the most common deadlocks asked about on the forums, and how to troubleshoot them using the various methods available to DBA’s in SQL Server; including Trace Flags, SQL Trace, Event Notifications, and Extended Events.

Opening the SQL Server 2008 Toolbox - An Introduction to Extended Events

Extended Events offer a refreshing new way of troubleshooting problems with SQL Server 2008. This session will focus on how to create custom sessions using the available events, targets and actions available in the Extended Events metadata. It will cover how to use the default system_health session to perform initial troubleshooting, as well as how to use the Extended Events Manager to simplify creating Extended Event Sessions and accessing the information captured in the session targets.