Latest Updates on MS SQL Server on Linux

[mlnews]

https://www.channele2e.com/2016/10/21/microsoft-ceo-offers-sql-server-on-linux-update/

“Overall, we are very, very excited about what we are seeing with SQL on Linux because the entire idea was to be able to have a full conversation around the data [across Windows and Linux] with customers,” Nadella said on the earnings call. “One of the related conversations involves our analytics and advanced analytics. We’ve done some very, very compelling work again across Linux and Windows and then of course the cloud.”

In many circles, SQL Server on Linux is considered Microsoft’s answer to Oracle on Linux and Unix. Microsoft in March 2016 introduced a “free” SQL-on-Windows offer to counter Oracle. It’s a safe bit Microsoft will make a similar SQL-on-Linux offer when that database arrives in mid-2017.

[JaredBusch]

I signed up to get emails on this product, and received this email today.

[scottalanmiller]

Cool. Slow progress, but I'm sure that they have tons of work to do.

[travisdh1]

I think someone needs to look up the definition of conversation.

[JaredBusch]

The public preview of SQL Server on Linux has arrived!

[JaredBusch]

Installation insructions

Official RHEL instructions from the above link.

They have packages for RHEL and Ubuntu.

SQL Server

sudo su
curl https://packages.microsoft.com/config/rhel/7/mssql-server.repo > /etc/yum.repos.d/mssql-server.repo
exit
sudo yum install -y mssql-server
sudo /opt/mssql/bin/sqlservr-setup
systemctl status mssql-server
sudo firewall-cmd --zone=public --add-port=1433/tcp --permanent
sudo firewall-cmd --reload

Tools

sudo su
curl https://packages.microsoft.com/config/rhel/7/prod.repo > /etc/yum.repos.d/msprod.repo
exit
sudo yum install mssql-tools

[scottalanmiller]

@JaredBusch Sweet!