On July 12th 6.30 PM PST, I will be presenting “SQL Implementations On Containers” @ at San Francisco data platform user group, if you are in the area I hope to see you…
Location: Microsoft, 555 California, San Francisco 94104
Session: SQL Implementations On Containers
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 containers. It provides an isolated, resource controlled, predictable and portable operating environment inside a VM.
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. No matter how you currently deploy SQL Server on Linux or Windows, containers are now the way.
Prakash Heda will demo the installation of five SQL Server implementations. He will show you how containerization solves the “dependency hell” problem by incorporating software dependencies into a container image and providing smooth application deployment.
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 inside Windows 16 container using Docker