October 2020 - SQL Engine: Its Working Style by Deepthi Goguri (@dbanuggets)
Abstract:
Many DBAs and Developers work with SQL Server but don’t fully understand how it really works behind the scenes. Join Deepthi on her dive into the internals of SQL Server to explain why knowing what goes on under the covers will help you make better decisions quickly when solving performance problems in SQL Server. This session will cover ACID properties, key components of the Cache in SQL Server, Relational Engine, Storage engine and the Transaction manager. You will learn how SQL Server manages Plan cache and Buffer pool and how SQL Server optimizer choose the plans. We will also cover what happens under the covers during read and write operations within SQL Server. This session also has Demos showing how components of SQL Engine works for queries. Deepthi will show you how the SQL engine thinks – enabling you to think like it!
About Deepthi:
Deepthi is a Database administrator with 7 years of experience. She completed her Masters in Computer Technology at Eastern Illinois University and she is a Microsoft certified solution expert (MCSE). You can find her blog at dbanuggets.com and follow her on twitter: @dbanuggets
-
LIVE
LumpyPotatoX2
1 hour agoFortnite Friday on Rumble - #RumbleTakeover
562 watching -
LIVE
Nina Infinity
21 hours agoGOOD NEWS - Infinite Hope # 193
413 watching -
1:58:06
Barstool Yak
4 hours agoThe Yak with Big Cat & Co. Presented by Rhoback | The Yak 7-12-24
5.07K -
1:19:55
The Quartering
2 hours agoBiden's GAFFS At Big Boy Press Event, Disney Exposed,
12.3K15 -
2:02:50
Film Threat
23 hours agoTHEATERS ARE DYING! SO LET'S SEE FLY ME TO THE MOON | Film Threat Livecast
4.07K2 -
51:29
Ben Shapiro
3 hours agoEp. 2003 - More Brutal Biden FLUBS…But He LIVES To Fight Another Day
25.8K24 -
1:20:49
Russell Brand
4 hours agoThe Battle of Good and Evil: Bishop Barron EXCLUSIVE Interview - SF 406
84.9K160 -
53:57
The Dan Bongino Show
5 hours agoBoth Trump And Biden Are Celebrating Last Night’s Debacle (Ep. 2285) - 07/12/2024
463K1.02K -
1:25:07
Benny Johnson
4 hours ago🚨Biden Throws Unhinged Tantrum On LIVE-TV, Calls Trump is His 'Vice President' in CAR CRASH Presser
70.8K109 -
47:53
Tactical Advisor
3 hours agoNew Metal Frame M&P 2.0 Release - Vault Room Live Stream
32.6K8