Currently I am working in an organization, where development and production databases reside in the same SQL Server instance. The main reason for this is ease of management: updates for SQL Server need be applied to less instances and it is easier to move developed objects from D to P...
License costs is mentioned in passing, but they acknowledge this is not a big issue.
Security and autorization is also not an issue, because the people responsible are very careful and know what tehy are doing...
I am looking for arguments in favour of an OTAP, and I realize it si not neccesserry to go to extremes if you ahve a small orgainazarion. My main argument is, I am a fanatical believer in Murphy. Sooner or later the risks of having different environments merged will come to frutations. To me lessening risks is paramount.
What are the thoughts of collegues? Always OTAP? Or it depends on circumstances? Or not really neccesserry?