Installing Microsoft SQL Server on your Mac with docker

#sql #mac

https://www.londonacademyofit.co.uk/blog/installing-sql-server-on-mac-using-docker
From Terminal run command –

docker pull microsoft/mssql-server-linux docker run -d --name MySQLServer -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=Password123@jkl#' -p 1433:1433 microsoft/mssql-server-linux

Name can be any custom name of your choice
Password can be of your choice provided it is the combination of uppercase, lowercase, numbers and special characters
Download azure data studio from https://docs.microsoft.com/en-us/sql/azure-data-studio/download?view=sql-server-2017

Open azure data studio and provide connection parameters:
host: localhost
authentication type: SQL Login
user: sa
password: Password123@jkl#

Or use tablePlus: