Azure Classroomnotes 13/Dec/2022

Azure SQL Database Continued

  • Azure SQL Replications and Failovers
    • Replication is a technique where data gets replicated across other database.
    • Replication is used to mitigate performance issues by redirecting all the reads from secondary database and all the write operations from primary database.
    • Read operations are also used for Analytics.
    • Lets create an Azure SQL Database
      Preview
    • Now lets create a replica
      Preview
      Preview
      Preview
    • Replications are of two types
      • synchronous Replications
      • Asynchronous Replications
    • Azure supports autofailover using failover groups which can be configured on server
      Preview
      Preview
      Preview
      Preview

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

About continuous learner

devops & cloud enthusiastic learner