SQL Server on Linux, does it have Microsoft's full attention?

Question

Post reply

SQL Server on Linux, does it have Microsoft's full attention?

Thom A

SSC Guru

Points: 99130
More actions
May 20, 2018 at 10:28 pm

#338630

Comments posted to this topic are about the item SQL Server on Linux, does it have Microsoft's full attention?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Eirikur Eiriksson SSC Guru Points: 182911 More actions · Answer 1

Eirikur Eiriksson

SSC Guru

Points: 182911

May 21, 2018 at 3:22 am

#1991178

Thank you for this Thom, my thoughts exactly!
😎

skylimited SSC Enthusiast Points: 146 More actions · Answer 2

I'm running SQL Server on OpenSuse Leap 42.3 in production without a problem.
May be it's a problem with Ubuntu, and not with Microsoft?

Thom A SSC Guru Points: 99130 More actions · Answer 3

skylimited - Monday, May 21, 2018 8:25 AM
I'm running SQL Server on OpenSuse Leap 42.3 in production without a problem.
May be it's a problem with Ubuntu, and not with Microsoft?

The article is specifically about Ubuntu here, rather than Red Hat and Suse, however, neither have actually had a major release since SQL Server on Linux was released.

I don't think, however, it is a problem with Ubuntu, no. When you try to install SQL Server on Ubuntu 18.04 LTS, I recall the first hurdle being that it complains about the version of OpenSSL installed, specifically 1.1.0g. SQL Server says it requires OpenSSL 1.1.0<=; so it doesn't support the latest version (I assume that as it says <= it means it only supports the first version of 1.1.0). Ubuntu 18.04 LTS comes with OpenSSL 1.1.0g, which is (almost) the latest version; according to the OpenSSL website the latest version is 1.1.0h.

This doesn't change the fact that Microsoft should have been testing against the latest release of Ubuntu, especially in it's alpha and beta stages, and should put notices up to let people know it's not supported at this time.

Thom~

Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk

Steve Jones - SSC Editor SSC Guru Points: 736172 More actions · Answer 4

Well, it's a problem with MS not supporting an LTS (long term support) version. I'd expect that MS moves to support the LTS or active branches. This seems more like MS hasn't updated some of their stuff to patch for Ubuntu.

I appreciate that now that they're supporting 4 OSes, there are likely some holes in the way they patch. They have OS specific patches, so this is odd. Unless Ubuntu made a change from 16.x to 18.x that isn't easily resolved and they are avoiding the IF logic on code to look for versions.

skylimited SSC Enthusiast Points: 146 More actions · Answer 5

Thom A - Monday, May 21, 2018 8:59 AM
The article is specifically about Ubuntu here, rather than Red Hat and Suse, however, neither have actually had a major release since SQL Server on Linux was released.
I don't think, however, it is a problem with Ubuntu, no. When you try to install SQL Server on Ubuntu 18.04 LTS, I recall the first hurdle being that it complains about the version of OpenSSL installed, specifically 1.1.0g. SQL Server says it requires OpenSSL 1.1.0<=; so it doesn't support the latest version (I assume that as it says <= it means it only supports the first version of 1.1.0). Ubuntu 18.04 LTS comes with OpenSSL 1.1.0g, which is (almost) the latest version; according to the OpenSSL website the latest version is 1.1.0h.
This doesn't change the fact that Microsoft should have been testing against the latest release of Ubuntu, especially in it's alpha and beta stages, and should put notices up to let people know it's not supported at this time.

I don't think, that they really "should". A good practice is to have just SQL Server installed and nothing more, so i could not see any reason to install 18.04 LTS, and not 16.04 which is oficially supported one. BTW, i expect there is a lot of work to rebuild SQL for Linux, which is based on .NET stack. And as far, as i could see - i found only small bugs in JSON parsing ( with JSON_VALUE like functions). And doesn't found problems with performance and/or stability especially with memory usage. I think this is great job, and it's more important, rather then support all version of lib's that could be really diffirent from distro to distro.

Jeff Moden SSC Guru Points: 1004323 More actions · Answer 6

As good as it is, I'm just hoping that the start supporting the Windows Version the way it needs to be supported.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Jamie-2229 SSCrazy Eights Points: 8156 More actions · Answer 7

This is an older post - has any of the above resolved with Ubuntu 20.04 / SQL 2019? Are there any thoughts on an upcoming release for SQL 2022 on Ubuntu?

Jamie