Webinar:

SQL Server Internals & Architecture

Summary:

Let’s face it. You can effectively do many IT jobs related to SQL Server without knowing the internals of how SQL Server works.  Many great developers, DBAs, and designers get their day-to-day work completed on time and with reasonable quality while never really knowing what’s happening behind the scenes.  But if you want to take your skills to the next level, it’s critical to know SQL Server’s internal processes and architecture.  This session will answer questions like: 

  • What are the various areas of memory inside of SQL Server? 

  • How are queries handled behind the scenes? 

  • What does SQL Server do with procedural code, like functions, procedures, and triggers? 

  • What happens during checkpoints?  Lazywrites? 

  • How are IOs handled with regards to transaction logs and database? 

  • What happens when transaction logs and databases grow or shrinks? 

This fast paced session will take you through many aspects of the internal operations of SQL Server and, for those topics we don’t cover, will point you to resources where you can get more information.  So strap on your silly, as we cover all these topics and more at speed with tongue planted firmly in cheek!  

Interested in additional SentryOne webinars?  Check our webinar library.

Available On Demand


Already Registered?
Kevin Kline

Kevin Kline

Principal Program Manager, SentryOne

Kevin (@kekline) serves as Principal Program Manager at SentryOne. He is a founder and former president of PASS and the author of popular IT books like SQL in a Nutshell. Kevin is a renowned database expert, software industry veteran, Microsoft SQL Server MVP, and long-time blogger at sentryone.com/blog/author/kevin-kline. As a noted leader in the SQL Server community, Kevin blogs about Microsoft Data Platform features and best practices, SQL Server trends, and professional development for data professionals.

Companies with the highest demands for database performance choose SentryOne