Chicago Suburban SQL Server User Group

Welcome

MEMBERSHIP

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:

http://www.sqlpass.org/PASSChapters/LocalChapters.aspx

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

Tuesday,

September

17

September Meeting

  • In-Person @ 3025 Highland Pkwy Downers Grove, Illinois, United States (map)
  • 18:00 - 20:00 Central Daylight Time
  • Language: English

AGENDA:
5:30PM - Doors Open
6:00PM - Meeting Start with Dinner, Networking, & Open Q&A (bring your questions!)
6:30PM - Announcements, Sponsor Presentation, & Main Presentation

TITLE:
Diagnosing and fixing deadlocks in SQL Server

ABSTRACT: 
You know how locking works in SQL Server, but now you are tasked with diagnosing and fixing deadlocks. How do you take the knowledge you have and apply it to address deadlocks in your production database?

In this session, we will discuss how you can use free tools to detect and analyze deadlocks in your system. We will do a deep dive on deadlock XML with an eye toward interpreting the information automatically collected by SQL Server when the free tools fall short. 

Attendees will leave with the understanding they need to develop solutions to deadlocks in their systems.


SPEAKER BIO:
Jake has been a T-SQL developer since 2013, starting after he jumped ship from an academic life as a mathematics professor to the software industry. He focuses on solving difficult concurrency problems, large scale data warehouse ETL processes, data conversions, and understanding SQL Server optimizer behavior.

 

Featured Presentation:

Diagnosing and fixing deadlocks in SQL Server

You know how locking works in SQL Server, but now you are tasked with diagnosing and fixing deadlocks. How do you take the knowledge you have and apply it to address deadlocks in your production database? In this session, we will discuss how you can use free tools to detect and analyze deadlocks in your system. We will do a deep dive on deadlock XML with an eye toward interpreting the information automatically collected by SQL Server when the free tools fall short. Attendees will leave with the understanding they need to develop solutions to deadlocks in their systems.

Jake Manske, Software Developer Epic

About Jake:
Jake has been a T-SQL developer since 2013, starting after he jumped ship from an academic life as a mathematics professor to the software industry. He focuses on solving difficult concurrency problems, large scale data warehouse ETL processes, data conversions, and understanding SQL Server optimizer behavior.

REGISTER:

https://www.eventbrite.com/e/chisub-ssug-sept-meeting-tickets-72087929939

Supplementary Materials

The following event attachments are available to you:





PASSChapterLogo100.jpg


sql_micro_sm.gif







Andy Yun
E-Mail: SQLBek@gmail.com
Twitter: @SQLBek

Lowry Kozlowski
E-Mail: lowrykoz@gmail.com
Twitter: @lowrykoz

Chapter E-Mail: 
chisuburbanssug@sqlpass.org

 

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