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-05-23   -to-   2017-07-17
  • Subject area:   SQL Server.

 

New Articles Created Recently

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

  1. Editions and supported features of SQL Server 2017
  2. Configure SQL Server to send feedback to Microsoft

 

Compact List of Articles Updated Recently

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

 

Updated Articles with Excerpts

This section displays the excerpts of updates gathered from articles which 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.

 

 

1.   Customer Experience Improvement Program for SQL Server Data Tools

Updated: 2017-06-14           (Next)

 

The Customer Experience Improvement Program is a program designed to help Microsoft improve its products over time. This program collects information about computer hardware and how people use our product, without interrupting the users in their tasks at the computer. The information that is collected helps Microsoft identify which features to improve. In this document we will cover how to opt-in or out of CEIP for SQL Server Data Tools (SSDT) for Visual Studio 2017, Visual Studio 2015, and Visual Studio 2013.

**Choice and Control over CEIP and SQL Server Data Tools for Visual Studio 2017 **

SSDT for Visual Studio 2017 is the data modeling tool that ships with SQL Server 2017. It uses the CEIP options that are built into Visual Studio 2017. You can learn more about how to submit feedback through CEIP in Visual Studio 2017 from this help document from Visual Studio.

For preview versions of SQL Server 2017, CEIP is turned on by default. You can turn it off, or back on again, by following the instructions below.

In Visual Studio (applies to full language installations of Visual Studio 2017)

If you run SSDT Setup on a computer that already has Visual Studio, only the SQL Server and Business Intelligence project templates are added. For this scenario, customer feedback options that Visual Studio provides can be used to opt in or out of CEIP.

  1. Start Visual Studio.

  2. From the Help menu, select Send Feedback > Settings.

  3. To turn CEIP off, click No, I would not like to participate, and then click OK.

    To turn CEIP on, click Yes, I am willing to participate, and then click OK.

Use a registry-based policy or Group Policy

 

 


2.   Editions and supported features of SQL Server 2016

Updated: 2017-06-16           (Previous)

 

Developer and Evaluation Editions
For features supported by Developer and Evaluation editions, see features listed for the SQL Server Enterprise Edition in the tables below. For a list of features that were added to the Developer edition for SQL Server 2016 SP1, see SQL Server 2016 SP1 editions.

The Developer edition continues to support only 1 client for [SQL Server Distributed Replay--../tools/distributed-replay/sql-server-distributed-replay.md).

** Scale Limits **

Feature Enterprise Standard Web Express with Advanced Services Express
Maximum compute capacity used by a single instance - [!INCLUDE[ssDEnoversion--../includes/ssdenoversion-md.md)]1 Operating system maximum Limited to lesser of 4 sockets or 24 cores Limited to lesser of 4 sockets or 16 cores Limited to lesser of 1 socket or 4 cores Limited to lesser of 1 socket or 4 cores
Maximum compute capacity used by a single instance - [!INCLUDE[ssASnoversion--../includes/ssasnoversion-md.md)] or [!INCLUDE[ssRSnoversion--../includes/ssrsnoversion-md.md)] Operating system maximum Limited to lesser of 4 sockets or 24 cores Limited to lesser of 4 sockets or 16 cores Limited to lesser of 1 socket or 4 cores Limited to lesser of 1 socket or 4 cores
Maximum memory for buffer pool per instance of [!INCLUDE[ssDEnoversion--../includes/ssdenoversion-md.md)] Operating System Maximum 128 GB 64 GB 1410 MB 1410 MB
Maximum memory for Columnstore segment cache per instance of [!INCLUDE[ssDEnoversion--../includes/ssdenoversion-md.md)] Unlimited memory 32 GB2 16 GB2 352 MB2 352 MB2
Maximum memory-optimized data size per database in [!INCLUDE[ssDEnoversion--../includes/ssdenoversion-md.md)] Unlimited memory 32 GB2 16 GB2 352 MB2 352 MB2

 

Similar Articles

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

Subject areas which do have new or recently updated articles

Subject areas which have no new or recently updated articles