Select Page

Note: We’re meeting one week early due to the PASS Virtual Summit 2020 being on the following week. We’ll be online starting at 6pm for socializing, and the session will start at 6:30. We look forward to seeing you there.

Title: The SQL Engine: Its working style.
Speaker: Deepthi Goguri

This session is mainly focus on anyone who works with SQL Server including DBA’s and Developers. We will dive deep into each and every comonent inside SQL Engine. For example, If you are running a select statement or data modification statement, what actually happens behind the scenes at each step inside SQL Engine. How SQL Server handle queries and how execution plans are choosen. What are the Trivial plans and when do SQL Server choose trivial plans. How many cominents of cache we have in SQL Server. We go deep into how the plan cache and buffer pool are maintained. This is the intermediate level of SQL Server Internals. After attending this session, you will be able to understand how the optimizer chooses the execution plans, how caches are managed, how each component inside relational engine, storage engine works, how optimizer chooses the execution plans.

In her own words:
I am a Database administrator with 7 years of experience. I am a Microsoft certified solution expert (MCSE). I completed my Masters in Computer Technology at Eastern Illinois University. I blog for