Install SQL Server tutorials under Ubuntu _mssql

Microsoft has just announced a public preview of the next generation of SQL Server, and Canonical has officially announced that this preview is available for Ubuntu systems. Whether used internally or in the cloud, SQL Server on Ubuntu provides developers and organizations with a more liberal choice. The development language and data types allowed by SQL Server also become one of the most innovative and flexible platforms available to the marketplace.

In the next generation of SQL Server, Microsoft provides more powerful features for Linux and Windows platform SQL Server, including support for the Docker container. Additionally, SQL Server on Ubuntu can significantly reduce costs, improve performance, and easily expand and deploy additional storage and computing resources without adding more hardware.

Cost: Organizations can leverage the flexibility and cheap resources of the Microsoft Azure platform to bring many cost benefits, resources can be allocated on demand and reduce costs when not using the platform-inactive resources are not billed.
Performance: In the cloud, resources that manage database workloads are optimized on demand. By using service model solutions such as Docker and Canonical juju, organizations can improve the performance of their workloads and improve the speed and efficiency of deploying data-centric solutions.
Scalability: The promise of the next generation of SQL Server is to allow DBAs to build large, Microsoft Azure based databases without adding additional hardware. By including support for Linux containers such as Docker processes or Canonical LXD container, organizations can transcend traditional efficiencies, while Canonical and Microsoft's combination of Ubuntu, SQL Server, container, and Azure platforms brings A very consistent Linux cloud experience.

Earlier this year, Microsoft announced the SQL Server on Linux program, and Canonical continued to work with Microsoft to bring the best Linux systems into the Microsoft platform. "Microsoft and Canonical continue to build bridges between the Windows world and the Linux world," said Dustin Kirkland, Canonical technology director. SQL Server on Ubuntu is another example of this trend. 」

Install SQL Server on Ubuntu

The current Microsoft released SQL Server on Linux version for SQL Server Vnext CTP1, has supported the Red Hat Enterprise linux 7.2b and Ubuntu 16.04 systems (SUSE Linux Ente Rprise Server V12 SP2 is also coming soon), let's take Ubuntu 16.04 as an example to describe how to install a deployment.

Copy Code code as follows:

#导入公共存储库GPG密钥
Curl HTTPS://PACKAGES.MICROSOFT.COM/KEYS/MICROSOFT.ASC | Apt-key Add-
#注册Microsoft SQL Server Ubuntu repository
Curl Https://packages.microsoft.com/config/ubuntu/16.04/mssql-server.list >/etc/apt/sources.list.d/ Mssql-server.list

#安装SQL Server on Linux
sudo apt update
sudo apt install-y mssql-server

After the package installation is complete, run the configuration script and follow the prompts:

sudo /opt/mssql/bin/sqlservr-setup

Enter the password for your SA account, as indicated in the figure:

After the configuration is complete, verify that the service is running:

systemctl status mssql-server