SQL Server 2016 - Microsoft SQL Server Blog

Updates February 3, 2016 4 min read

Technical Overview: SQL Server 2016 Community Technology Preview 3.3

The SQL Server engineering team is pleased to announce the immediate availability of SQL Server 2016 public preview release CTP 3.

Best Practices January 21, 2016 3 min read

Limiting access to data using Row-Level Security

To satisfy compliance standards, internal regulations or basic security principles, applications often need to limit a user’s access to only certain rows of data in a database.

Best Practices January 14, 2016 4 min read

Data security, SQL Server 2016, and your business

Security is unquestionably a major priority for Microsoft.

Best Practices January 8, 2016 2 min read

JSON in SQL Server 2016: Part 4 of 4

Exporting Data as JSON – FOR JSON In this final post of our four-part JSON series, we showcase the ability to format query results as JSON text using the FOR JSON clause.

Best Practices January 7, 2016 3 min read

JSON in SQL Server 2016: Part 3 of 4

Transform JSON Text to Relational Table – OPENJSON OPENJSON is a table-value function (TVF) that looks into JSON text, locates an array of JSON objects, iterates through the elements of the array, and for each element returns one row in the output result.

Best Practices January 6, 2016 4 min read

JSON in SQL Server 2016: Part 2 of 4

Storing JSON Data in SQL Server Since external systems format information as JSON text, JSON is also stored in SQL Server as text.

Best Practices January 5, 2016 2 min read

JSON in SQL Server 2016: Part 1 of 4

JSON is currently one of the most commonly used data exchange formats.

Updates December 17, 2015 3 min read

SQL Server 2016 CTP 3.2: Introducing end-to-end mobile BI

The SQL Server 2016 Community Technology Preview (CTP) 3.

Best Practices December 15, 2015 8 min read

Enhanced Always On Availability Groups in SQL Server 2016

Always On Availability Groups Always On Availability Groups are a fundamental component of the availability story for SQL Server, and provide a robust disaster recovery solution as well.

Best Practices December 10, 2015 5 min read

Speeding up Transactions with In-Memory OLTP in SQL Server 2016 and Azure SQL Database

In-Memory OLTP, a performance feature in SQL Server since 2014, allows you to speed up transactional workloads up to 30X.

Best Practices December 9, 2015 3 min read

Real-Time Operational Analytics Using In-Memory Technology

Operational workloads refer to the business transactions that are critical to running a business.

Best Practices December 8, 2015 3 min read

Speeding up Business Analytics Using In-Memory Technology

New challenges Businesses have always used data and analytics for improved business decisions.

Explore SQL Server 2025