Roles, Schemas, and Drops Oh My!

I recently ran into an issue where a development manager was creating a new role in SQL for his data warehouse initiative and cube building. He granted the role ownership of a newly created schema then changed his mind on what he wanted regarding a few items. I provided the explanation to him that I had ran …

Continue reading Roles, Schemas, and Drops Oh My!