To add another datapoint: I work for a large medical device manufacturer. We often need patient databases for debugging problems in the field. Although everyone who gets access to the raw data is HIPAA trained periodically (if your training expires, so do your data access credentials) we have implemented a "download database" feature that scrubs all patient identifying data before it's transmitted over the line.
Sure, there may be some edge cases where we need that ID stuff (haven't come across it in the years we've been doing this), but the point is that we take patient confidentiality very seriously (and the business takes being dinged for a HIPAA violation just as seriously).
It may sound fluffy and Pollyanna-like, but it's hard to be successful in this field without genuinely caring about the patient at the other end of your software.