• Nov 2020 | SQL Engine: Its Working Style
    Join us on Wednesday, November 18, 2020 at 5:30 PM CST for another virtual BRSSUG meeting! In this meeting Deepthi Goguri will pull the curtain back on the SQL engine and show you how it thinks.

    Link to the Meetup Event
    Link to the YouTube Livestream

    ---

    SQL Engine: Its Working Style

    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 chooses 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!

    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

    ---

    Check out our YouTube channel
    Posted Nov 8, 2020, 4:26 PM by Bedford Nieves-Sanchez
Showing posts 1 - 1 of 125. View more »

SQLSaturday Baton Rouge Event History

2019 

Aug 17 

#867    

2018 

Aug 11 

#749    

2017 

July 29 

#628    

2016 

Aug 6 

#515

2015

Aug 1 

#423

2014

Aug 2

#324

2013

Aug 3

#234

2012

Aug 4

#150

2011

Aug 6

#64

2010

Aug 14

#28

2009

Aug 1

#17