Monthly Archives: January 2015

Post-upgrade DB Comparison

There are plenty of tools out there you can use to compare two versions of a database. Perhaps you use one all the time (tell me about it in the comments if you like!), or perhaps you find yourself wondering what exactly has changed after each upgrade. If you fall into the latter camp, I have just the script for you.
Continue reading

The Anonymizer, part one

I’m sure most, if not all of you have multiple environments. We have four: production, test, development, and train. Every quarter, we refresh our test, dev, and train environments with a fresh copy of the production database, just to be sure everything matches up as well as possible.

About a year ago, we decided to start anonymizing our train database. This was initially motivated by multiple requests from staff members who didn’t want trainees potentially seeing their information, which is perfectly valid. We suggested simply making those charts sensitive, but a number of employees wanted their data removed entirely. We certainly want to respect people’s privacy, so figuring it was better to go to the extreme than not go far enough, we decided to go for the nuclear option.
Continue reading