Chicago Suburban SQL Server User Group



If you have not done so already, please register on PASS.  Then update your PASS Profile & Join our Chapter there. All future mailings will be sent out via your SQLPass account:

Quick Search on "Chicago Suburban SQL Server User Group" and make sure you are registered as a member.  Doing so will ensure that you will receive future e-mails from us.

Next Meeting




Chicago Suburban SQL Server User Group - January 15, 2019

  • In-Person @ 3005 Highland Parkway #100 Downers Grove, Illinois, United States (map)
  • 05:30 - 07:30 (UTC-06:00) Central Time (US & Canada)
  • Language: English

Happy New Year everyone,


This announcement is about our January 15thth Meeting. We are honored to have David Bland talk about SQL Server Extended Events and how to find Performance Bottlenecks as our first meeting of the year.


Chicago SQL Saturday.

Saturday, March 23, 2019. This year, we will be at Benedictine University in Lisle, IL.  The event is live, register here.

PRECON Sessions:


Lowry Kozlowski & Andy Yun
Chicago Suburban SQL Server User Group



DATE: Tuesday, January 15, 2019

SPEAKER:  David Bland

TOPIC:  SQL Server Extended Events and how to find Performance Bottlenecks


DeVry University
3005 Highland Parkway #100,
Downers Grove, IL 60515

5:30PM - Doors Open
6:00PM - Meeting Start w. Announcements
6:15PM - Dinner w. Networking/Open Q&A (bring your questions!)
6:45PM - Main Presentation


Dave has a degree in education from Western Illinois University and has worked as a band director for grades 5 -12 and managed group homes for individuals with disabilities for 12 years.  For the last 20 years Dave has worked in the technology field with over 15 years of SQL Server DBA experience working with all versions since SQL Server 2000.  He has experience as a BI developer and Application developer using VB.NET.  Dave currently supervises the Shared Services DBA team at Stericycle.  He has also worked as a DBA in the casino industry, insurance industry as well as the transportation industry.  He is a frequent presenter at SQL Saturday events throughout the Midwest. Has been teaching SQL Server since version 2000 and currently is the SQL Server instructor at Harper College in Palatine, IL. Dave currently holds 13 certifications including the following: • Microsoft Certified Trainer since 1998 • MCTS: SQL Server 2008, Implementation and Maintenance • MCTS: SQL Server 2008, BI Development and Maintenance • MCSA: SQL Server 2008 • MCSA: SQL Server 2012\2014 • MCSE: SQL Server 2012\2014 - BI • MCDBA: SQL Server 2000 • MCSD  • MCSE: Data Management and Analytics and A+.



Extended Events were first introduced in SQL Server 2008 and have evolved with each version.  This session will review how Extended Events can be used to find performance bottlenecks.  We will cover how to capture and read information about deadlocks, long running queries, query timeouts, execution plan warnings as well as the capture of execution plans.  This session will include a brief overview of XEvent Profiler SSMS feature and a few surprises!





Andy Yun
Twitter: @SQLBek

Lowry Kozlowski
Twitter: @lowrykoz

Chapter E-Mail:


Back to Top