Home » sql server » Currently Reading:

David DeWitt Keynote at #SQLPASS #Summit13

October 17, 2013 sql server No Comments

Welcome to the live blog! Have some resources to start:

I’m taking a page out of Brent Ozar’s book (er, blog)…I’m not going to try to live blog the DeWitt session. There’s too much. Take a look at Brent’s blog, and come back here later for a few notes that strike me!

Hekaton: Why, What, and How

David DeWitt and Rimma Nehme, Microsoft Jim Gray Systems Lab (graysystemslab.com)  This slide deck will be posted.

Hekaton is available as part of SQL Server 2014 CTP2…it’s an “OLTP rocket ship!”   This is “in memory OLTP”. “Why can’t we just pin all tables in memory?” There are limiting problems with this, including latches for shared data structures, more.

Hekaton is different – it uses lock-free data structures (meaning, no latches). Locking is no longer the concurrency control mechanism; instead it’s versions with timestamps and optimistic currency control.  And finally, instead of interpreting queries, Hekaton will compile them into DLLs.

Comment on this Article:







MidnightSQL Consulting

Need help? Got an emergency? Write us at Support@MidnightDBA.com!

We can schedule time to help with your backup/restore issues, high availability and disaster recovery setup, performance problems, and a great deal more. Very often, we're even available on the moment for downtime issues and emergencies.

For more information about MidnightSQL consulting, email us or check out www.MidnightSQL.com. Happy days!

Where are We?

September 13: SQL Saturday Kansas City
November 3-7: PASS Summit, Seattle, WADecember 11: Presenting "Powershell Cmdlets.." at Alaska SQL Server User Group

Blog Posts by Category

DBAs@Midnight

How to Eat Pop-tarts
Watch DBAs@Midnight live on Fridays,m 11pm Central time

The best database career advice you’ve never heard!

DBARoadmap.com

The DBA Roadmap Seminar is 7 MP3 tracks (over 5 hours!) of insider guidance on your database career. We'll teach you how and what to study as a DBA, weigh in on controversial resume debates, teach you to recognize a worthy recruiter, and discuss the new professionalism of interviews. Also some bonus materials, PDF companion guides, and really spiffy intro music!

Once your $99 PayPal payment is submitted, you'll get the download link in e-mail! (Download is a 370Mb ZIP file.)

Become a DBA. Become a BETTER DBA. Use the Roadmap.

Visit www.DBARoadmap.com for info, forums, and more!

Add to Cart View Cart

Cunningham’s Law

"The best way to get the right answer on the Internet is not to ask a question, it's to post the wrong answer."
Relevant: http://xkcd.com/386/