|Title:||SQL Server Internals from the Practical Angle|
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 implementation stages.
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.
Audience will be provided with the sample database and set of the scripts that emulates OLTP activity. There will be a few problems involved, such as non-optimized queries and inefficient indexing; locking; inefficient DB schema; and a few others. Audience would be asked to pin-point and fix as much problems as possible.
In addition to that, I’ll ask audience (during session overview and lunch break) about additional topics they would like to discuss. I’ll cover as much of them as possible during that time slot using either my other presentation decks or whiteboard.
|SQL Speaker:||Dmitri Korotkevitch|
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.
When & Where
Denver SQL Server User Group
SQLSaturday #441 is being held on Saturday, September 19th at The Summit Event Center, registration to Saturday is separate from these pre-cons and is required if you plan to attend the Saturday sessions. Please register at http://denversqlsaturday.com.
The Denver SQL Server User Group is organized to bring professionals of all career levels that work with Microsoft's SQL Server, together to learn and network with others. There is no charge to attend and you are encouraged to bring your co-workers. Through our sponsors, we provide food and refreshments.
We meet every third Thursday of each Month at Microsoft DTC (7595 Technology Way, Suite 400, Denver, CO 80237).
Visit http://denversql.org for more information and to create a free account.