Aboutsqlserver.com Website Review

I am heavily relying on virtualization in my home lab. I prefer to build separate SQL Server environments for different projects keeping them clean and isolated from each other. I can work with multiple SQL Server versions side by side without worrying how some components in This setup is also great for presentations and trainings I deliver. I just need to reset VM to the “starting” checkpoint and everything would be in the known and healthy state. Believe me, this saves you from a lot of pain and embarras*ment when you are staying in front of people. Troubleshooting of non-working demos is not fun when you are on the stage. There is the problem with this setup, however. It is much easier and faster to checkpoint existing VM rather than provision the new one for the new setup. In the end, unless you have self-discipline I lack, you may end up with something like shown in Figure 1 below. This is the On the surface, this setup may provide you required isolation between environments. However, there is the problem with maintainability. Consider how much efforts it would take to apply new SP or CU to all of your checkpoints. In the end, you will be in the situation when you always want to rebuild your lab and you never have time to do it properly.  Thus, I decided to look at other options and evaluate Docker and SQL Server in containers when I recently had to setup the new travel laptop. I found that containers are better suited to my needs comparing to VM-based virtualization and I want to share my experience with you. As the disclaimer, I am going to focus on the infrastructure side and maintainability and not going to discuss underlying technologies and While both, containers and VMs rely on virtualization, they are conceptually different on the infrastructure side. Figure 2 active at any giving point of time. Neither could you run multiple instances of the single VM simultaneously – you’ll need to clone Containers, on the other hand, operate differently as shown in Figure 3. The environment consists of multiple images, which conceptually