SQL Implementations On Containers

< This meeting is at 555 California Street >

No matter how you currently deploy SQL Server on Linux or Windows, containers are now the way!

On July 12th, Prakash Heda will demo the installation of five SQL Server implementations. You'll see how containerization solves the “dependency hell” problem by incorporating software dependencies into a container image and providing smooth application deployment.

Windows Server 2016 containers have started a new era which will help with VM consolidation. The future of SQL Implementations is about installing SQL Server on Windows 2016 NANO Servers running as containers. It provides an isolated, resource controlled, predictable and portable operating environment inside a VM.

You'll learn how:

• To install five SQL server implementations in 5 minutes, with each dedicated SQL implementation taking 15 GB of space

• Containerization helps rapid deployments for continuous integration

• SQL Server inside a container can run without affecting the rest of the system

• SQL Server containers can be implemented today

• To create SQL Server containers on Windows 16 NANO server using Docker

You may remember the physical server consolidation phase started with VMs, and the struggle to run SQL Server on VMs with predictable performance. Since than, this is biggest change to the way SQL Server will be installed. Windows Server 2016 introduced container support, headless NANO servers, and SQL server 2017, with complete support for creating containers using Docker, a defacto industry standard API for container packaging that allows running SQL Server as micro-services. Docker has industry-wide support with hosted services on Azure/AWS, monitoring, logging, and orchestration.