Strict vs Eventual Consistency Model - Referential Integrity with Federations in SQL Azure

Referential Integrity in Federations Federation provide a great scale-out model with independent member databases. Even thought many local referential integrity rules are supported, federations place restrictions on costly referential integrity rules across federation members. Let me expand on that sentence; you can set up your familiar referential integrity with foreign keys between Customer, Orders and…