Why Azure SQL Server DB?
Some of the Benefits of Azure SQL are:-
- Pay-as-you-go pricing model
- Spin up a server in seconds
- No patch upgrade required
- Elastic Scale up and down
- Up to 4 TB Storage
- Manage Users vai Azure Active Directory
- Monitoring via Portal e.g. you can monitor - DTU usage, Memory usage, Total connections failure, total connection requests, current connections, Current users sessions etc.
- Geo Replication
- 99.9% up time SLA
- Data encrypted in motion and at rest
- Backup/Restore from one premise to Cloud
- Integration with other Azure services e.g. ADF, AML, Power Bi etc
- Automatic performance tuning & treat Detection