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

VIEW FULL DISCUSSION
 

"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