SQL Server 2017 on Linux

此文转载，原文地址：https://docs.microsoft.com/zh-cn/sql/linux/sql-server-linux-whats-new

CTP 2.0

The CTP 2.0 release contains the following improvements and fixes:

• Added Log Shipping functionality for SQL Server Agent.
• Localized messages of mssql-conf.
• Linux path formatting are now compatible throughout the SQL Server Engine. But support for "C:\" prefixed paths will continue.
• Enabled DMV sys.dm_os_file_exists.
• Enabled DMV sys.fn_trace_gettable.
• Added CLR Strict Security mode.
• SQL Graph.
• Resumable Online Index Rebuilds.
• Adaptive Query Processing.
• Added UTF-8 encoding for system files, including log files.
• Fixed In-memory databases location limitation.
• Add new cluster type CLUSTER_TYPE = EXTERNAL for configuring an availability group for high availability.
• Fix Availability Group Listener for read-only routing.
• Production support for Early Adoption Program (EAP) customers. Sign up here.

CTP 1.4

The CTP 1.4 release contains the following improvements and fixes:

• Enabled the SQL Server Agent.
  • Enabled T-SQL Jobs functionality.
• Fixed timezone bugs:
  • Timezone support for Asia/Kolkata.
  • Fixed GETDATE() function.
• Network Async I/0 Improvements:
  • Significant improvements to In-Memory OLTP workload performance.
• Docker image now includes SQL Server command-line utilities. (sqlcmd/bcp).
• Enabled Virtual Device Interface (VDI) support for backups.
• Location of TempDB can now be modified after installation using ALTER DATABASE.

CTP 1.3

The CTP 1.3 release contains the following improvements and fixes:

• Enabled Full-text Search feature.
• Enabled Always On Availability Groups functionality for High Availability.
• Additional functionality in mssql-conf:
  • First time set-up using mssql-conf. See the use of mssql-conf in the installation guides.
  • Enabling Availability Groups. See the Availability Groups topic.
• Fixed native Linux path support for In-memory OLTP filegroups.
• Enabled dm_os_host_info DMV functionality.

CTP 1.2

The CTP 1.2 release contains the following improvements and fixes:

• Support for SUSE Linux Enterprise Server v12 SP2.
• Bug fixes for core engine and stability improvements.
• Docker image:
  • Fixed issue #1 by adding Python to the image.
  • Removed /opt/mssql/data as the default volume.
• Updated to .NET 4.6.2.

CTP 1.1

The CTP 1.1 release contains the following improvements and fixes:

• Support for Red Hat Enterprise Linux version 7.3.
• Support for Ubuntu 16.10.
• Upgraded Docker OS layer to Ubuntu 16.04.
• Fixed telemetry issues in Docker image.
• Fixed SQL Server Setup script related bugs.
• Enhanced performance for natively compiled T-SQL modules, including:
  • OPENJSON, FOR JSON, JSON built-ins.
  • Computed Columns (Only indexes are allowed on persisted computed columns, but not on non-persisted computed columns for in-memory tables).
  • CROSS APPLY operations.
• New language features:
  • String functions: TRIM, CONCAT_WS, TRANSLATE and STRING_AGG with support for WITHIN GROUP (ORDER BY).
  • BULK IMPORT now supports CSV format and Azure Blob Storage as File Source.

Under compatibility mode 140:

• Improved the performance of updates to non-clustered columnstore indexes in the case when the row is in the delta store. Changed from delete and insert operations to update. Also changed the plan shape used from wide to narrow.
• Batch mode queries now support "memory grant feedback loops". This will improve concurrency and throughput on systems running repeated queries that use batch mode. This can allow more queries to run on systems that are otherwise blocking on memory before starting queries.
• Improved performance in batch mode parallelism by ignoring trivial plan for batch mode plans to allow for parallel plans to be picked instead against columnstores.

Improvements from Service Pack 1 in this CTP1.1 release:

• Database cloning for CLR, Filestream/Filetable, In-memory and Query Store objects.
• CREATE or ALTER operators for programmability objects.
• New USE HINT query option to provide hints for the query processor. Learn more here: Query Hints.
• SQL service account can now programmatically identify Enable Lock Pages in Memory and Instant File Initialization permissions.
• Support for TempDB file count, file size and file growth settings.
• Extended diagnostics in showplan XML.
• Lightweight per-operator query execution profiling.
• New Dynamic Management Function sys.dm_exec_query_statistics_xml.
• New Dynamic Management Function for incremental statistics.
• Removed noisy In-memory related logging messages from errorlog.
• Improved AlwaysOn Latency Diagnostics.
• Cleaned up Manual Change Tracking.
• DROP TABLE support for replication.
• BULK INSERT into heaps with AUTO TABLOCK under TF 715.
• Parallel INSERT..SELECT changes for local temp tables.

Learn more about these fixes in the Service Pack 1 Release description.

Many database engine improvements apply to both Windows and Linux. The only exception would be for database engine features that are currently not supported on Linux. For more information, see What's New in SQL Server 2017 (Database Engine).