Session
Deep dive into SQL Storage Architecture, for People in a Hurry!
This talk is specific to SQL Server and it's storage engine. BUT, don't be fooled by it! Inner workings of most of the popular relational DBs (SQL Server, MySQL, PostgreSQL, etc.) are more or less similar (almot the same)!
Here are just SOME of the things that I will be covering:
- What happens when you issue a CREATE DATABASE command
- How is data stored on your disk
- What is write-ahead logging
- What are Pages and how do they work
- What is a Buffer Pool and why it's important
- How to squeeze maximum performance out of your DB design
- How indexes work and what are B+ and B- Trees at all
And if you're thinking this is only for DB Admins - you're quite wrong! Knowing the internals of your DB engine allows you to squeeze out the best of the best out of it!
Mihailo Joksimovic
Senior Software Engineer @ Microsoft
Belgrade, Serbia
Links
Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.
Jump to top