My old development team is hurting for resources. I got assigned to give them a hand. There were some production problems they could not replicate. They searched the source code, but could not come up with any definitive answers.
I spent the morning scanning the source code as well. However I have access to the production database. This allowed me to ensure the applications were behaving correctly. The other developers on the team did not have production access.
Now I can understand you don't want everybody looking at production data. But if you want your developers to be able to solve problems fast, give them read only access to production data. If can be the difference between solving a problem in a few hours, versus floundering around for a few weeks or a few months.
Perfomance for Dropping a Column - I am working on some experimental routines to analyze hash functions. The big idea is to generate a lot of hashes. Of course I am storing them in a databa...