#1 most frequent
United States of America
52.5%7,816 installations of 14,890
What is Azure SQL Database?
Azure SQL Database is Microsoft's relational database as a service (DBaaS).
Categories & Use Cases
Product Demos
Top Performing Features
Automated backups
Automated backup enabling point-in-time data recovery
Category average: 8.3
Automatic host deployment
Compute instance replacement in the event of hardware failure
Category average: 7.3
Automatic software patching
Patches applied to database automatically
Category average: 8.7
Areas for Improvement
Database scalability
Ease of scaling compute or memory resources and storage up or down
Category average: 9
Database security provisions
Provision for database encryption, network isolation, and identity access management
Category average: 8.8
Monitoring and metrics
Built-in monitoring of multiple operational metrics
Category average: 6.7
Who Buys & Uses Azure SQL Database
#2 most frequent
United Kingdom of Great Britain and Northern Ireland
7.4%1,100 installations of 14,890
#3 most frequent
India
6.4%953 installations of 14,890
Azure SQL Database is truely a step forward
Use Cases and Deployment Scope
Azure SQL Database is a big step forward for us, as we no longer need to patch the database server or patch the operating system. It's a truely SQL-as-a-Service which allows dynamic up- and down scaling of the server. Gone are the tedious tasks to configure the DB, even Recovery is pre-configured.
Pros
- Up- and Downscaling
- Setup
- Backup and Recovery
Cons
- A SQL-Worksheet Tool in Azure Portal would be really nice
Return on Investment
- RoI is great
Usability
Alternatives Considered
Oracle Database and MySQL
Other Software Used
MySQL
Best In Class Database
Use Cases and Deployment Scope
Currently, we are using it for Microsoft PowerApps Business Applications and we prepared all the data models for Azure SQL Database. Its interface is easy to use and within less time we can create databases, add tables and prepare views, and immediately those databases are available for other applications which are already on the cloud.
Pros
- Available all the time.
- Robust database.
- All apps easily connect with it.
- Easy to create data models.
- Easy management.
Cons
- Table creation and addition of new columns.
- Add more datatypes.
Return on Investment
- Time saving.
- Easy connect.
- Spending less time to managed it.
- Easy interface for developers.
- Developer are available widely to work on SQL.
Alternatives Considered
frevvo
Other Software Used
PowerApps, Microsoft Teams, Microsoft Windows
Cloud-based relational database service that is both intelligent and scalable.
Pros
- With managed SQL in the cloud, you can build applications tailored to your business needs.
- Rapidly adaptable server less cloud computing and hyper-scale storage.
Cons
- Define smart plans to determine the price according to the needs and type of each business so that startups and small companies can benefit from it better.
- Develop more user-friendly UI wizard for migration SQL server
Return on Investment
- There is no need to change the codes during the migration to SQL and the cost of hiring a developer is saved
- At peak usage and workload, when resources are intelligently managed, there is no need to pay extra.
Alternatives Considered
Couchbase and Amazon Relational Database Service (RDS)
Other Software Used
Microsoft Azure, Microsoft Access, Microsoft 365 Business Premium
Microsoft Azure SQL Database - Good Value - Great Features!
Pros
- Azure SQL Database does a really nice job connection to the Power BI business intelligence service without the need for a data gateway for report refreshes.
- Azure SQL Database has a very easy upgrade path from a database to a data warehouse.
- Azure SQL Database has a simple billing structure.
Cons
- The Azure platform can be a little confusing sometimes with all the different options. Such is the Microsoft way.
- If you forget to put rate limits on your jobs, it's possible that your cost could explode.
- Learning the new Azure data tools to replace SSIS takes a while.
Return on Investment
- Our database costs have decreased over time by 20%.
- Our engineer spends much less time managing API calls with some of the new features available.
- Our engineer is planning on using the Power Query embedded feature to streamline some ETL processes.
Alternatives Considered
Microsoft SQL Server
Other Software Used
Microsoft Power BI, Microsoft Teams, Airtable
Microsoft Azure SQL Database: Fully Managed and secure SQL database
Pros
- It is fully managed and secure SQL database.
- It is highly available and scalable.
- It provides automatic backup and restore.
- Documentation of Azure SQL is perfect with all best practices.
Cons
- I would love to see some new sizes of databases for compute and storage.
- prices related to different size can be improved.
- performance can be improved to reduce the latency.
Return on Investment
- It was easy for our developers to setup and use this service.
- It has helped us in reducing the cost of managing SQL database.
- Its ability to scale up and down based on requirement is best.
Alternatives Considered
Amazon Relational Database Service (RDS), Microsoft SQL Server and Google Cloud SQL
Other Software Used
Amazon Relational Database Service (RDS), Google Cloud SQL, Microsoft SQL Server