Month: December 2017

Software

Windows Insiders Flight Hub Dashboard

Back in the fall of 2017, Microsoft released the Windows Flight Hub. This is a quick dashboard to reference when trying to sort out the many different Windows Insiders build numbers and what is the latest preview release in the Fast, Slow, Server, IoT, ISO and SDK rings.

Each build is called a flight and is associated to one or more editions of Windows 10.

Enjoy!

image

References

https://flighthub.azurewebsites.net/

Database

Free ebook – SQL Server Internals: In-Memory OLTP, Inside the SQL Server 2016 Hekaton Engine

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