Let us learn how to install SQL Server on Linux in this quick blog post. I have recently worked with a client of Comprehensive Database Performance Health Check who wanted multiple installations of SQL Server on Linux. I have built this quick instruction list which they can just run on their Ubuntu Linux and get started immediately.
Step 1: wget -qO- https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add –
Step 2: sudo add-apt-repository “$(wget -qO- “
Step 3: sudo apt-get update
Step 4: sudo apt-get install -y mssql-server
Step 5: sudo /opt/mssql/bin/mssql-conf setup
Step 6: systemctl status mssql-server –no-pager
Step 7: hostname -I
Step 8: Connect via your SSMS using the IP address found in Step 7.
That’s it. We are done. You are all set up with your SQL Server on Linux and particularly Ubuntu Linux.
Let me know if you are interested to know more about this topic. I will write more blogs as well as create an SQL in Sixty Seconds video.
Here are my few recent videos and I would like to know what is your feedback about them.
- Query Ignoring CPU Threads – SQL in Sixty Seconds 161
- Bitwise Puzzle – SQL in Sixty Seconds 160
- Find Expensive Queries – SQL in Sixty Seconds #159
- Case-Sensitive Search – SQL in Sixty Seconds #158
- Wait Stats for Performance – SQL in Sixty Seconds #157
- Multiple Backup Copies Stripped – SQL in Sixty Seconds #156
Reference: Pinal Dave (http://blog.SQLAuthority.com)