A Query Runs Through It: An Introduction to the SQL Server Engine - Peter Shore
Details
Note: This is an online meeting via Zoom. To attend:
- RSVP for this event on Meetup.
- Use the Zoom link to attend the meeting.
- If you need help joining the Zoom meeting from any device, visit the help page linked at the bottom of this meeting description.
A Query Runs Through It: An Introduction to the SQL Server Engine - Peter Shore
Abstract:
A query is executed, results are returned. Have you ever wondered what happens behind the scenes once the query is started? Pull back the curtain with this introduction to SQL Server internals.
Have you ever wondered what happens inside SQL Server when you execute that query you wrote? This session will serve as an introduction to what is going on under the hood, commonly called SQL Server Internals. Whether writing queries or tuning them, SQL Server internals knowledge is highly valuable in Azure VMs or SQL DB, AWS, GCP, and on-premises as the SQL Server engine is the same. Together we will dip into why data types matter, ponder pages, sample the storage engine, and ponder the query processor as we see what happens when your query runs.
Bio:
Peter is a seasoned IT professional with over 25 years of experience, a frequent speaker at SQL Saturday, User Groups, and other conferences. He took the DBA plunge in 2013 quickly embracing the Microsoft Data Platform and associated community. Peter is comfortable working with physical, virtual, and Azure implementations of SQL Server focusing on improving performance and reliability. He is also adept at bridging the gap between technical and business language in order to bring technology solutions to business needs. Additionally, Peter is the president of CBusData in Columbus, Ohio and co-organizer of SQL Saturday Columbus.
You can find Peter on Twitter:
Twitter: https://twitter.com/pshore73
Sacramento SQL Server User Group:
https://www.meetup.com/Sacramento-SQL-Server-User-Group
https://twitter.com/sacsqlug
https://www.linkedin.com/groups/2825448
Zoom help for joining meetings:
https://support.zoom.us/hc/en-us/articles/201362193-Joining-a-Meeting
