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

  • Thom A

    SSC Guru

    Points: 98447

    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.

  • Eirikur Eiriksson

    SSC Guru

    Points: 182366

    Thank you for this Thom, my thoughts exactly!
    😎

  • skylimited

    SSC Enthusiast

    Points: 145

    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: 98447

    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.

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 716560

    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: 145

    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: 995099

    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.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "Change is inevitable... change for the better is not."
    When you put the right degree of spin on it, the number 3|8 is also a glyph that describes the nature of a DBAs job. 😉

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

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

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