BT

SQL Server 2017 RC1 Arrives with Expanded Linux Functionality

| by Jeff Martin Follow 17 Followers on Jul 24, 2017. Estimated reading time: 1 minute |

After seven preview releases, Microsoft has announced the release of the first Release Candidate for SQL Server 2017.  With this release developers can explore several new improvements that expand SQL Server’s Linux capabilities.

First among these is Active Directory Authentication support for SQL Server on Linux installations.  Using AD Authentication versus SQL Server Authentication provides several ease-of-management benefits, including single sign-on for users, the use of AD groups to organize users by different access levels, and the establishment of a centralized password policy.

Next is the ability to use Transport Layer Security (TLS) to encrypt data when transmitting over a network between a client application and instances of SQL Server.  TLS 1.0, 1.1, and 1.2 is supported.  Added to this is SQL Server Analysis Services (SSAS) with the Dynamic Management Views. 

SQL Server Integration Servers (SSIS) has also been updated.  For Linux instances, developers now have the option to use any Unicode ODBC driver (note this must be Unicode, ANSI is not supported).  Users of SSIS on Windows will benefit from the added support of Always On for SSIS, which provide failover clustering ability on Windows Server.

These new features build on the existing features in SQL Server 2017 that have already been delivered:

RC1 is available for download now and supports Windows, Linux, and Docker containers.

Rate this Article

Adoption Stage
Style

Hello stranger!

You need to Register an InfoQ account or or login to post comments. But there's so much more behind being registered.

Get the most out of the InfoQ experience.

Tell us what you think

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread
Community comments

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

Discuss
BT