Back in March 2016, Microsoft announced that it was bringing SQL Server 2016 to Linux after it officially joined the Linux Foundation as a platinum member. The company stayed true to its word and released the first public preview on the operating system after eight months. Since then, it has been consistently rolling out updates and improving the software.
Today, Microsoft has announced the public availability of SQL Server 2017 Release Candidate 1 (RC1) on Windows, Linux, macOS, and Docker containers.
The company states that to-date, it has released seven community technology previews of SQL Server 2017, with each update bringing new capabilities and improvements. These features include Graph data processing support, adaptive query processing, Python integration for advanced analytics, and Linux support for tier-1 mission-critical workloads.
With the public availability of SQL Server 2017 RC1, Microsoft is offering further enhancements including:
- SQL Server on Linux Active Directory integration – With RC1, SQL Server on Linux supports Active Directory Authentication, which enables domain-joined clients on either Windows or Linux to authenticate to SQL Server using their domain credentials and the Kerberos protocol. Check out the getting started instructions.
- Transport Layer Security (TLS) to encrypt data – SQL Server on Linux can use TLS to encrypt data that is transmitted across a network between a client application and an instance of SQL Server. SQL Server on Linux supports the following TLS protocols: TLS 1.2, 1.1, and 1.0. Check out the getting started instructions.
- Machine Learning Services enhancements – In RC1, we add more model management capabilities for R Services on Windows Server, including External Library Management. The new release also supports Native Scoring.
- SQL Server Analysis Services (SSAS) – In addition to the enhancements to SSAS from previous CTPs of SQL Server 2017, RC1 adds additional Dynamic Management Views, enabling dependency analysis and reporting. See the Analysis Services blog for more information.
- SQL Server Integration Services (SSIS) on Linux – The preview of SQL Server Integration Services on Linux now adds support for any Unicode ODBC driver, if it follows ODBC specifications. (ANSI ODBC driver is not supported.)
- SQL Server Integration Services (SSIS) on Windows Server – RC1 adds support for SSIS scale out in highly available environments. Customers can now enable Always On for SSIS, setting up Windows Server failover clustering for the scale out master.
In addition, Microsoft has also listed several benchmark results establishing SQL Server 2017 as the most competitive and faster database software. The company also says that lots of customers are already enjoying these benefits as a part of its Early Adoption Program.