TechEd 2013–Day 3 Summary

On day 3 I attended an interesting talk on Hekaton, now know as SQL Server 2014, by Sunil Agarwal. Sunil showed us how Hekaton turns stored procedures into C code and loads them as DLLs for SQL Server to use. He also showed us how in-memory tables are organized in memory and explained that the reason in-memory tables were so fast was that they were not organized in a B-tree, but as a hash table. Sunil mentioned that on one test, statements against a standard table was generating over 900,000 CPU instructions, while the same statement against an in-memory table was generating about 40,000 instructions. The demo from Sunil showed that inserting 500,000 records was sub-second with in memory-tables... on his laptop!  If you want to see the recorded presentation, go to: http://channel9.msdn.com/Events/TechEd/NorthAmerica/2013/DBI-B204#fbid=ZqUWDASLjhg

Many other things took place on Day 3, including a side session with the product and licensing group and an amazing private event evening at Emeril’s restaurant in New Orleans, where I had the pleasure of seeing many of the MVPs present at TechEd.

About Herve Roggero

Herve Roggero, Windows Azure MVP in South Florida, works for AAJ Technologies (http://www.aajtech.com) and is the founder of Blue Syntax Consulting (http://www.bluesyntax.net). Herve's experience includes software development, architecture, database administration and senior management with both global corporations and startup companies. Herve holds multiple certifications, including an MCDBA, MCSE, MCSD. He also holds a Master's degree in Business Administration from Indiana University. Herve is the co-author of "PRO SQL Azure" and “PRO SQL Server 2012 Practices” from Apress and runs the Azure Florida Association (on LinkedIn: http://www.linkedin.com/groups?gid=4177626).

Print | posted @ Thursday, June 6, 2013 12:21 AM

Comments on this entry:

Comments are closed.

Comments have been closed on this topic.