Aaron Bertrand explains two good uses for using SQL Server containers:
I used this technique of “stop, drop, repeat” just the other day while testing some behavior around case-sensitive and binary collations at the instance level. In the old days, I would have had to install a second full-on instance of SQL Server in order to test a specific instance-level collation, then repeat for every collation in my set of tests. Yikes! With containers, this is much easier; I just have to add one additional argument to the
docker runcommand:
Check it out for a quick walkthrough of how to spin up a container and some good uses for it.