Premium Only Content

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
The Connect: With Johnny Mitchell
9 hours ago $0.11 earnedOne Man's Mission To Stop Human Trafficking: How A Billionaire Mercenary Saved Hundreds Of Children
399 watching -
LIVE
Tundra Tactical
4 hours ago $0.07 earned🔫 California Ammo Win, Sig Sauer P320 Controversy, Meme Review & Would You Rather! 🎉🔥
407 watching -
16:24
Forrest Galante
2 hours ago6 Deadliest Man Eaters to Ever Exist
9.68K1 -
10:14
MattMorseTV
7 hours ago $0.34 earnedThe EU is in HOT WATER.
67.9K37 -
LIVE
The Rabble Wrangler
1 day agoPUBG with The Best in the West!
120 watching -
3:57:19
EvilT4000
5 hours agoSaturday.....🟢For energy and focus click my Dubby link!
9.32K1 -
LIVE
SlingerGames
1 hour agoSpartan Night - Halo and More | Creator for @SELFMADEGGS
45 watching -
3:57:49
Mally_Mouse
7 hours agoSpicy Saturday!! - 10k CELEBRATION! - Let's Play: Labyrinthine
25.2K1 -
37:09
The Mel K Show
8 hours agoMel K & Dr. Kirk Moore | A Doctor’s Oath: Doing What is Right No Matter the Cost | 7-26-25
26.7K10 -
LIVE
Cewpins
2 hours agoLet's BLAZE!!🔥SmokeSesh💨420🍃!MJ
48 watching