SQL Server on Linux

科技动态 2017-06-16 阅读原文

When Wim Coekaerts, Microsoft's vice president for open source, took the stage at LinuxCon 2016 in Toronto last summer, he came not as an adversary, but as a longtime Linux enthusiast promising to bring the power of Linux to Microsoft and vice versa. With the recent launch of SQL Server for Linux, Coekaerts is clearly having an impact.

for Linux and bash for Windows
heralded the beginning, but the arrival of SQL Server, one of the most popular relational databases out there, offers Linux shops some real opportunities—and a few conundrums.

Clearly, the opportunity to deploy SQL Server on something other than a Windows Server means you can take advantage of the database's capabilities without having to manage Windows hosts to do it. If you're a mostly-Linux shop (or want to be) and you have customers looking to deploy workloads and applications that require SQL Server, you now have a true Linux solution.

At the same time, if you're big enough to have cabinets full of database server hardware, you probably have databases that serve real-time workloads and databases that underpin your data warehouse. If you're running the latter on beefy hardware necessary to manage the overhead of both Window Server and SQL Server, the advent of SQL Server on Linux might give you an alternative.

For instance, you might shift your lower-resource data warehouses to resource-sipping Linux servers with SQL Server. That could save you on hardware and migration costs, given that there are no structural differences between SQL Server running on Windows or Linux.

If you were contemplating shifting your data warehouse from SQL Server to MariaDB or Oracle to take advantage of Linux hardware savings, you wouldn't have to fret about the conversion costs. Even though you'd still pay for SQL Server licenses, you could save on the costs to convert and migrate to make up the difference.

On the conundrum side, you may ask why you might need Microsoft's offering at all. Afterall, open-source databases like MariaDB
(or MySQL
) and PostgreSQL
are robust, well tested, free and supported by large communities. Why introduce a historically closed-source proprietary tool to your open-source environment? SQL Server 2016 Standard lists for about $3,717 per core
, though the Developer and Express versions are free, with Express able to handle up to 10GB for your data-driven applications.

Since none of us lives in an ideal, pure-Linux world, the fact is there are times in the enterprise when you can—or must—use SQL Server. There's a lot of solid, legacy software out there that uses the Microsoft database for the back end, which means given the choice, many of us would like a Linux option.

Fortunately, you can try it out without really breaking a sweat. You can install SQL Server on Red Hat Enterprise Linux 7.3, Ubuntu 16.04, SUSE Linux Enterprise Server v12 SP2 or pretty much anywhere as a Docker

Installing and Running

To get a taste of SQL Server for Linux, I decided to run it from a Docker image running on a separate Ubuntu 16.04 box with well more than the 4GB of RAM and 4GB of storage required. I set it up on a remote Linux host so I could test remote connections.

Pulling SQL Server from Docker is trivial:

$ sudo docker pull microsoft/mssql-server-linux

Depending on your network speed, this will set up the image in just a couple minutes. When the pull is complete, you can start the SQL Server container from the command line with a few straightforward parameters:

$ sudo docker run -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=(!)Superpassword' -p
1433:1433 -d microsoft/mssql-server-linux

Note that the command includes a tacit "Yes" to Microsoft's End-User Licensing Agreement and that the server is running on the common SQL Server TCP port 1433. The password must meet Microsoft's minimum guidelines; if not, the container will start, but then quit after about two seconds.

Linux Journal

责编内容by:Linux Journal阅读原文】。感谢您的支持!


FIX: VMM won’t start, error 1067 I’ve recently configured VMM in the restricted environment where you always need to ask IT staff to delegate rights for ...
MIRAI OKIRU——历史上首个针对ARC CPU的Linux恶意软件... 2016年8月, 来自 @ MalwareMustDie 团队的研究人员 @ unixfreaxjp 率先发现了可怕的僵尸网络Mirai,现在这位研究人员在恶意软件社区 宣告了 新的重大事件。 unixfreaxjp有史以来第一次发...
uCOS-II中任务的优先级翻转现象 优先级翻转是RTOS内核所要面临和解决的问题,再继续源码阅读之前需要先了解一番。本文参照网上以及相关书籍,对优先级翻转扼要介绍。 1. 什么是优先级翻转 什么是可剥夺型内核?若当前进程只是在进程执行结束,或者因某种原因而自动放弃CP...
Plan your own holiday calendar at the Linux comman... Welcome to today's installment of the Linux command-line toys advent calendar. If this is your first visit to the serie...
JAVA学习笔记19——MyBatis框架第二章 接着昨天的MyBatis入门程序来讲,今天我们来讲一下MyBatis的高级用法,例如动态sql查询,关联查询,整合Spring框架,希望对大家能有所帮助。 1、动态sql 通过mybatis提供的各种标签方法实现动态拼接sql。 ...