* The cover image is originally by jarmoluk and edited with great appreciation.
Microsoft SQL Server is one of relational database management systems aka RDBMS.
It is available on Linux since SQL Server 2017 with both installation and Docker image.
This post shows how to install it on Debian 9 "stretch".
This post is based on the official guidance.
2GB RAM is absolutely required in order to run setup script after installing the package.
The others are here.
sudo command is also necessary in running setup script.
Therefore, install it and set it up:
# apt-get install sudo # visudo
Install other packages necessary as preparation.
$ sudo apt-get install curl
Add dependencies of
First, Install the security package:
$ sudo apt-get install apt-transport-https
Next, install older libssl.
/etc/apt/sources.list to add a line to the bottom like this:
+ deb http://ftp.debian.org/debian jessie main
Then install it:
$ sudo apt-get update $ sudo apt-get install libssl1.0.0
Here we're ready.
Let's add the repository:
$ curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add - $ curl https://packages.microsoft.com/config/ubuntu/16.04/mssql-server.list | sudo tee /etc/apt/sources.list.d/mssql-server.list
Then install it:
$ sudo apt-get update $ sudo apt-get install mssql-server
Run the setup script:
$ sudo /opt/mssql/bin/mssql-conf setup
You can follow the installer.
"Express" edition is free to use with limitations.
Finally, restart the service:
$ sudo systemctl restart mssql-server.service
In my early days as an engineer, I didn't imagine SQL Server would become free to use on Linux even with some limitations...🙂
Thank you for your reading.
Many development teams skip having a staging environment for their applications. We'll discuss some of the advantages of using a true staging environment and why they don't need to be complicated to set up.