March 1, 2017 at 10:40 pm
Comments posted to this topic are about the item Why I am Excited about SQL Server on Linux
SQL# — https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
Sql Quantum Lift — https://SqlQuantumLift.com/ ( company )
Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
Info sites — Collations • Module Signing • SQLCLR
March 2, 2017 at 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.
Gaz
-- Stop your grinnin' and drop your linen...they're everywhere!!!
March 2, 2017 at 1:49 am
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.
March 2, 2017 at 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.
March 2, 2017 at 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.
March 2, 2017 at 11:13 am
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.
March 2, 2017 at 11:38 am
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[/url]
Learn Extended Events
March 2, 2017 at 12:12 pm
Gary Varga - Thursday, March 2, 2017 12:50 AMSome 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/ ( SQLCLR library ofover 340 Functions and Procedures)
Sql Quantum Lift — https://SqlQuantumLift.com/ ( company )
Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
Info sites — Collations • Module Signing • SQLCLR
March 2, 2017 at 12:32 pm
Markus - Thursday, March 2, 2017 7:06 AMFrom 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/ ( SQLCLR library ofover 340 Functions and Procedures)
Sql Quantum Lift — https://SqlQuantumLift.com/ ( company )
Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
Info sites — Collations • Module Signing • SQLCLR
March 2, 2017 at 12:37 pm
loyd.gravitt - Thursday, March 2, 2017 9:20 AMI 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 🙂
SQL# — https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
Sql Quantum Lift — https://SqlQuantumLift.com/ ( company )
Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
Info sites — Collations • Module Signing • SQLCLR
March 2, 2017 at 12:44 pm
t.ovod-everett - Thursday, March 2, 2017 11:13 AMPersonally, 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.
Hi there. Yes, exactly this. It is a good example of the new exposure I was talking about. A whole new group of people using SQL Server is a whole new group of people needing help, needing training, buying SQL Server books, buying SQL Server tools, developing software (open source and closed source) that could be beneficial to the existing SQL Server community, and so on.
Thanks for sharing this.
SQL# — https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
Sql Quantum Lift — https://SqlQuantumLift.com/ ( company )
Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
Info sites — Collations • Module Signing • SQLCLR
March 2, 2017 at 12:50 pm
I would assume that you can administer a SQL Server instance running on a Linux Server from a SSMS GUI on a windows workstation as long as the connection string is correct?
All the linux knowledge needed (unless you were installing) would be to start and stop the requesite services, correct?
March 2, 2017 at 12:52 pm
I know that I have administered SQL Server on windows from a Linux desktop before via freetds at the command line and with Aquadata Studio for a GUI.
March 2, 2017 at 12:56 pm
loyd.gravitt - Thursday, March 2, 2017 12:50 PMI would assume that you can administer a SQL Server instance running on a Linux Server from a SSMS GUI on a windows workstation as long as the connection string is correct?All the linux knowledge needed (unless you were installing) would be to start and stop the requesite services, correct?
Those seem like reasonable assumptions to me. And if a company has both Windows and Linux, it could be a Linux admin that handles that end of it and the SQL Server DBA uses SSMS on Windows and never touches Linux. I guess we will see over time how different companies manage this.
SQL# — https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
Sql Quantum Lift — https://SqlQuantumLift.com/ ( company )
Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
Info sites — Collations • Module Signing • SQLCLR
March 3, 2017 at 6:53 am
How would one replace SSMS with a native Linux or cross platform app? Would SMO + C# even work on Linux?
Viewing 15 posts - 1 through 15 (of 16 total)
You must be logged in to reply to this topic. Login to reply