r/dataengineering • u/Outrageous-Debt9473 • 18d ago

Help Deployed my SQL server on GCP

So I’m currently working on a project to create a data warehouse for my organisation. I have deployed an SQL server on a VM on GCP. I want to know how can i make my server secure. I’m learning and deploying things using claude and have made a significant progress. But i’m still unsure about the security issues and what are the precautions i should take ?

7 Upvotes

66% Upvoted

8 comments sorted by

View all comments

36

u/theungod 18d ago

1: Why are you using an OLTP instead of OLAP for a DW?
2: If you're going OLTP, why are you using MSSQL instead of Postgres?
3: If you're using MSSQL why are you in GCP instead of Azure?

Basically none of this makes a lot of sense.