Getting ready

In this recipe, we are going to spin up a Docker instance of a SQL Server database. To get started, you must install Docker.

The next step is to build and run a SQL Server database using docker:

docker pull mcr.microsoft.com/mssql/server:2017-latest 

 Then, run the Docker container:

docker run -e 'ACCEPT_EULA=Y' -e 'MSSQL_AGENT_ENABLED=true' \
-e 'MSSQL_PID=Standard' -e 'SA_PASSWORD=Password!' \ 
-p 1433:1433 --name sqlserver_1 \ 
-d mcr.microsoft.com/mssql/server:2017-latest 

Once you've done this, click on the new SQL Server tool in the left panel. Then, click on the plus (+) button...