Deploy SQL Server on Azure with Terraform – Managed Instance & Single-Instance
#SQLServer #Azure #Terraform #CloudDatabases #InfrastructureAsCode #Adminer
*Deploy SQL Server on Azure with Terraform – Managed Instance & Single-Instance*
In this video, we walk through deploying two different SQL Server options on Azure — a modern Azure SQL Managed Instance and the older Azure SQL Server single-instance model — all secured with private networking. You’ll see how to build a fully private, production-ready SQL Server environment step by step using Terraform.
What You’ll Learn:
How to provision Azure SQL Managed Instance and single-instance SQL Server using Terraform
Differences between Managed Instance and single-instance deployments
Best practices for private networking, NSGs, and route tables
Using Azure Key Vault to securely manage database credentials
Connecting with Adminer for browser-based SQL Server access
Automating the entire build with Infrastructure as Code
Resources Deployed:
Custom VNet, subnets, and route tables
Azure SQL Managed Instance (General Purpose Gen5) with private endpoint
Azure SQL Server single-instance with restricted firewall rules
Ubuntu VM with Adminer for managing SQL Server databases
Azure Key Vault with securely stored credentials
GitHub: https://github.com/mamonaco1973/azure...
README: https://github.com/mamonaco1973/azure...
Timestamps:
00:00 Introduction
01:49 Azure Diagram
03:34 Prerequisites
04:11 Build the Code
04:51 Build Results
09:36 Demo