Failover
- Business Continuity and Failover (BCDR) for Databases have the failover option
- In On-Premises generally failovers are manual (i.e. a DBA has to Performance)
- In Cloud, We have ways where failover can be automatic
Geo Replications
- Can be used to replicate the data in azure sql database from one region into any other region
- In the portal azure gives you recommendation to the paired region
- In Geo-Replication Failover is manual
- Geo-Replications are performed at Database Level
Failover Groups
- Now Navigate to you sql server
- Failover groups can be added at sql server level and the failover can be made automatic
Data Sync (Hybrid Cloud)
- Syncronize Data between on premise sql servers to Azure SQL can be done by install Data Sync agents
- Refer Here for SQL Data Sync and refer here to Setup the azure sync
Pricing (DTU vs vCore)
- DTU is metric defined by microsoft which is combination of CPU+RAM+IO
- This is a confusing measure, so microsoft had to introduce the vCore model which speaks about CPU COres and Speed in the terms which we generally use (Contd..)
