Running a PowerShell script to set up Docker containers

Over the last few chapters, we saw how PowerShell scripts are powerful automation solutions. In this recipe, we are going to use a PowerShell script to manage Docker containers.

In this recipe, three SQL Server docker containers are created and tested within a span of 10–15 minutes. The sample script shows how easy it is to integrate Docker CLI commands with a PowerShell script.

How to do it...

To create a PowerShell script, follow these steps:

1. Create a PowerShell script file using a code editor:

PS> vim SQLInstance.ps1

2. Define an array of elements [1,2,3] as input for the Foreach-Object loop cmdlet.
3. Prepare the SQL container names (such as PackPubDemo1, PackPubDemo2...