This event has ended

SQL Saturday #190 Pre-Con w/Dmitri Korotkevitch

Denver SQL Server User Group

Friday, September 27, 2013 from 9:00 AM to 5:00 PM (MDT)

Englewood, CO

SQL Saturday #190 Pre-Con w/Dmitri Korotkevitch

Ticket Information

Ticket Type Remaining Sales End Price Fee Quantity
SQL Server Internals from the Practical Angle (Early Bird) 17 Tickets Ended $99.00 $3.47

Who's Going

Loading your connections...

Share SQL Saturday #190 Pre-Con w/Dmitri Korotkevitch

Event Details

Title: SQL Server Internals from the Practical Angle
Abstract:

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. 

Plan
  • Introduction and Session overview
  • Tables and Indexes
    • Internal Structure
    • When and How SQL Server uses indexes
    • Index and Statistics maintenance 
    • Indexing strategies and performance considerations
    • Index tuning
  • Database objects (Constraints, Views, Triggers, Functions, etc.)
    • Internal implementation
    • Pros, cons and use-cases
  • General system design considerations 
    • Data Access Tier design
    • ORM frameworks in general
  • Locking, Blocking and Concurrency
    • Lock types and compatibility
    • Why we have locking and blocking in the system
    • Locking and deadlocks troubleshooting
    • Designing transaction strategies
  • Query Execution 
    • Overview of Query life cycle
    • Compilation and recompilation, Plan Cache, Plan Reuse, Parameter sniffing
    • Ad-hoc and Dynamic SQL
  • Practical Troubleshooting
    • SQLOS & SQL Server Execution Model
    • Wait Statistics 
    • Wait Types and performance counters overview and correlation with possible issues in the code
    • Useful DMVs
  • Workshop, Q&A and Open talk 
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

Speaker Bio:

 

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.

Have questions about SQL Saturday #190 Pre-Con w/Dmitri Korotkevitch? Contact Denver SQL Server User Group

When & Where


Cherry Creek Presbyterian Church - Community Life Center
10150 E. Belleview Ave.
Englewood, CO 80111

Friday, September 27, 2013 from 9:00 AM to 5:00 PM (MDT)


  Add to my calendar

Organizer

Denver SQL Server User Group

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.

  Contact the Organizer

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.