The first public release candidate of SQL Server 2017, marks a major milestone on the way to the general availability and brings several feature enhancements, including SQL Server on Linux Active Directory integration, Machine Learning Services capabilities and Transport Layer Security (TLS) to encrypt data.
“This means that development work for the new version of SQL Server is complete along most dimensions to bring the industry-leading performance and security of SQL Server to Windows, Linux and Docker containers,” writes the SQL Server team.
Key enhancements in RC1 include:
- 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.
- SQL Server on Linux can use Transport Layer Security (TLS) to encrypt data 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.
- Machine Learning Services enhancements like 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.
- SQL Server Integration Services (SSIS) preview 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.
The RC1) is now available for download, and for getting started check out the developer tutorials that show you how to install and use SQL Server 2017 on macOS, Docker, Windows, and Linux and quickly build an app in a programming language of your choice HERE.
Also, check out the following tutorials:
- Install on Red Hat Enterprise Linux
- Install on Ubuntu Linux
- Install on SUSE Linux Enterprise Server
- Pull and run a Linux Docker container on Linux, Windows, or macOS
- Download the preview for Windows
- Create a SQL Server on Linux virtual machine in Azure
- Active Directory Authentication with SQL Server on Linux
- Sign up for the Early Adoption Program (EAP)
For more video, visit here.
Alongside it, also the Release Candidate of SQL Server 2017 Reporting Services was released, and as reported earlier, the Reporting Services installation is moved from the SQL Server installer to a separate installer and enables customers to deploy and update Reporting Services with zero impact on your SQL Server deployments and databases.
However, access to SQL Server Reporting Services is still included with your SQL Server license.
Download SQL Server 2017 Reporting Services (RC).