This is the article I want::

These articles are just ancillary at best.

sqlcmd

Install the Microsoft ODBC driver for SQL Server (macOS) - ODBC Driver for SQL Server

Starting point::

Short, almost tiny blog post on getting sql server running on macOS & Apple Sillicon::

Running SQL Server on Apple Silicon - Updated

• Go to the project you are working on in IntelliJ
• Open the command line interface - will will land you in the project dir.
• Copy the docker run code below.

docker run \\
    --env 'ACCEPT_EULA=Y' \\
    --env 'MSSQL_SA_PASSWORD=S0methingS@Str0ng!' \\
    --name 'sqldemo1' \\
    --hostname 'sqldemo1' \\
    --publish 31433:1433 \\
    --volume sqldemo1:/var/opt/mssql \\
    --detach \\
    --platform linux/amd64 mcr.microsoft.com/mssql/server:2022-RTM-ubuntu-20.04

• Slight changes in mine::

docker run \\
    --env 'ACCEPT_EULA=Y' \\
    --env 'MSSQL_SA_PASSWORD=Butthead1' \\
    --name 'bluekyber' \\
    --hostname 'bluekyber' \\
    --publish 41433:1433 \\
    --volume bluekyber:/var/opt/mssql \\
    --detach \\
    --platform linux/amd64 mcr.microsoft.com/mssql/server:2019-latest

• This is what the more generic docker run looks like for mssql 2019

docker run \\ 
-e "ACCEPT_EULA=Y" \\ 
-e "MSSQL_SA_PASSWORD=yourStrong(!)Password" \\
-p 1433:1433 \\
-d mcr.microsoft.com/mssql/server:2019-latest

Source::

Microsoft SQL Server - Ubuntu based images by Microsoft | Docker Hub

• I didn’t understand how the —publish flag worked, so this was what I found, NOTE:: —publish and -p are the same flag::

  • publish 80:8080 told Docker to publicly expose port 8080 from the container as port 80 . By default a container is walled-off from the world, and this enables us to view the website hosted by our container.

  Source::

  | notebook.community

• So, my sql client out here in the real world will use 31433 as the port.