North Texas SQL Servers Users Group

Next Meeting

Thursday,

June

21

NTSSUG - 21 JUNE 2018 Meeting Notice

  • In-Person @ 7000 North Highway 161 Irving, Texas, United States (map)
  • 18:00 - 20:00 Central Daylight Time
  • Language: English

RSVP Here: https://www.meetup.com/North-Texas-SQL-Server-User-Group/events/251736222/

MONTHLY NEWSLETTER
JUNE 2018 USER GROUP MEETING

Topic:The Case for Change: Identifying and Remedying Bad Code

Abstract:There is no organization that is immune from performance issues with their SQL Server queries. Sometimes all it takes is one "perfect storm" that kills your server performance and lands you in the hot seat with everyone asking you what happened. While many performance issues can be addressed with an index or configuration change, what about when the root of the problem is the code itself? Whether it's a stored procedure or dynamic T-SQL generated by an ORM, the burden of proof lies with the DBA to demonstrate how the code is negatively impacting performance.

How do you capture those bad queries? When you have this data what do you look at besides the query itself? How do you make the case to the business that a code change is necessary? In this session we will explore capturing and identifying those problem queries, the analysis of the performance data, and how to effectively communicate your findings to the business to get your proposed code change approved and implemented.


Speaker: Amy Herold

Meeting starts:6:00 pmwith food and Mingling
Announcements & Ask the Experts:6:30 pm to 7:00 pm
Presentation:7:00 pmto 7:45 pm

When:Thursday, June 21, 2018

Address:
Microsoft Las Colinas Offices
7000 North Highway 161 , Building LC-1
Irving Texas 75039
Map:https://goo.gl/maps/h9aWDZ6Z3wK2

Our meeting this month is sponsored by SentryOne!

Featured Presentation:

The Case for Change: Identifying and Remedying Bad Code

Amy Herold, Sr. Database Administrator One Technologies

There is no organization that is immune from performance issues with their SQL Server queries. Sometimes all it takes is one "perfect storm" that kills your server performance and lands you in the hot seat with everyone asking you what happened. While many performance issues can be addressed with an index or configuration change, what about when the root of the problem is the code itself? Whether it's a stored procedure or dynamic T-SQL generated by an ORM, the burden of proof lies with the DBA to demonstrate how the code is negatively impacting performance. How do you capture those bad queries? When you have this data what do you look at besides the query itself? How do you make the case to the business that a code change is necessary? In this session we will explore capturing and identifying those problem queries, the analysis of the performance data, and how to effectively communicate your findings to the business to get your proposed code change approved and implemented.

About Amy:
Amy Herold is currently a Sr. Database Administrator with One Technologies in Dallas, specializing in PowerShell and automation. She is also currently the Director of Programs for the North Texas SQL Server User Group (NTSSUG). She frequently speaks at SQL Saturday and user group events across the United States and has also participated in numerous Women in Technology sessions as a panelist. Amy currently blogs at sqlkitten.com.


Thank You to the 

PLATINUM

SPONSORS 

of our May 2018 

SQL Saturday!











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