SQL Server Internals: In-Memory OLTP eBook cover

A new free ebook by Kalen Delaney on the internals of SQL Server 2016 In-Memory OLTP has been published by Simple Talk (redgate), which introduces and explains how SQL Server 2016 In-Memory OLTP engine (a.k.a. Hekaton) works. This book goes into detail about the in-memory engine and will help you with migrate existing databases and tables over to Hekaton for beyond imaginable performance.

“The SQL Server 2016 In-Memory OLTP engine (a.k.a. Hekaton) is designed to exploit terabytes of available memory and high numbers of processing cores. It allows us to work with memory-optimized tables and indexes, and natively compiled stored procedures, in addition to the disk-based tables and indexes, and T-SQL stored procedures, that SQL Server has always provided.”

Working with Hekaton in-memory data is very accessible using T-SQL and SSMS. However there are some limitations and this book goes into detail about what’s possible and what’s not and how to get around the issues.

Download your the free ebook here.

Enjoy!

References

https://www.red-gate.com/simple-talk/books/sql-books/sql-server-internals-in-memory-oltp/

https://www.microsoft.com/en-us/sql-server/sql-server-2016

Posted by Callon Campbell [MVP]

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s