SQL Server 2019 có gì mới? Tính năng, so sánh các phiên bản SQL Server 2019

Chuyển đổi doanh nghiệp của bạn với một nền tảng dữ liệu thống nhất. SQL Server 2019 đi kèm với Hệ thống tệp phân tán Apache Spark và Hadoop (HDFS) để thông minh hơn với tất cả dữ liệu của bạn.

SQL Server 2019 preview builds on previous releases to grow SQL Server as a platform that gives you choices of development languages, data types, on-premises or cloud, and operating systems. This article summarizes what is new for SQL Server 2019 preview.

The article summarizes the features in each release and points to more details for each feature. The Details section provides technical details of features that may not be available in core documentation. The other sections of this article provide details about all of the features released to date for this SQL Server 2019 preview.

For more information and known issues, see the SQL Server 2019 preview Release Notes.

Try SQL Server 2019 preview!

CTP 2.5 April 2019

Community technology preview (CTP) 2.5 is the latest public release of SQL Server 2019 preview. This release includes improvements from previous CTP releases to fix bugs, improve security, and optimize performance. In addition, the following features are added or enhanced for SQL Server 2019 preview CTP 2.5.

Big data clusters

New feature or update Details
Deployment profiles Use default and customized deployment configuration JSON files for big data cluster deployments instead of environment variables.
Prompted deployments mssqlctl cluster create now prompts for any necessary settings for default deployments.
Service endpoint and pod name changes For more information, see the big data cluster release notes.
mssqlctl improvements Use mssqlctl to list external endpoints and check the version of mssqlctl with the --version parameter.
Offline install Guidance for offline big data cluster deployments.
HDFS tiering improvements HDFS tiering against Amazon S3 storage. OAuth support for ADLS Gen2. Caching functionality for better performance. For more information, see HSDFS Tiering
Spark to SQL Server connector Read and write to SQL Server from Spark using the MSSQL JDBC Connector

Database engine

New feature or update Details
PolyBase on Linux. Install PolyBase on Linux for non-Hadoop connectors.

PolyBase type mapping.

New Java language SDK for SQL Server. Simplifies development of Java programs that can be run from SQL Server. See What’s new in SQL Server Machine Learning Services.
Expanded the scope of plans available in DMF sys.dm_exec_query_plan_stats. See sys.dm_exec_query_plan_stats1
New LAST_QUERY_PLAN_STATS database scoped configuration to enable sys.dm_exec_query_plan_stats. See ALTER DATABASE SCOPED CONFIGURATION
New spatial reference identifiers (SRIDs). Australian GDA2020 provides more robust and accurate datum which is more closely aligned to global positioning systems. The new SRIDs are:

– 7843 – geographic 2D
– 7844 – geographic 3D

sys.spatial_reference_systems view contains definitions of new SRIDs.

1 This is an opt-in feature and requires trace flag 2451 to be enabled or setting the LAST_QUERY_PLAN_STATS database scoped configuration to ON.

Xem thêm: https://docs.microsoft.com/en-us/sql/sql-server/sql-server-ver15-release-notes?view=sqlallproducts-allversions

What you’ll love about SQL Server 2019

SQL Server 2019 brings innovative security and compliance features, industry-leading performance, mission-critical availability, and advanced analytics to all your data workloads, now with support for big data built-in.