Yes! The doors are finally open for all interested in trying SQL Server for Linux. This is the first preview version and there are more to come. This was announced at the Microsoft Connect() event today.
Go to this Link which is very well documented and download SQL Server for you Linux Disto:
https://www.microsoft.com/en-us/sql-server/sql-server-vnext-including-Linux#resources
You can start connecting to your Linux version using the latest SSMS and even use PowerShell from your Windows desktop.
Go and Get It!