Description

SQL Server 2019 in containers are a fast way to get started with SQL Server 2019, and can be used throughout your data estate from development to production. SQL Server in containers are great because of their consistent, isolated and reliable behavior across environments, ease of use, and ease of starting and stopping. In this video, we'll talk about SQL Server 2019 in containers and how to get started with them.

Download captions

The Discussion

I did some experimenting with SQL Server containers earlier in the year and it is certainly very exciting. Actually I ended up using SQL Server 2017 containers because of the weired errors I was having with the 2019 images.

One point that triggered my curiosity was: does it make sense to try to create SQL Server containers that are availability group replicas? Would using containers mean we don't need AG anymore? This seems to make sense.

How does this affect SQL Certificate encryption and SPNs? I presume all registry information is within the container- does that imply any server that will be used to run such a SQL container will have to already have the certificates installed, and that the SQL configuration will need the acceptable SPNs list to include the server name....or can these all be modified at the commandline when loading the container?