Skip to content
SQL Server Blog

Buffer Pool Extension to SSDs in SQL Server 2014 

How many of you have been looking into ways of cost effectively improving the performance of your OLTP workloads, without having to buy new more expensive hardware? Most of you know already that memory is one of the key assets available for the SQL Server and especially buffer pool memory, which plays key role in...

Read more

Architectural Overview of SQL Server 2014’s In-Memory OLTP Technology 

At the SQL PASS conference last November, we announced the In-memory OLTP database technology (code-named “Hekaton”) for a future SQL Server release. Microsoft’s technical fellow Dave Campbell’s blog provided a broad overview of the motivation and design principles behind the technology and discussed four architectural principles: (1) optimize for main memory data access, (2) Accelerate...

Read more

‘Wicked Fast’–Real World Experience with SQL Server 2014 In-Memory OLTP 

Recently Quentin Clark announced SQL Server 2014 during TechEd North America. One of the key features to be announced was the in-memory online transaction processing (OLTP) engine, which would complement the in-memory technologies which have been available in the data warehouse and analytics engines in SQL Server 2012, and integrated into PowerPivot in Excel 2013....

Read more

SQL Server 2014 In-Memory Technologies: Blog Series Introduction 

At the SQL PASS conference last November, we announced the In-memory OLTP (project code-named Hekaton) database technology built into the next release of SQL Server. Microsoft’s technical fellow Dave Campbell’s blog provides a broad overview of the motivation and design principles behind this project codenamed In-memory OLTP. In a nutshell – In-memory OLTP is a...

Read more

SQL Server 2014 – Public CTP Now Available 

At TechEd North America we announced Microsoft SQL Server 2014 as part of a wave of updates to our key enterprise products. Today we are pleased to announce the availability of the first public Community Technology Preview (CTP) of SQL Server 2014. This public CTP enables you to try and test many of the capabilities...

Read more

SQL Server 2014: A Closer Look 

Microsoft SQL Server 2014 was announced by Quentin Clark during the Microsoft TechEd 2013 keynote. Designed and developed with our cloud-first principles in mind, SQL Server 2014 builds on the momentum of SQL Server 2012, released just 14 months ago. We are excited to share a closer look at some of the exciting capabilities included...

Read more

SQL Server 2014: Unlocking Real-Time Insights 

Today at TechEd North America we announced a wave of products and services that will help customers embrace the “enterprise cloud era.” The next version of our data platform – SQL Server 2014 – is a key part of the day’s news. Designed and developed with our cloud-first principles in mind, it delivers built-in in-memory...

Read more