You are purchasing a ticket for an exclusive SQL Saturday #201 Pre-Conference. This event will be a all-day Pre-Conference titled "SQL Server Internals - A Practical Angle" by Dmitr Korotkevitch.
Your ticket includes the following:
- All training during the day
- Access to training materials
- Validated Parking
- Continental Breakfast
- Afternoon Snacks
This Pre-Conference will cover the following topics:
There are plenty of the books and resources about SQL Server internals. While they provide the great
overview of how product works, they often lack the practical angle and don’t explain how to apply that
knowledge to real-life scenarios. That pre-con helps to close that gap. It shows how various aspects of
SQL Server Internals affect the systems and what needs to be taken into consideration during design and
The pre-con covers how SQL Server stores the data and works with indexes; how to design efficient
indexing strategies; how different database objects types implemented internally and what are pros
and cons of them; explains why do we have locking and blocking in the system and how to deal with
concurrency issues and, finally, shows a few methods that can help with performance troubleshooting
of the system.
Dmitri Korotkevitch is Microsoft SQL Server MVP and Microsoft Certified Master who is working with
Microsoft SQL Server for more than 11 years. He specializes in architecture, design, development
and performance tuning of OLTP systems and responsible for implementation of several database
backends handling thousands of transactions per second around the clock. Dmitri has Master’s degree in
Computer Science and also held MCPD certificate.