Skip to content

new-updated-sql-server.md

Latest commit

 

History

History
164 lines (100 loc) · 7.98 KB

new-updated-sql-server.md

File metadata and controls

164 lines (100 loc) · 7.98 KB
title Updated - SQL Server docs | Microsoft Docs
description Display snippets of updated content for recently changed in documentation, for SQL Server.
services na
documentationcenter
author MightyPen
manager jhubbard
editor BYHAM
ms.service na
ms.topic updart-autogen
ms.technology database-engine
ms.custom UpdArt.exe
ms.workload sql-server
ms.tgt_pltfrm na
ms.devlang na
ms.date 09/11/2017
ms.author genemi

New and Recently Updated: SQL Server docs

Nearly every day Microsoft updates some of its existing articles on its Docs.Microsoft.com documentation website. This article displays excerpts from recently updated articles. Links to new articles might also be listed.

This article is generated by a program that is rerun periodically. Occasionally an excerpt can appear with imperfect formatting, or as markdown from the source article. Images are never displayed here.

Recent updates are reported for the following date range and subject:

  • Date range of updates:   2017-07-18   -to-   2017-09-11
  • Subject area:   SQL Server.

 

New Articles Created Recently

The following links jump to new articles that have been added recently.

  1. SQL Server 2008 R2 SP2 Release Notes
  2. SQL Server 2012 Release Notes
  3. SQL Server 2012 SP1 Release Notes
  4. SQL Server 2012 SP2 Release Notes
  5. SQL Server 2012 SP3 Release Notes
  6. SQL Server 2014 Release Notes
  7. Help Viewer and Offline Content for SQL Server

 

Updated Articles with Excerpts

This section displays the excerpts of updates gathered from articles that have recently experienced a large update.

The excerpts displayed here appear separated from their proper semantic context. Also, sometimes an excerpt is separated from important markdown syntax that surrounds it in the actual article. Therefore these excerpts are for general guidance only. The excerpts only enable you to know whether your interests warrant taking the time to click and visit the actual article.

For these and other reasons, do not copy code from these excerpts, and do not take as exact truth any text excerpt. Instead, visit the actual article.

 

Compact List of Articles Updated Recently

This compact list provides links to all the updated articles that are listed in the Excerpts section.

  1. What's new in SQL Server 2016

 

 

1.   What's new in SQL Server 2016

Updated: 2017-09-08          

 

SQL Server 2016 Database Engine

  • You can now configure multiple tempDB database files during SQL Server installation and setup.
  • New Query Store stores query texts, execution plans, and performance metrics within the database, allowing easy monitoring and troubleshooting of performance issues. A dashboard shows which queries consumed the most time, memory or CPU resources.
  • Temporal tables are history tables which record all data changes, complete with the date and time they occurred.
  • New built-in JSON support in SQL Server supports JSON imports, exports, parsing and storing.
  • New PolyBase query engine integrates SQL Server with external data in Hadoop or Azure Blob storage. You can import and export data as well as executing queries.
  • The new Stretch Database feature lets you dynamically, securely archive data from a local SQL Server database to an Azure SQL database in the cloud. SQL Server automatically queries both local and remote data in the linked databases.
  • In-memory OLTP:
    • Now supports FOREIGN KEY, UNIQUE and CHECK constraints, and native compiled stored procedures OR, NOT, SELECT DISTINCT, OUTER JOIN, and subqueries in SELECT.
    • Supports tables up to 2TB (up from 256GB).
    • Has column store index enhancements for sorting and Always On Availability Group support.
  • New security features:
    • Always Encrypted: When enabled, only the application that has the encryption key can access the encrypted sensitive data in the SQL Server 2016 database. The key is never passed to SQL Server.

Similar Articles

This section lists very similar articles for recently updated articles in other subject areas, within our public GitHub.com repository: MicrosoftDocs/sql-docs.

Subject areas which do have new or recently updated articles

Subject areas which have no new or recently updated articles