- Azure SQL Database is a Database as a service offering on Microsoft Azure.
- It aims to reduce the cost of running database infrastructure.
- The service is billed by the hour, based on the service tier of the database.
- The service is easily provisioned through different methods.
What is Database as a Service (DaaS)?
Daas is a public cloud offering defined by 3 fundamental characteristics.
1. The Service provider owns and manage the database software, admin task like backup/restore and high availability, the operating system and hardware.
2. The service users pay according to their usage of the service. There is no upfront expense or contract lock-in unless the user wants it.
3. Users can scale up or down on demand and also create and destroy environments on demand with no provider intervention.
Billing Model
1. The Service is paid by the hour.
2. The hourly rate is based on the highest service tier selected during that hour.
As a DBA, What is your responsibility?
When SQL Database on VM:
1. Maintain the Operating System.
2. Maintain SQL Server Services and its Databases.
3. Setup Backups
4. High Availability
5. Disaster Recovery
6. Change Control, performing changes on production with minimal downtime.
7. Performance, have to ensure database is providing good performance
8. Security, database should be secure.
When SQL Database on MS Azure:
1. Choosing the right service tier.
2. Test the High Availability and Disaster Recovery Strategy.
3. Change Control, performing changes on production with minimal downtime.
4. Performance, have to ensure database is providing good performance
5. Security, database should be secure.
Advantages of MS Azure SQL Database
1. Pay for what you use by the hour.
2. No need to maintain hardware, virtualization, Operating System Or database software.
3. Scale Up Or Down the resources on Demand.
No comments:
Post a Comment