Beyond the Basic SELECT - Deborah Melkin

Agenda:

5:00pm - 5:10pm: Welcome and messages
5:10pm - 6:10pm: Feature session (Deborah Melkin)
6:10pm - 6:25pm: Q&A with Deborah
6:25pm - 6:30pm: Break
6:30pm - 6:45pm: Lightning session (Andy Yun)

--

Beyond the Basic SELECT (Deborah Melkin)

The SELECT statement is one of the most used tools in our SQL toolbelt. While it's the basis for what we do with data, it's anything but basic. In this presentation, we will first explore how SELECT statements are processed. Then we will discuss various ways we build on to our SELECTs. We'll also examine how and why we may or may not want to use them. At the end of the session, we will have a greater understanding of how SELECTS work and how we can approach them so we can be smarter as we write more complex statements.

Deborah 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.

--

Epilogue (Andy Yun)

Now that you're expanding how you think about your SELECT statements, you have to expand about how you think about the query optimizer. Stick around as Andy Yun demystifies the query optimizer so you can leverage your new T- SQL tools without giving it a headache.

Andy is a SentryOne Principal Solutions Engineer 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.