Deploying MSSQL to production poses unique challenges, particularly in the Linux world.

Today, we're presented with secure architecture using Kubernetes Network Policies and SQLPackage Linux version, revolutionizing the deployment landscape.

Network policies will open and close the target SQL server access dynamically during only deployment.
SQLPackage will generet deployable SQL script to the target server.
In addition, SQL 2022 provide extra layer of Azure Authentication to the target server.

All 3 of them together make secure deployable pipeline for SQL server on production.

Join me as I unravel the intricacies of these components and demonstrate their seamless integration, paving the way for secure connections to production SQL servers.