Microsoft SQL Server

Chat about Linux in general
MichaelJohn
Level 4
Level 4
Posts: 230
Joined: Fri Dec 12, 2014 6:46 am
Location: UK

Microsoft SQL Server

Postby MichaelJohn » Wed Oct 18, 2017 10:28 am

Microsoft have announced their latest version SQL Server 2017 will also have a version for Linux. Is anybody planning to use this? I only use it occasionally these days as the main database server is MySQL...

User avatar
bartszu
Level 4
Level 4
Posts: 289
Joined: Thu Aug 28, 2014 7:39 pm
Location: Eire

Re: Microsoft SQL Server

Postby bartszu » Wed Oct 18, 2017 7:54 pm

Way should we use any proprietary software technology, specially one coming from Death Star ? :D :D :D :D

User avatar
jimallyn
Level 16
Level 16
Posts: 6982
Joined: Thu Jun 05, 2014 7:34 pm
Location: Wenatchee, WA USA

Re: Microsoft SQL Server

Postby jimallyn » Wed Oct 18, 2017 9:10 pm

MichaelJohn wrote:Microsoft have announced their latest version SQL Server 2017 will also have a version for Linux.

“If Microsoft ever does applications for Linux it means I've won.” - Linus Torvalds
Image

“If the government were coming for your TVs and cars, then you'd be upset. But, as it is, they're only coming for your sons.” - Daniel Berrigan

ColdBootII
Level 3
Level 3
Posts: 169
Joined: Wed Aug 02, 2017 8:19 am

Re: Microsoft SQL Server

Postby ColdBootII » Thu Oct 19, 2017 2:58 am

jimallyn wrote:
MichaelJohn wrote:Microsoft have announced their latest version SQL Server 2017 will also have a version for Linux.

“If Microsoft ever does applications for Linux it means I've won.” - Linus Torvalds


Ahaha... :lol: - "the communists" win - Red All Over The Land! (and I don't mean Liverpool FC :mrgreen:)

MichaelJohn
Level 4
Level 4
Posts: 230
Joined: Fri Dec 12, 2014 6:46 am
Location: UK

Re: Microsoft SQL Server

Postby MichaelJohn » Thu Oct 19, 2017 8:04 am

The main SQL server I use is MySQL (M/S < 10%) but there have been a couple of horrendous problems which were logged years ago and remain unfixed. TBH in my previous job (five years ago) we changed from M/S to MySQL as we hit problems and M/S wanted £££££ to talk. So I will watch developments with interest...

User avatar
bartszu
Level 4
Level 4
Posts: 289
Joined: Thu Aug 28, 2014 7:39 pm
Location: Eire

Re: Microsoft SQL Server

Postby bartszu » Sat Oct 21, 2017 3:07 pm

MichaelJohn wrote:MySQL but there have been a couple of horrendous problems which were logged years ago and remain unfixed.


Sorry for asking technical details but we are in off topic zone, can you give example of this horrendousness ?

User avatar
coffee412
Level 5
Level 5
Posts: 732
Joined: Mon Nov 12, 2012 7:38 pm
Location: Indiana, USA
Contact:

Re: Microsoft SQL Server

Postby coffee412 » Sat Oct 21, 2017 6:12 pm

I can see it now....

Code: Select all

systemctl start mssql
... connecting to microsoft.com
... sending data...
.... Amazon wants to know if your still interested in this item...
... mssql started.
Ryzen x1800 Asus Prime x370-Pro 32 gigs Ram RX480 graphics
IceWarp * Samba AD * Mint 18.1 * RAID 1/5 * OpenVPN * Linux since kernel 2.0.36

MichaelJohn
Level 4
Level 4
Posts: 230
Joined: Fri Dec 12, 2014 6:46 am
Location: UK

Re: Microsoft SQL Server

Postby MichaelJohn » Thu Oct 26, 2017 7:35 am

One issue I have had is that the MySQL CLI uses my.cnf (a configuration file) whereas the visual tool 'MySQL Workbench' does not but uses its own C/C++ libraries. This caused inconsistent behaviour until understood and is pretty bad practice by the MySQL development people IMHO.

The other problem have had is that if the last entry in a table (InnoDB engine) is deleted before a reboot its PK (primary key) will be reused. Now if this PK is an FK (foreign key) in another table 'FK Hell' can break lose! :( This is as grim as hitting Mint dependency hell, which I have done a few times! Argh... This did mean a lot of extra code to avoid the problem!

I am not promoting M/S SQL server as I have also had issues with it in the past but I have never seen an issue drag on as long as the MySQL PK one!

dark
Level 2
Level 2
Posts: 90
Joined: Wed Feb 22, 2017 3:02 pm

Re: Microsoft SQL Server

Postby dark » Thu Oct 26, 2017 8:33 am

Use this instead, its open source too.

https://mariadb.org/

Made by the original developers of MySQL.

MichaelJohn
Level 4
Level 4
Posts: 230
Joined: Fri Dec 12, 2014 6:46 am
Location: UK

Re: Microsoft SQL Server

Postby MichaelJohn » Thu Oct 26, 2017 9:58 am

We have been using MySQL in anger for about two years but started development about three years ago. I had been using it at a previous gig over five years ago. A consultant did suggest MariaDB and it was looked at but not taken further as some issue cropped up! I doubt M/S SQL will be a real contender because of licensing costs. My main worry is that at board level there are mumblings about NoSQL. Having looked at it I,and another techie,are unconvinced for our applications.Unfortunately buzz words get more time and have more influence than they deserve...

User avatar
BigEasy
Level 5
Level 5
Posts: 994
Joined: Mon Nov 24, 2014 9:17 am
Location: Chrząszczyżewoszyce, powiat Łękołody

Re: Microsoft SQL Server

Postby BigEasy » Thu Oct 26, 2017 1:25 pm

MichaelJohn wrote:Microsoft have announced their latest version SQL Server 2017 will also have a version for Linux.

Finally! It is quite stupid situation when owners of Linux servers unable to run MS SQL on it.
Windows assumes I'm stupid but Linux demands proof of it


Return to “Chat about Linux”