re: The Great Migration: From SQL Server to AWS Aurora VIEW POST


"In SQL Server everyone could see everything, so everyone could potentially delete anything

We made the conscious decision to create a schema for each function so they have a dedicated place to write their tables. Analysts then grant access to tables they want to share because everyone shouldn’t have access to everything"

That's a critique of your original database design, but it reads like a limitation of the SQL platform.

I'd love to get my teeth into some cloud database projects but all the companies I work on cannot allow their data to be hosted on the cloud and insist on in house SQL servers segregated from the internet.

code of conduct - report abuse