[dba-SQLServer] SQL Server on Linux

[Jim Lawrence]

It is interesting to note that MS SQL can now be installed on Linux:

Check out the following; Installation guidance for SQL Server on Linux:
https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-setup

It take two lines of code to install the package on an Ubuntu/Debian server. (Ubuntu is my preferred distro)

sudo apt-get update  <-- Standard cleanup line before any new installations
sudo apt-get install mssql-server <-- ...and then just install and run.

...or the more modern syntax:
sudo apt update && sudo apt mssql-server
 
Note: Haven't tried yet maybe by Christmas and rest assured there will be extended issues. ;-)

Jim

----- Original Message -----
From: "John R Bartow" <jbartow at winhaven.net>
To: "Discussion concerning MS SQL Server" <dba-sqlserver at databaseadvisors.com>
Sent: Saturday, August 19, 2017 7:25:11 PM
Subject: Re: [dba-SQLServer] SQL Server on Linux

What about a firm with an application directly tied to SQLServer? Shouldn't matter what platform the DBserver sits on. 25 years ago I was using Informix DB on a Unix server and all of my clients were on WinNT.

-----Original Message-----
From: dba-SQLServer [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Friday, August 18, 2017 2:30 PM
To: Discussion concerning MS SQL Server <dba-sqlserver at databaseadvisors.com>
Subject: [dba-SQLServer] SQL Server on Linux

I keep trying to wrap my head around this, so far to no avail. Given that:

a) none of the largest players in the big-server marketplace use neither Windows nor SQL Server;
b) on the next tier down (in terms of number of servers, users, etc.), virtually all players are committed to Linux, and have been for years; not only that, but they have also committed to (Choose one) MySQL, MariaDB or PostGreSQL, with various NoSQL implementations here and there.
c) MS intends to charge $ for its Linux implementation; the aforementioned competing products are available for free (of course, if you're going to bet your firm on your database, then you'll be buying support on an annual basis).

What market-share does this leave? I can think of some niches here and
there:

a ) a firm with a mix of Windows Server and Linux servers, trying to rationalize and simplify the layout and consequent maintenance hassles and costs;

b) a smallish firm, previously committed to Windows, whose IT people keep touting Linux as providing superior servers; therein lie potential porting opportunities, for both internal IT people and external consultants.

After these, I'm out of ideas. Perhaps I'm missing some Big Picture here.
If so, would someone on this list kindly clue me in?

Thanks,
Arthur
--
Arthur
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com


_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com