Kalen Delaney: What the Hekaton!? A Whole New Way to Think About Data Mgmt

SQL Saturday #285 - Atlanta

Friday, May 2, 2014 from 9:00 AM to 4:30 PM (EDT)

Alpharetta, GA

Kalen Delaney: What the Hekaton!? A Whole New Way to Think...

Ticket Information

Ticket Type Remaining Sales End Price Fee Quantity
Preconference Session Ticket   more info 26 Tickets May 1, 2014 $149.00 $0.00

Who's Going

Loading your connections...

Share Kalen Delaney: What the Hekaton!? A Whole New Way to Think About Data Mgmt

Event Details

Why concurrency matters for performance, and how In-Memory OLTP can drastically improve yours

SQL Server Hekaton, Microsoft’s new In-Memory table technology being shipped as part of SQL Server 2014, will completely change the way you think about concurrency and data management. Concurrency problems are one of the top three performance issues that all applications have to deal with.

In this full-day seminar, Kalen Delaney (a SQL Server MVP for over 20 years) will show you how SQL Server 2012 manages concurrent operations to understand where there is room for improvement.  We’ll look at the completely new data structures for In-Memory OLTP to see how SQL Server 2014 can provide lock-free and latch-free data processing.

This session we’ll discuss what gets written to disk during checkpoints, as well as what gets logged. Kalen will explain how the recovery process recreates your Hekaton tables. Finally, she’ll go into detail on just what it is that makes Hekaton so much FASTER!

Our planned agenda:
  • Why Hekaton?
  • Concurrency Control in SQL Server 2012
    • o    Isolation Levels
    • o    Pessimistic vs Optimistic Concurrency
    • Locking and Blocking
    • Snapshot Isolation
  • In-Memory Data Structures
    • Rows
    • Hash Indexes
    • Range Indexes
  • Data Access
  • Performance Benefits
    • No latching
    • No locking
    • No query interpretation
  • Managing Memory
    • Space Requirements
    • Garbage Collection
  • Persistence and Storage Management
    • Checkpoint Files
    • Logging
    • Recovery
  • Planning for Hekaton

Kalen DelaneyKalen Delaney has been working with SQL Server for over 26 years, and provides performance consulting services as well as advanced SQL Server training to clients around the world, using her own custom-developed curriculum. She has been a SQL Server MVP since 1993 and has been writing about SQL Server almost as long. Kalen has spoken at dozens of technical conferences, including almost every US PASS conference since the organization’s founding in 1999. Kalen is a contributing editor and columnist for SQL Server Magazine and the author or co-author of several of the most deeply technical books on SQL Server, including SQL Server 2012 Internals. Kalen blogs at www.sqlblog.com and her personal website and schedule can be found at www.SQLServerInternals.com

Lunch will be provided and is included in your ticket price.

IMPORTANT: Registration for a precon session does NOT include registration for SQL Saturday on May 3 - please register here (it's free!) for Saturday's event.

Have questions about Kalen Delaney: What the Hekaton!? A Whole New Way to Think About Data Mgmt? Contact SQL Saturday #285 - Atlanta

When & Where



Georgia State University - Alpharetta Campus
3775 Brookside Pkwy
Alpharetta, GA 30022

Friday, May 2, 2014 from 9:00 AM to 4:30 PM (EDT)


  Add to my calendar

Organizer

SQL Saturday #285 - Atlanta

Organized by AtlantaMDF (Atlanta chapter of SQL PASS), SQL Saturday Atlanta set an attendance record in 2013. The Atlanta SQL Server community attracts world-class speakers for event sessions as well as full-day pre-conference training.

  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.