Microsoft first announced the Linux version of SQL Server in March last year and released its first public RC version in July this year. Microsoft announced that SQL Server 2017 will be officially released on October 2, at the Microsoft Ignite 2017 conference in Orlando, USA, in the previous days.
SQL Server 2017 is now officially released. This is the first time in SQL Server history to publish both Windows and Linux editions. In addition, Microsoft has released a container version that can be deployed using Docker.
For SQL Server, this is a milestone in its history because this is the first version that spans Windows, marking the first time that SQL Server is available on a Linux platform.
The new version of SQL Server 2017 becomes the first cloud-wide version that spans different operating systems, including Linux, Docker.
The Linux distributions currently supported by SQL Server 2017 include: Red Hat Enterprise Linux (RHEL), SUSE Linux Enterprise Server, and Ubuntu.
SQL Server 2017 supports the three container platforms for Docker Enterprise Edition, Kubernetes and OpenShift.
As cloud computing grows in popularity, Microsoft Azure can also run SQL Server 2017, allowing developers to use their familiar development language and environment to create the applications they want, while taking into account security and performance.
SQL Server 2017 supports the use of R and Python analysis methods to do machine learning in the database, which means there is no need to migrate data and save a lot of time.
The new SQL data Warehouse greatly optimizes the performance of data in cloud computing. Microsoft is expected to launch a preview version in the fall.
Migrating servers between different public clouds is a headache for many people. Microsoft launches the Azure Database migration Service, providing nearly 0 time-lag painless migration scenarios that can be painless migrated without additional cost and that the program code does not have to be altered.
There are some new features to watch out for:
The Figure data Analysis feature enables customers to use native graphical query syntax using graphical data storage and query language extensions to discover new relationships in highly interconnected data.
Adaptive query processing is a new set of features in SQL Server that can bring a smarter experience to your database. For example, the Adaptive memory Grants in SQL Server tracks and understands how much memory is used for a given query to adjust memory usage.
Automatic Plan Correction ensures continuous performance by locating and correcting performance regressions.
The core features of SQL Server 2017 are consistent on Windows and Linux, but few features that rely on Windows features are not available to Linux (such as cluster support and Integrated Windows authentication).
For more information, please see the release notes.
: Https://www.microsoft.com/zh-cn/sql-server/sql-server-downloads
Http://www.oschina.net/news/89263/sql-server-2017-on-windows-linux-and-docker-ga
SQL Server 2017 is officially released: Both Windows and Linux are supported (now look down, that's when De la's "cloud first, mobile first" is visionary, and there is a series of measures and products to match, just a little time. Really admire!! )