Implement multiregional Azure SQL

[KSchlobohm]

The multiregional deployment should demonstrate how data is kept in sync between regions.

Azure SQL Database is used to store information about concerts, customers, and the tickets that they've purchased. This service stores this data and the relationships between this data to help customers shop for concerts and see their tickets when they login.

Without synchronizing this data, customers will not be able to see the tickets that they purchased. And, when the code runs in two regions it will randomly seed the data in a different order, so the concert details will not appear the same after a failover.

To address this concern we recommend two Azure SQL Features:

• Active geo-replication to synchronize data between the two regions
• Auto-failover groups to handle the failover of the system from one region to another

[KSchlobohm]

relates to https://github.com/Azure/reliable-web-app-pattern-dotnet/issues/44

[KSchlobohm]

relates to https://github.com/Azure/reliable-web-app-pattern-dotnet/issues/44

[KSchlobohm]

migrated to 1852450