Next week on Wednesday is the Calgary Data User Group’s second event for 2021, and the second event as a member of Microsoft’s new Azure Data Community. Since last year February we have been offering two sessions per event, with the opportunity for a lightning session (15 minutes) as well as the regular-length session (60 minutes).
We’re flipping the script with this month’s session though, as the feature session will run first, and the lightning talk will be presented as an epilogue.
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.
About Deborah Melkin
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 should expand 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 yourself (or your tools) a headache.
About Andy Yun
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.