Azure SQL Database - a modern cloud solution
Overall Satisfaction with Azure SQL Database
Azure SQL database can be used to replace traditional onsite SQL Server databases. It is a fit for many different business funtions within many different verticals and horizontals.
Pros
- The newest SQL Server features and functions are pushed to the service, so unlike onsite SQL there is never a need for upgrading.
- Azure SQL database does not require onsite infrastructure.
- Because this is a cloud solution, you will never need to patch the Operation System, install a service pack, or install an update.
- Unlike onsite databases, scaling up or scaling down is very easy with Azure SQL database.
Cons
- Azure SQL database does not contain the SQL Agent service, so if jobs needs to be scheduled you still need to do this using a traditional SQL Server.
- Given that there are 10 different pricing options, It can be difficult to determine which one to select.
- The bigger your organization, the more ROI you are going to see with Azure SQL db.
- Moving to Azure SQL db will free up your DBA to work on the backlog of projects that often never get done because they spend a lot of time maintaining and monitoring onsite SQL.
- Generally speaking, Azure SQL database is less work and less responsibility relative to onsite SQL Server or any onsite database.
If you are a company that is already invested in Microsoft technologies, then the Azure suite is a better fit than the Amazon suite.
Comments
Please log in to join the conversation