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!
Download SQL Server 2019 preview to install on Windows.- Install on Linux for Red Hat Enterprise Server, SUSE Linux Enterprise Server, and Ubuntu.
- Run on SQL Server 2019 preview on Docker.
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. |
| 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 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_STATSdatabase 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.
Intelligence over any data
SQL Server is a hub for data integration. Deliver transformational insights over structured and unstructured data with the power of SQL Server and Spark.
Choice of language and platform
Build modern applications with innovative features using your choice of language and platform. Now on Windows, Linux, and containers.
Industry-leading performance
Take advantage of breakthrough scalability, performance, and availability for mission-critical, intelligent applications, data warehouses, and data lakes.
Advanced security features
Protect data at rest and in use. SQL Server has been the least vulnerable database over the last 8 years in the NIST vulnerabilities database.
Make faster, better decisions
Power BI Report Server gives your users access to rich, interactive Power BI reports, and the enterprise reporting capabilities of SQL Server Reporting Services.
Install SQL Server 2019 on Windows, Linux, and containers
Windows
Run SQL Server 2019 database engine on Windows.
- Link tải: https://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2019-ctp
Linux
Run SQL Server 2019 database engine on Linux.
Docker
Run SQL Server 2019 database engine container image with Docker.
Big data clusters
Run SQL Server 2019 big data clusters container images with Kubernetes.
PACISOFT.vn
