SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Why I am Excited about SQL Server on Linux


Why I am Excited about SQL Server on Linux

Author
Message
Solomon Rutzky
Solomon Rutzky
SSCertifiable
SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)

Group: General Forum Members
Points: 5979 Visits: 3084
Comments posted to this topic are about the item Why I am Excited about SQL Server on Linux

SQL# - https://SQLsharp.com/
Sql Quantum Lift - https://SqlQuantumLift.com/
Gary Varga
Gary Varga
SSC-Forever
SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)

Group: General Forum Members
Points: 41066 Visits: 6562
Some good points, however, I am interested at a level of "Wait and See" i.e. Solomon has named some interesting possibilities but it I will not be on the bleeding edge on this one.

This is interesting like 5 years ago Microsoft's mobile strategy was interesting. I got one of their first Windows Phones and upgraded to new phones twice. January I got an Android phone because, in my opinion, the Windows Phone strategy has failed to deliver.

Good luck to SQL Server on Linux. It is an interesting prospect. But not guaranteed to succeed.

Gaz

-- Stop your grinnin' and drop your linen...they're everywhere!!!
Dave Poole
Dave Poole
One Orange Chip
One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)

Group: General Forum Members
Points: 29601 Visits: 3602
I only hope that Microsoft port SSIS across to Linux.

One CTO described their choice of ETL tool as a C+ in a C- world. I've used a number of ETL tools. Some have been hampered by insane licensing, others by a limited feature, still more by being a bit flaky.
SSIS has many faults but BIML is a thing of joy.

LinkedIn Profile
www.simple-talk.com
Summer90
Summer90
SSChampion
SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

Group: General Forum Members
Points: 14416 Visits: 3920
From what little I have read SQL Server on Linux, at this point, is missing some key features. I can say I am not a fan of black screen command line Linux operating systems and have grown use to the ease of use with Windows. To me the cost of Windows vs free of Linux isn't that much ... what IS expensive IS SQL Server itself.
loyd.gravitt
loyd.gravitt
SSC Journeyman
SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)

Group: General Forum Members
Points: 98 Visits: 63
I am very excited. It takes two of my strongest skill sets (SQL Server and Linux) and makes them marketable to the same employers. Before, a prospective employer was interested in me as either a Linux resource or a SQL Server resource. This adds a whole new group of employers potentially looking for a resource like me without limiting my previous marketability.
t.ovod-everett
t.ovod-everett
SSC-Enthusiastic
SSC-Enthusiastic (173 reputation)SSC-Enthusiastic (173 reputation)SSC-Enthusiastic (173 reputation)SSC-Enthusiastic (173 reputation)SSC-Enthusiastic (173 reputation)SSC-Enthusiastic (173 reputation)SSC-Enthusiastic (173 reputation)SSC-Enthusiastic (173 reputation)

Group: General Forum Members
Points: 173 Visits: 269
Personally, I think the biggest reason to be excited about SQL Server on Linux is because it makes it viable for much of the Open Source world to start supporting SQL Server as a backend.

For instance, take the Ruby on Rails world. Supporting SQL Server is really difficult in that environment, because the Ruby community takes testing seriously. Most projects won't accept commits that don't include tests. That test suite needs to be automatable, preferably on something like Travis. People check in code to github, that automatically fires up a request to Travis CI, and 10 minutes later the fully automated test suite has run hundreds or thousands of tests on multiple versions of Rails, Ruby, etc. and reports whether the code is good. That model only works for SQL Server when SQL Server can run for free on Travis CI.

I'm not sure what the current state of support is for SQL Server on Travis CI - it's not in their documentation yet (see https://docs.travis-ci.com/user/database-setup/). But it's possible now, and once it happens that will enable a whole universe of robust and tested support for SQL Server in a variety of Open Source development environments.
SQLRNNR
SQLRNNR
SSC Guru
SSC Guru (122K reputation)SSC Guru (122K reputation)SSC Guru (122K reputation)SSC Guru (122K reputation)SSC Guru (122K reputation)SSC Guru (122K reputation)SSC Guru (122K reputation)SSC Guru (122K reputation)

Group: General Forum Members
Points: 122650 Visits: 18626
I like the opportunity for a new OS for SQL Server. This opens a new world of learning opportunities.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw

Solomon Rutzky
Solomon Rutzky
SSCertifiable
SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)

Group: General Forum Members
Points: 5979 Visits: 3084
Gary Varga - Thursday, March 2, 2017 12:50 AM
Some good points, however, I am interested at a level of "Wait and See" i.e. Solomon has named some interesting possibilities but it I will not be on the bleeding edge on this one.

This is interesting like 5 years ago Microsoft's mobile strategy was interesting. I got one of their first Windows Phones and upgraded to new phones twice. January I got an Android phone because, in my opinion, the Windows Phone strategy has failed to deliver.

Good luck to SQL Server on Linux. It is an interesting prospect. But not guaranteed to succeed.

Hi Gary. My overall point is that generally, we (i.e. those of us involved enough in the SQL Server community to regularly be here discussing the viability of this new direction) don't need to directly use this in order to benefit from it. If you don't use it ever, let alone just "wait and see", you (all of us, really) will still benefit as long as enough other people do. I don't use most Microsoft products, but I benefit from others using them, proving the company with revenue to invest in things like SQL Server (before it was as functional and costly) and coming up with .NET / C# and a host of other things. If this new option attracts a bunch of new people who would otherwise not be using SQL Server, then there is a natural increase in demand for products and services related to SQL Server that many of us (i.e. not Microsoft) provide.
Now, I completely understand being frustrated at investing time and/or money into a technology (or whatever) that ends up going away, but that's just the nature of how things work. Some things last longer than others. But the point here isn't about early adoption, or that we as a group should generally be trying to install it and be excited to use it. I might be excited to use it, but to me is doesn't detract from the potential of this new option if nobody else reading my editorial is excited or even never, ever touches it. If thousands (or more) use it and need training, tools, or merely offer jobs that some people take leaving vacancies at companies running SQL Server on Windows, then we all win.


SQL# - https://SQLsharp.com/
Sql Quantum Lift - https://SqlQuantumLift.com/
Solomon Rutzky
Solomon Rutzky
SSCertifiable
SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)

Group: General Forum Members
Points: 5979 Visits: 3084
Markus - Thursday, March 2, 2017 7:06 AM
From what little I have read SQL Server on Linux, at this point, is missing some key features. I can say I am not a fan of black screen command line Linux operating systems and have grown use to the ease of use with Windows. To me the cost of Windows vs free of Linux isn't that much ... what IS expensive IS SQL Server itself.

Hi Markus. Yes, it might be missing some features, but so is Azure SQL Database and SQL Server via Amazon RDS. But not everybody needs all of those features and enough people can make use of this to have indirect benefit to the community in general.
Understandable that you prefer a GUI over command prompt, but they might have an emulator that allows SSMS to work. It has been 17 years since I have played with it, but there used to be a "wine" project that emulated windows on Linux. But more importantly, the point I was making is that we ourselves don't need to be the ones directly using the Linux version of SQL Server to benefit from its existence. As long as enough other people do, then that will provide indirect benefits to people who might never touch Linux or SQL Server on Linux.
Also, the cost difference between Linux and Windows isn't much at the very small scale. But as the number of VMs increases it really does make a difference. This month's presentation at my local PASS chapter, TriPASS, was about running SQL Server at Amazon, both as RDS and on an EC2 instance. One of the things that the presenter mentioned was the large cost difference between Linux and Windows EC2 instances for large scale projects. So this will certainly be a decision factor for some companies.


SQL# - https://SQLsharp.com/
Sql Quantum Lift - https://SqlQuantumLift.com/
Solomon Rutzky
Solomon Rutzky
SSCertifiable
SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)

Group: General Forum Members
Points: 5979 Visits: 3084
loyd.gravitt - Thursday, March 2, 2017 9:20 AM
I am very excited. It takes two of my strongest skill sets (SQL Server and Linux) and makes them marketable to the same employers. Before, a prospective employer was interested in me as either a Linux resource or a SQL Server resource. This adds a whole new group of employers potentially looking for a resource like me without limiting my previous marketability.

Hi Loyd. Thanks for sharing this. Awesome that it provides a direct and tangible benefit Smile


SQL# - https://SQLsharp.com/
Sql Quantum Lift - https://SqlQuantumLift.com/
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum







































































































































































SQLServerCentral


Search