Do you have some good articles on database migrations in production ? I've had some bad experiences, e.g: a delete locking for a long time and no one being able

Do you have some good articles on database migrations in production ? I've had some bad experiences, e.g: a delete locking for a long time and no one being able to use it :D