Skip Main Navigation
Page Content
This event has ended

What the Hekaton! SQL Saturday #312 Sacramento Precon with Kalen Delaney

Sacramento SQL Server Users Group

Friday, July 11, 2014 from 8:30 AM to 4:30 PM (PDT)

What the Hekaton! SQL Saturday #312 Sacramento Precon...

Ticket Information

Ticket Type Remaining Sales End Price Fee Quantity
Early-Early Bird Special   more info 17 Tickets Ended $129.00 $0.00
Early Bird Special   more info 17 Tickets Ended $139.00 $0.00
SQL Saturday 312 Precon _KDelaney   more info 22 Tickets Ended $149.00 $0.00

Who's Going

Loading your connections...

Share What the Hekaton! SQL Saturday #312 Sacramento Precon with Kalen Delaney

Event Details

What the Hekaton!?

A Whole Day on a Whole New Way to Think About Data Management

 

 

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 data management. As a DBA, you’ll need to analyze your memory and storage needs completely differently. All Hekaton data is always stored in memory, and the data stored on disk is basically just a REDO log used to regenerate the contents of your memory-optimized tables. In this full-day seminar, Kalen Delaney (a SQL Server MVP for over 20 years) will show you the in-memory architecture for your Hekaton data and indexes, and discuss what gets written to disk during checkpoints, as well as what gets logged. She 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!

 

Topics:

 

  • Why Hekaton?

  • In-Memory Data Structures

    • Rows

    • Hash Indexes

    • Range Indexes

  • Data Access

  • Managing Memory

    • Space Requirements

    • Garbage Collection

  • Persistence and Storage Management

    • Checkpoint Files

    • Logging

    • Recovery

  • Performance Benefits

    • No latching

    • No locking

    • No query interpretation

  • Planning for Hekaton

     

     

 

Kalen 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.

 

Have questions about What the Hekaton! SQL Saturday #312 Sacramento Precon with Kalen Delaney? Contact Sacramento SQL Server Users Group

When & Where


Patrick Hays Learning Center
2700 Gateway Oaks Drive, Suite 2600
Sacramento, CA 95833

Friday, July 11, 2014 from 8:30 AM to 4:30 PM (PDT)


  Add to my calendar

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.