Can you configure MSSQL just editing files without a GUI, Unix-style?
yep. i've been using this https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-...
MSSQL on Linux – the details
51–59 of 59 posts
Re: MSSQL on Linux – the details
#52Any valid use cases? No offence, was just wondering why would anybody use it...
As others have noted, SQL Server is a very powerful platform. I only really know about it from the perspective of a web/app programmer, but that's only the tip of the iceberg.
To answer your question directly...
Don't think of it from the perspective of "green field" development where you're building something from scratch.
While "green field" development is every dev's dream, the overwhelming majority of dev work involves maintaining and integrating with existing services. There are lots of MSSQL installations out there, after all.
On another note, I know soooo many developers for whom "SQL" is synonymous with "MySQL." MySQL is okay, but they should know that Postgres and MSSQL offer a lot of programmer-friendly things that make working with them a heck of a lot more fun than MySQL. Different index types, data types, window functions, CTEs, etc.
Re: MSSQL on Linux – the details
#53Earlier quoted context omitted.
> Any valid use cases? I'm personally a fully competent Linux sysadmin, and an extremely incompetent Windows sysadmin. SQL Server is great, I love .NET, and the only thing holding me back all these years has been the Windows system requirement.
I consider myself a first-rate Linux sysadmin, and a perfectly competent Windows sysadmin as well, but this is a position I can't wrap my head around. If you're willing to pay thousands of dollars for a properly-licensed SQL Server install, why do you care if it needs to run on Windows? I would normally assume you don't want the license cost of the OS, but it's a tiny fraction of the overall licensing cost. The only…
> why do you care if it needs to run on Windows? I would normally assume you don't want the license cost of the OS, but it's a tiny fraction of the overall licensing cost.
At my company we had a single Windows server for aaaaages that we kept around because of a legacy MSSQL install we needed. Only Windows box in the whole server farm. Was a bit of a pain.
Of course, MSSQL-on-Linux wouldn't necessarily have been the answer here... I'm sure we would have had to buy a new MSSQL license to run it on Linux.
Eventually we eliminated the need for it entirely, but had MSSQL-on-Linux been an option a few years ago we might have simply migrated it to Linux and paid the necessary license.
Re: MSSQL on Linux – the details
#54Article implies only clients for managing SQL Server are SSMS or VS Code - for most of what you'd need to do, tools like DataGrip, Navicat, or any other solution that supports JDBC works well on most platforms.
IntelliJ db browser is nice as well. You can connect to all mainstream DBs including MS SQL.
Yes, DataGrip is the full blown standalone version of the database tool in their various IDEs.
Re: MSSQL on Linux – the details
#55user space version of the NT kernel (known as NTUM - "user mode NT") This is pretty neat. Wonder if people could use it to run other Windows stuff on Linux Edit: formatting
Interesting. It seems to be based on Microsoft's "Drawbridge" research project:
https://www.microsoft.com/en-us/research/project/drawbridge/
I wonder if there's any chance they'd allow this mechanism to be used by 3rd parties to port their Windows services to run on non-Windows platforms. I doubt it...
Re: MSSQL on Linux – the details
#56To me its quite amazing that in 2016 we have a fully approved & supported Windows kernel running in linux and a linux kernel running in Windows. Makes me rethink the definition of what an OS really is.
unless it's the good ol` Embrace & Extend & Extinguish. it's here now, but i'd wait and see where this goes. we're lucky we still have linus.
It's possible to come up with FUD regarding anything.
Re: MSSQL on Linux – the details
#57To me its quite amazing that in 2016 we have a fully approved & supported Windows kernel running in linux and a linux kernel running in Windows. Makes me rethink the definition of what an OS really is.
Windows subsystem for Linux does not have Linux kernel in it.
Re: MSSQL on Linux – the details
#58Any valid use cases? No offence, was just wondering why would anybody use it...
Forewarning: This likely sounds like a shill post. I'm okay with that. I work for a Microsoft partner and we're tightly integrated with the MS sellers for a number of products. I am trying to provide an answer to the use cases. A fully integrated data platform suite with several tools that are best in class. SQL Server is not just a relational database engine, though that is at the core of most tools and services. SQ…
> It's competing with damn near everything that touches data at your company.
MSSQL for data processing? Really? I think only huge legacy projects still using it. We're using Hadoop with some C++/Hardware acceleration.
Re: MSSQL on Linux – the details
#59Earlier quoted context omitted.
Forewarning: This likely sounds like a shill post. I'm okay with that. I work for a Microsoft partner and we're tightly integrated with the MS sellers for a number of products. I am trying to provide an answer to the use cases. A fully integrated data platform suite with several tools that are best in class. SQL Server is not just a relational database engine, though that is at the core of most tools and services. SQ…
> It's competing with damn near everything that touches data at your company. MSSQL for data processing? Really? I think only huge legacy projects still using it. We're using Hadoop with some C++/Hardware acceleration.
Really? Because I see Microsoft revenue continuing to increase and the partner ecosystem continuing to thrive. I also get to see licensing agreements and I get to see what sales quotas are in the MS data platform.
None of the numbers indicate a shrinking market to me. SQL Server does compete for analytics workloads. Is it a direct competitor to Hadoop? No.
I have clearly stated my bubble up front and I'm trying to keep my claims within that bubble. The question was "what are the use cases?" I answered that. I am now saying that I see a thriving SQL Server business. I'm not saying no one uses Hadoop because more of my projects leverage SQL Server components than Hadoop. You are claiming that SQL Server is only for legacy projects because you are not using it.