Shulou(Shulou.com)06/01 Report--

Today, I will talk to you about the example analysis of SQL Server 2017 RC1 to achieve Linux function extension, many people may not know much about it. In order to make you understand better, the editor has summarized the following content for you. I hope you can get something according to this article.

After iterating over seven preview versions, Microsoft announced the release of the first SQL Server 2017 candidate. Developers can use this version to explore some new improvements that extend the capabilities of the SQL Server Linux version.

Among these new improvements, the first is support for Active Directory authentication for SQL Server on Linux. Using AD authentication has some manageable advantages over SQL Server authentication, including single sign-on for users, using AD groups to organize users with different access levels, and establishing a centralized password policy.

The second is the ability to use Transport layer Security Protocol (Transport Layer Security,TLS) to encrypt data when transferring over the network between the client application and the SQL Server instance. TLS 1.0,1.1 and 1.2 are now supported. The new features are SQL Server Analysis Services (SQL Server Analysis Services, SSAS) and dynamic Management View (Dynamic Management Views).

The SQL Server Integration Server (SQL Server Integration Servers,SSIS) has also been updated. For Linux instances, developers can now choose to use any Unicode ODBC driver (note that it must be Unicode, ANSI is not supported). SSIS users on Windows will benefit from increased Always On support for SSIS, which provides failover clustering on Windows Server.

These new features are based on existing features in SQL Server 2017 that have been delivered:

The Linux version provides support for critical, highly available workloads, thanks to the support of Always On high availability groups and Pacemaker.

Graphic data processing

Adaptive query processing

Python integration

After reading the above, do you have any further understanding of the example analysis of SQL Server 2017 RC1 implementing Linux functional extensions? If you want to know more knowledge or related content, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.