Non-clustered Columnstore Indexes are also getting some enhancements in SQL Server 2016. The most notable of these enhancements is the ability to be updated.

One of the long-standing differentiators between SQL Server's Enterprise Edition (EE) and Standard Edition (SE), besides price, were the large number of features available only in EE. This is also ...

A few days ago, Microsoft shocked us when it announced that it would soon bring its SQL Server database to Linux. It’ll take until 2017 before SQL Server will be available on Linux, though ...

For starters, SAN-based databases can connect to SQL Server 2014, or admins can create snapshots to mount on the new server. But for systems based on traditional storage, SQL Server 2014 offers ...

Microsoft is readying a first public preview of its next version of SQL Server, called SQL Server 2016, for delivery this summer. The successor to SQL Server 2014 will include enhanced in-memory ...