How to create a unique column in SQL Azure Federation
You can only have uniqueness validation within a single federation, same as partitioned table allow for aligned uniqueness validation only within a partition (federations don't have an 'unaligned' equivalent). The solution is trivial: create a separate, non-federated,  Azure DB used only to validate email uniqueness.