In a fresh move Microsoft has made its SQL Server available for the first time ever on Windows, Linux and Docker. This means BIG news for DevOps and database admins all over the industry.
Traditionally Microsoft has not been overly keen on Linux but their announcement last year seemed to indicate a change of heart. As well as SQL Microsoft now has Azure which is also compatible with Linux and it is now a member of the Linux Foundation.
We mentioned Microsoft’s September Ignite conference in a previous post and this was the same event that Microsoft used to announce its release of SQL Server 2017 for Linux.
Here’s the essential info:
- Available on Linux as a certified Docker image.
- Based on Ubuntu 16.04 (see our admin course here)
- Supported on Red Hat Enterprise Linux 7.3
- Supported on SUSE Linux Enterprise Server 12
- Supported on Ubuntu
- Supported on Docker
- Runs on devices with 3.25 gigabytes of RAM.
While the claim from Microsoft is that their SQL Server will offer Linux users the same performance that Microsoft users currently enjoy, the reality means the following is missing:
- Reporting Services
- Analysis Services or Machine Learning Services
- Stretch DB
- Azure Storage
- File Table "Replication",
Ubuntu admins will find the new developments to be a huge boost in efficiency when using SQL Server from Microsoft to set up databases. At EDC4IT the instructors and consultants are definitely happy about the news and what it will mean for our Ubuntu Admin course - details of which can be found here: http://www.edc4it.com/training/course/LINUX-UBUNTU
However, check in the Docker store and you will only find a preview version of SQL Server 2017 for Windows.
For the moment Microsoft’s full version of SQL Server for Linux is the Docker image of SQL Server 2017. The only official version for Windows Containers runs SQL Server 2017 Express.
This indicates that Microsoft is still working on a full version of SQL Server to serve Linux users.
For admins the developments mean that they can set up database servers much more quickly and will come across fewer issues when installing multiple instances on a single host. With so many companies locked into using Microsoft this will be a huge boost to admins and the way they deploy databases.
Be sure to follow us on social media for all our blog posts and updates.