In-memory OLTP, frequently referred to by its codename “Hekaton”, was introduced in SQL Server 2014. This powerful technology allows you to take advantage of large amounts of memory and many dozens of cores to increase performance for OLTP operations by up to 30 to 40 times! SQL Server 2016 is continuing the investment in In-memory OLTP by removing many of the limitations found in SQL Server 2014, and enhancing internal processing algorithms so that In-memory OLTP can provide even greater improvements.

The volume and complexity of data is increasing everywhere, and the ability to use it is becoming more important for organizations across industries. Digital transactions and experiences are expected to be available across geographies and time zones. Today the data generated by those millions of interactions touches every device, application and process. PDF Link

Windows Server and Microsoft SQL Server teams are collaborating closely to ensure that the combination of theseproducts is greater than the sum of their parts. IT decision makers can take advantage of a better enterprise dataplatform enabled by several key Windows Server 2016 features working in concert with SQL Server 2016 features.Both products offer best-in-class performance, scalability, availability, and security. With Windows Server and SQL Server, Microsoft is pushing the limits of hardware capabilities and bringing the latest enterprise technologies to market. PDF Link :sql-server-performance-tuning-using-wait-statistics-whitepaper

Microsoft SQL Server 2019 powers your organization by providing a data hub that you can use to access structured and unstructured data sources from across your entire data estate through a consistent interface. The relational database engine scales to petabytes of data, and enhancements to PolyBase allow you to process diverse big data and relational data sources using Transact-SQL from SQL Server. Link to PDF : Microsoft SQL Server 2019

Kellyn Gorman is an Azure Data Platform Architect for Microsoft with a long history in multi-platform technology. She spends a 60/40% split between Oracle on Azure and Analytics with her present team at Microsoft. A recent Idera ACE, a current friend of Redgate in the Microsoft community and an Oracle ACE Director alumnus, she has been awarded numerous awards over the years for her technical contributions and community volunteerism…. Link to PDF : Introducing Microsoft SQL Server 2019