• Schemas would work just as well in this example. I opted for the separate databases because it was easier to explain to management in my organization rather than getting into how schemas keep things separate, and the permissions are a bit easier (not much, just a bit) to manage. I also forgot to mention that the enterprise data warehouse is named EnterpriseDW so it is seperate from AccountingDM and HealthDM. The DM databases live on the same server as the DW, and yes, some views are redundant so I just script the view as Create To, copy and paste the code, and adjust the filters to deploy.

    If I ran into a situation where I needed to change the query definition, I could script that via T-SQL with CREATE VIEW statements to push that out. Unfortunately, politics plays a much larger role in some decisions than we would like.