Summary

In this lesson, we learned about database features, Azure SQL Data Sync, online and resumable DDL operations, and SQL Graph.

Azure SQL Data Sync is an easy-to-set-up process of syncing data between two or more Azure SQL databases, or an Azure SQL database and an on-premise SQL server. Data Sync can be used to support cloud migration or to offload reporting workloads.

Resumable DDL operations allow CREATE INDEX and REBUILD INDEX tasks to be paused or resumed as and when required. This helps when we need to recover from problems wherein a long-running CREATE INDEX or REBUILD INDEX statement causes blocking and slows system performance.

SQL Graph Database capabilities provide a flexible and easy way to implement many-to-many relationships or hierarchies.

With this, we have learned how to successfully set up an Azure SQL database, migrate our data from an on-premises database to provisioned cloud databases, how to scale these databases as per our requirements, and how to manage the cost...