Next Meetup

NTSSUG JUNE MEETING - A Case for Change: Identifying & Remedying Bad Code
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. Presenter: Amy Herold Amy is the Director of Programs for NTSSUG and specializes in PowerShell and automation. 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. You follow her on twitter @texasamy. Meeting starts: 6:00 pm with food and mingling Announcements & Ask the Experts: 6:30 pm to 7:00 pm Presentation: 7:00 pm to 8:00 pm When: Thursday, April 19, 2018 Address: Microsoft Las Colinas Offices 7000 North Highway 161 , Building LC-1 Irving Texas 75039 Map: https://goo.gl/maps/h9aWDZ6Z3wK2

Microsoft Building LC-1

7000 North Highway 161 · Irving, TX

    Past Meetups (38)

    What we're about

    The North Texas SQL Server Users Group was formed to provide a forum where Microsoft SQL Server database administrators and developers could meet to learn more about the product, share ideas and make contact with other similar individuals. It is our goal to provide new concepts and detailed information on the product which will enable the users of SQL Server to see it function to its fullest potential. The content of the meetings will vary, but is usually targeted at average to advanced users; however, we openly welcome anyone interested in SQL Server regardless of experience or level of expertise. This is a great opportunity to learn about SQL Server and network with other DBAs and developers! The meetings are free and open to anyone who is interested in sharing their knowledge of SQL Server. Pizza and drinks are provided.

    http://northtexas.sqlpass.org

    Members (1,133)

    Photos (40)