Comments
Sort by recent activity
I have read that first article. But okay here is an example, mistake by a teammember of mine and they checked in permissions, while the DLM Automation task to build a database package fails because the role does not exist on an object whose permissions were checked in. What should be done to prevent that? Check in filters? What if the dev mistakenly doesn't have them, what is the recommendation on this? / comments
I have read that first article. But okay here is an example, mistake by a teammember of mine and they checked in permissions, while the DLM Automation task to build a database package fails because...
I am using this in day-to-day SQL development. But as a younger DBA I am not constrained to old habits.
Although SqlOps is still not at v1 I would like to see this tool investigated again for Redgate. Some days our CI requires me as a DBA to jump through SSMS, DLM Dashboard, and lastly Powershell to ensure I correct a problem in deployment. SqlOps offers the extensiblity to allow me stay within one tool. Possibly adding a custom dashboard which mimicks DLM Dashboard within SqlOps.
I think the most important thing for me is that one of my databases in source control have so many objects that we run into the SSMS x32 bit issues. Just "getting latest" causes memory issues requiring our team to use the Large Address Aware app, disable some other Redgate extensions, and SSMS intellisense in order issue a Redgate source control "Get Latest". This causes lots of slowness and disruption to development, devs and DBAs. This could be a tool which offers a GUI way solution to that problem. / comments
I am using this in day-to-day SQL development. But as a younger DBA I am not constrained to old habits.
Although SqlOps is still not at v1 I would like to see this tool investigated again for Redga...
dbo role or db_owner? I agree with Dlyes, and am having the same issue where permissions outside of sysadmin seem to fail. My error with SQL Change Automation Build - Build database project from source control throws an error "login failure" (abbreviated). I know the account can login so the error should be more helpful like cannot apply security permissions. / comments
dbo role or db_owner? I agree with Dlyes, and am having the same issue where permissions outside of sysadmin seem to fail. My error with SQL Change Automation Build - Build database project from so...