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

  • 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

  • Thank you for this Thom, my thoughts exactly!
    😎

  • 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?

  • 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

  • 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.

  • 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.

  • 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)

  • 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

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

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