SQL Server Team articles

Avatar photo
SQL Server Team
Published 
3 min read

SQL Server 2014 CTP 2 Now Available 

Microsoft SQL Server 2014 CTP2 was announced by Quentin Clark during the Microsoft SQL PASS 2013 keynote.  This second public CTP is essentially feature complete and enables you to try and test all of the capabilities of the full SQL Server 2014 release.
Published 
2 min read

Microsoft is on the Move — to Charlotte! 

PASS Summit is just right around the corner and we are very excited to share all of our hard work with you!  Microsoft is sending over 140 people to Charlotte, NC to share our excitement about SQL Server & BI and spend time with our enthusiastic community. This year the conference is in Charlotte, October 15th – 18th.
Published 
6 min read

In-Memory OLTP: How Durability is Achieved for Memory-Optimized Tables 

In-memory OLTP provides full durability for memory-optimized tables. When a transaction that has made changes to memory-optimized table commits, SQL Server, just like it does for disk-based tables, guarantees that the changes are permanent and can survive the database restart provided the underlying storage is available. There are two key components of durability.
Published 
6 min read

Concurrency Control in the In-Memory OLTP Engine 

We believe that the In-Memory OLTP engine advances the industry state of the art with respect to concurrency control. The main reason for this advancement is due to the combination of lock free algorithms and the row-versioned architecture of the engine.
Published 
3 min read

In-Memory OLTP Programmability: Concurrency and Transaction Isolation for Memory-optimized Tables 

The new In-Memory OLTP feature introduces memory-optimized tables and natively compiled stored procedures in SQL Server 2014, to optimize performance and scalability of OLTP workloads. To benefit from this technology in an existing SQL Server application, you need to migrate the performance critical tables and stored procedures to memory-optimized tables and natively compiled stored procedures respectively.
Published 
8 min read

Tweet for the Summit! Enter to Win a Ticket to PASS Summit 2013! 

We’re just a few short weeks away from PASS Summit 2013, and the excitement is building! We’re getting our bags packed and ready to go, and we hope that you are too. However, if you haven’t made your plans just yet, listen up because we’re hosting a Tweet for the Summit Challenge, where you can win a ticket to PASS!