The TriPass group in Raleigh, NC has started a Special Interest Group on Advanced DBA Topics. This means we are looking for talks at a level 300 and above. Our group will normally meet the second Tuesday of the month at 6PM Eastern Standard Time. Our ambition is to have 50% female speakers. With PASS membership only being 20% female this will be a high bar to meet so we will need help to meet this goal. With the technical depth of the talks the group will be covering, we realize a lot of the speakers will be presenting remotely, which we fully set up to do. So if you are interested in speaking for this group (male or female) please email me.

To RVSP for these events join our Meetup group and watch out for the invites.

Loading Events

« All Events

Using Extended Events to Expose Application Performance Issues by Mindy Curnutt

October 10 @ 18:00 - 20:00

When an application is performing poorly, the database is almost always suspected to be the source of the problem. Not so fast! In this session, learn how to use Extended Events in three different ways.

  1. The traditional “long running query” identification.
  2. The “thousand paper cut” diagnosis.
  3. Reading BETWEEN the lines to determine what is missing.

The final method, analyzing the space BETWEEN calls to the SQL Server is a non-traditional technique that can be used to identify where an application is actually the source of a performance issue and not the SQL Server.

In this session, we’ll go over all three. I’ll show you how to script each using Extended Events and Profiler Server Side traces.

Mindy Curnutt is 4X Microsoft Data Platform MVP and Idera ACE. She has been actively involved in the SQL Server Community for over a decade, presenting at various User Group Meetings, SQLPASS Summits, as well as SQLSaturdays across North America. For two years, she was a Team Lead for the SQLPASS Summit Abstract Review Process and since 2015 has served as one of the 3 SQLPASS Summit Program Managers. She was a SME for a couple of the SQL 2012 and 2014 Microsoft SQL Server Certification Exams and helped to author the MS Press Book “SQL Server 2014 – Step by Step” and is currently working on “SQL Server 2017 Inside Out”. She serves on the Board of Directors for the North Texas SQL Server User’s Group.

Mindy serves as a mentor to others, helping to educate and promote scalable and sustainable SQL Server architecture and design. She is passionate about Data Security, Accessibility, Usability, Scalability and Performance. Mindy Curnutt is an Independent Consultant. You can follow Mindy at her blog, mindycurnutt.com and on Twitter where she’s known as @sqlgirl.

Tracy Boggiano
Follow me

Tracy Boggiano

Database Superhero at ChannelAdvisor
Tracy has spent over 20 years in IT and has been using SQL Server since 1999 and is currently certified as a MCSE Data Management and Analytics. She has worked on SQL Server 6.5 and up including currently SQL 2017 RC1. She enjoys monitoring, performance tuning, and high availability and disaster recovery technologies. Tracy is currently a co-organizar the for special interest group for Advanced DBA Topics for the TriPASS user group.

She also tinkered with databases in middle school to keep her sports card collection organized.

Tracy has volunteered through the NC Guardian ad Litem program since 2003 advocating for abused and neglected foster children in court.This is her passion outside of SQL Server and favorite job.More information about this program in North Carolina can be found at http://volunteerforgal.org or the national organization CASA at http://www.casaforchildren.org.
Tracy Boggiano
Follow me

Details

Date:
October 10
Time:
18:00 - 20:00

Venue

ChannelAdvisor
3025 Carrington Mill Blvd
Morrisville, NC United States
+ Google Map

Leave a Comment