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
-
27:35
NordicVentures
7 days ago3 Days Solo on a Island: How to Build a Simple Beach Shelter!
8451 -
1:46:49
Survival Dispatch
6 days agoThe REAL Truth About Media's Terrorism Coverage vs Reality EP534
2.9K3 -
1:05:12
Greg Hunter's USAWatchdog.com
20 hours ago100% Chance of Nuclear War – Martin Armstrong
51.5K39 -
2:21:13
Tundra Tactical
15 hours ago $5.87 earned"The World's Okayest Gun Live Stream: Reloading Series Announcement & ATF Pistol Brace is Dead
41.8K3 -
45:12
TheCommonSenseShow
2 days agoCONTRIBUTE AND PROFIT FROM THE NEW DOMINANT MEDIA- SAM ANTHONY
1.46K -
1:23:15
Sports Wars
3 hours agoWNBA Players EMBARRASS Themselves At All Star Game, UFC 318, MLB All Star Game Heroics
20.7K3 -
9:43
MattMorseTV
1 day ago $94.38 earnedTulsi just DROPPED a BOMBSHELL.
175K360 -
LIVE
TheItalianCEO
3 hours agoVideo games on a Sunday
233 watching -
1:15:42
The Connect: With Johnny Mitchell
1 day ago $23.93 earnedHow Did This Happen? Male Escort Who Testified Against Diddy Exposes LIES About Government's Case
95.9K20 -
LIVE
SwitzerlandPlayIT
3 hours ago🔴 GHOST OF TSUSHIMA - Honor The Tardis!
53 watching