Abstract:
Are you a relative newcomer to T-SQL and want to get into performance tuning? Or maybe you just want to expand your knowledge of hidden performance killers?
Then join Deborah and Andy for a survey of worst practices that kill performance, focusing on T-SQL development practices. In this demo-filled session, we will cover a mix of T-SQL development practices, suitable for anyone who writes T-SQL!
When you leave, you’ll be armed with knowledge and tools to get a jump start on your journey to specializing as a performance tuner.
Bios:
Deborah Melkin has been working as a database professional with SQL Server for over 20 years. She spends her days helping programmers with all aspects of database design, queries, performance, and deployment. In 2016, she began her blog, Deb the DBA. Soon after that, she began speaking at SQL Saturdays and user groups. Deborah is a board member of the New England SQL Server User group (NESQL). She is an IDERA ACE Class of 2020 and won Speaker Idol at PASS Summit 2019. Deborah is also a recently awarded Microsoft MVP for the Data Platform.
In her spare time, Deborah can usually be found doing something musical.
——-
Andy Yun is a (soon to be) Pure Storage Field Solutions Architect and a former Microsoft MVP. He has been working with SQL Server for nearly 20 years as both a Database Developer and Administrator. Leveraging knowledge of SQL Server Internals and extensive experience in highly transactional environments, he strives to make T-SQL leaner and meaner. Andy is extremely passionate about passing knowledge onto others, regularly speaking at User Groups, SQL Saturdays, and PASS Summit. Andy is a co-founder of the Chicago SQL Association, former co-Chapter Leader of the Chicago Suburban User Group, and part of the Chicago SQL Saturday Organizing Committee.