Im Rahmen unserer 2-wöchentlichen Data Platform Herbstgesprächen präsentieren Experten in Live Webcasts aktuelle technologische Themen und Lösungen in der Praxis rund um Azure Data Services, Power BI und SQL Server Technologie.
Im kommenden Webcast am Mittwoch, 16. Dezember ab 17 Uhr haben wir das folgende Thema vorbereitet:
SQL Server Internals and Architecture
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!
Presented by Deepthi Goguri, Database administrator @ Intone Networks Inc