8 ms·
MSSQL on Linux – the details
- bdcravens 10y agoArticle 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.
- teh_klev 10y agoNot forgetting HeidiSQL which although is a Windows app runs well under Wine: http://www.heidisql.com/download.php http://www.heidisql.com/download.php https://appdb.winehq.org/appview.php?iAppId=3326 https://appdb.winehq.org/appview.php?iAppId=3326
- tkubacki 10y agoIntelliJ db browser is nice as well. You can connect to all mainstream DBs including MS SQL.
- bdcravens 10y agoYes, DataGrip is the full blown standalone version of the database tool in their various IDEs.
- koltaggar 10y agoDo people actually run this ?
- ljoshua 10y agoIt just barely became available as a public preview. It's not recommended for protection yet.
- ishtu 10y agouser 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
- mistaken 10y agoThat's like an official implementation of WINE from Microsoft.
- my123 10y agoIt's much more complete than Wine, it actually has the whole Windows graphics stack running, outputting over RDP ;)
- wolf550e 10y agoI wonder if the license for that only allows running specific applications.
- my123 10y agoThe PAL runner is actually locked down to run SQL Server only ;-) Trying to run another app, even reg or cmd, currently makes AppLoader crash. (AppLoader is the first .exe that is ran in the NTUM)
- ryandvm 10y agoInteresting. It seems to be based on Microsoft's "Drawbridge" research project: https://www.microsoft.com/en-us/research/project/drawbridge/ 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...
- womitt 10y agoAny valid use cases? No offence, was just wondering why would anybody use it...
- mootothemax 10y ago> 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.
- TheRealDunkirk 10y agoI 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 thing I see MSSQL on Linux being useful for is for development and testing purposes before deployment to a local server farm or the Azure cloud. (Even then, why not just run it on your Windows dev machine?) Honest question: What's the scenario where you'd license a system to run on Linux in production? To me, this is interesting, from the virtualization standpoint, but it seems like a solution in search of a problem.
- chunkiestbacon 10y agoIf MSSQL runs on a synology nas, then a lot of smaller companies can save a lot of money, because they wouldn't need a huge server anymore.
- hobarrera 10y ago> Even then, why not just run it on your Windows dev machine? A lot of devs don't understand/like windows enough to work on it. It's probably a lot easier to find *nix devs that windows devs.
- detaro 10y ago
- thinkMOAR 10y ago"It's astonishing but true - Microsoft really has figured out how to package software for Linux. \o/" It is not very difficult to create linux packages, writing microsoft has figured it out makes it sound as if its rocket science. It also sounds as if these packages are for 'linux' but the ones mentioned in the article are specifically for CentOS linux. And as far as i understand they only released packages for CentOS/REHL and Ubuntu. Not all linux distributions.
- stevekemp 10y agoI notice the installation-example is broken: sudo curl ... > /path/to/local/file That'll run the `curl` command with privileges, but the existing shell will handle the redirection, so writing beneath /etc, as in the example, will fail. The simpler approach is: curl https://horrid.site.sh/ | sudo tee /etc/blah/path
- winged 10y agoThanks a lot! Just fixed that line.
- stargrazer 10y agoAre there links to licensing costs? Are there regular client access license costs as well? So... if there are costs for licensing, then converting from postgresql to mssql is a little harder to swallow.
- antaviana 10y agoAFAIK, the costs and editions will be the same as in SQL 2016 (i.e. Express, Web, Standard, Enterprise).
- greggyb 10y agoThis is correct. SQL Server licensing is not changed. The major benefit is being able to share a single infrastructural OS for application and DB - it is not uncommon to see Linux app environment and Windows DB environment in a lot of large organizations. The secondary benefit is removing the Windows OS licensing cost.
- asah 10y agoHow's performance?
- my123 10y agoPerformance is fine.
- merb 10y agoExchange and AD would be huge. Unfortunatly Exchange needs IIS and probably an AD server.
- Beltiras 10y agoSAMBA has had an excellent track record of joining mixed OS environment AD forests for years.
- my123 10y agoIIS already runs on Drawbridge since a while AFAIK.
- mrmondo 10y agoWe replaced all our AD servers with SAMBA4, so much more reliable and while AD/LDAP is still a nightmare of an architecture having it running on standard Linux servers means it's much easier to monitor, backup, snapshot, introspect and it far out performs windows based DCs.
- hl5 10y agoMicrosoft is misfiring on another major computing trend. If you can't fork the code, you are missing an important feature.
- EvanAnderson 10y agoThis article feels like a long paraphrasing a Microsoft blog post [1] that was already discussed on HN[2]. I'm not seeing any new insights or analysis-- just restating of the points already made on the Microsoft blog. [1] https://blogs.technet.microsoft.com/dataplatforminsider/2016/12/16/sql-server-on-linux-how-introduction/ https://blogs.technet.microsoft.com/dataplatforminsider/2016... [2] https://news.ycombinator.com/item?id=13206438 https://news.ycombinator.com/item?id=13206438
- rb808 10y agoTo 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.
- godmodus 10y agounless 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.
- draw_down 10y agoIt's possible to come up with FUD regarding anything.
- MikusR 10y agoWindows subsystem for Linux does not have Linux kernel in it.
- frik 10y agoMS SQL Server database is a very old codebase. It dates back to Sybase SQL Server database (1980). Microsoft licensed and forked Sybase SQL in late 1980s and early 1990s and branded t as MS SQL Server. The strategic manoeuvre to get this database and basically got rid of a major vendor is not uncommon for MSFT: https://en.wikipedia.org/wiki/History_of_Microsoft_SQL_Server https://en.wikipedia.org/wiki/History_of_Microsoft_SQL_Serve... and additional background info: https://en.wikipedia.org/wiki/Ashton-Tate https://en.wikipedia.org/wiki/Ashton-Tate . Little has changed in the comming years, MS SQL kept the old SQL syntax for decades. Some interesting improvements came from the WinFS and XML teams (like full text search and refactoring to allow leaner editions - at one point it was planned to ship SQL Server (desktop ed) with Vista as part of WinFS update). Only recently with SQL Server 2014/2016 the very old and crufty syntax got some improvements. Or things like international date formats - remember it's a codebase from he 1980s, be happy with four non-standard non-ISO formats - things are getting better, but parts of the codebase slept for like 20 years with little love. On Linux there are Oracle, DB2, Postgres, MySQL, ... and in near future MSSQL too. Depending on the use case, choose wisely. There are many nice features in all of these databases, and several little documented dark edges that you better know about.
- dhd415 10y agoYou're misinformed about the nature of the SQL Server codebase. While it was originally licensed from Sybase, all parts of it have been completely re-worked. I read somewhere that they celebrated "zero Sybase day" or something to that effect in the early 2000s to mark the retirement of the last of the original Sybase code. Some more info here: https://blogs.msdn.microsoft.com/euanga/2006/01/19/sql-mythbusters-sql-server-is-really-a-sybase-product-not-a-microsoft-one/ https://blogs.msdn.microsoft.com/euanga/2006/01/19/sql-mythb... As for its performance and features, I have run PostgreSQL, MySQL, and SQL Server in production on large workloads and am a big fan of PostgreSQL. That said, I've encountered the fewest sharp edges and disappointments with SQL Server. It is a very respectable RDBMS and it's great that it's now available on Linux.
- pmelendez 10y agoThe main issue I have seen with SQL Server was a constant deadlock (every two weeks or so) over a table with high writes (peak at 800k per sec), which was annoying because the fail-back to the replica affected the DNS entries and meant 5-15min of outage. But to be fair it was an example of the wrong tool used badly in the wrong situation deployed in a poor environment.
- rodorgas 10y agoCan you configure MSSQL just editing files without a GUI, Unix-style?
- wedowhatwedo 10y agoYou've always been able to do that. Almost all configuration of MSSQL can be done via a script. I can't think of anything that you need to do on a day to day basis that can't be scripted.
- nemof 10y agoyep. i've been using this https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-connect-and-query-sqlcmd https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-...