Posted on 07/19/2017 5:56:13 AM PDT by dayglored
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”.
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. ®
This article is mainly of interest to IT personnel, System Admins, CIO/CTO types, and the like...
Why would anyone go through all that trouble when they could just run Postgres?
There are a number of big business-critical Windows applications that require SQL Server and won’t run with anything else (DB2, OracleDB, much less Postgres or MySQL).
Maybe this could help optimize FR’s real time database?
Or MariaDB or MySQL or any number of other systems that are better and FREE!
Better news.
Use the real deal, without MS cobbled to.
Linux simply works. Been using some flavor since 1994.
That's fine, as long as your business doesn't require any business applications that will only run on Windows (or Windows Server). A lot of businesses are forced to use Windows because they require Windows-only applications.
As a Linux user and System Admin, I can say that "Linux simply works" is mostly true. Having spent the last day in "Linux Library Dependency Hell" trying to resolve some old-vs-new app/library upgrades, I hesitate to make a 100% blanket approval... :-)
I don't think JOhnRob and JimRob are in the market for an expensive, Microsoft proprietary, replacement for the existing DB (I think it's MySQL on Linux).
Might be worth looking at Postgres, also free, runs on Linux, and is better suited to large DBs (like FR's has become over the years).
Yep, library issues are a plague.
Some distributions worse than others.
The main GUI support forks are a lot of the problem.
I understand the issue of Linux compatible apps. In a large company it is a bigger issue.
There are a lot of “traps” sewn among some of the apps. I refuse to be in involved with that. Adobe is one of them. It is a question of motives and control of customers. That exclusive is something we all battle daily.
Disclaimer: Opinions posted on Free Republic are those of the individual posters and do not necessarily represent the opinion of Free Republic or its management. All materials posted herein are protected by copyright law and the exemption for fair use of copyrighted works.