Deploy SQL Server on Google Cloud with Terraform – Cloud SQL Edition
#SQLServer #GCP #Terraform #CloudDatabases #InfrastructureAsCode #Pagila
Deploy SQL Server on Google Cloud with Terraform – Cloud SQL Edition
In this video, we walk through deploying Microsoft SQL Server on Google Cloud using Cloud SQL, a fully managed relational database service. You’ll learn how to build a secure, private SQL Server environment from the ground up using Terraform.
What You’ll Learn
How to provision a private Cloud SQL SQL Server instance with Terraform
Best practices for VPC design, private service networking, and DNS
Deploying the Pagila sample database for realistic testing
Connecting with Adminer to explore your data via a web UI
Isolating SQL Server from the public internet for maximum security
Resources Deployed
Custom VPC and subnet
Private VPC Service Controls for Cloud SQL
Private DNS zone and A record for internal name resolution
Microsoft SQL Server Cloud SQL instance (private IP only)
Ubuntu VM with Adminer for browser-based SQL access
Secure password generation for database authentication
---
GitHub: https://github.com/mamonaco1973/gcp-s...
README: https://github.com/mamonaco1973/gcp-s...
---
00:00 Introduction
01:29 GCP Diagram
03:08 Prerequisites
03:58 Build the Code
05:49 Build Results
08:38 Demo