SQL Server 2017's first rc lands and – yes! – it runs on Linux

Penguinistas knock, Redmond lowers the Drawbridge

Microsoft's long, gentle embrace of Linux continues with the first release candidate of SQL Server 2017.

Microsoft said the early release would land in the middle of this year. Arguably, since this is only the RC1-level release, Microsoft's SQL-Server-on-Linux is running late.

There's not much detail on what's in the box, with this Technet blog post only saying:

SQL Server 2017 support for Linux includes the same high availability solutions on Linux as Windows Server, including Always On availability groups integrated with Linux native clustering solutions like Pacemaker.

There's also Active Directory authentication, so domain-joined Windows or Linux clients can use their domain credentials to sign into SQL Server.

As Microsoft discussed last December when the first public preview landed, getting SQL Server onto Linux needed an abstraction layer, which the company has dubbed “Drawbridge”.

Microsoft's SQL Server for Linux architecture

Drawbridge provides a host extension running as a Linux application. This initialises SQLPAL, which offers the Windows calls needed to launch SQL Server.

It's not only about Linux: other goodies in the release candidate include analytics in either R or Python; graph data processing for discovering complex many-to-many relationships; and Adaptive Query Processing to auto-tune the database.

If you consider your database sensitive (hint: it nearly always is), TLS support is brewed into the release to encrypt data between the SQL server and clients. ?


Biting the hand that feeds IT ? 1998–2017

  • 8207870 2018-01-20
  • 59213869 2018-01-20
  • 814434868 2018-01-20
  • 663393867 2018-01-20
  • 255500866 2018-01-20
  • 736756865 2018-01-20
  • 57893864 2018-01-20
  • 378982863 2018-01-20
  • 463182862 2018-01-20
  • 983878861 2018-01-20
  • 226305860 2018-01-20
  • 194376859 2018-01-20
  • 17410858 2018-01-20
  • 148249857 2018-01-20
  • 619862856 2018-01-20
  • 715860855 2018-01-20
  • 99290854 2018-01-20
  • 508353853 2018-01-19
  • 966152852 2018-01-19
  • 997753851 2018-01-19