We have multiple use cases for this solution, and it really depends on the application team requirements. Our analytics team uses it. We also use it for database migration.
Manager at UPL
Scalable and stable SQL database solution that's easy to install, with good technical support
Pros and Cons
- "Database services and Active Directory related functions for this solution are good. Stable, scalable, and easy to install. Its technical support is good."
- "Integration needs to be improved for this solution."
What is our primary use case?
What is most valuable?
What I found most valuable in Azure SQL are the functions related to Active Directory and the database services. You can do everything in Azure SQL.
What needs improvement?
Integration needs to be improved for this solution.
For how long have I used the solution?
We've been using Azure SQL since 2013.
Buyer's Guide
Microsoft Azure SQL Database
January 2025
Learn what your peers think about Microsoft Azure SQL Database. Get advice and tips from experienced pros sharing their opinions. Updated: January 2025.
832,138 professionals have used our research since 2012.
What do I think about the stability of the solution?
Azure SQL is a stable solution.
What do I think about the scalability of the solution?
Azure SQL is scalable.
How are customer service and support?
We had to contact technical support about some of our issues, and it was good. They have good people.
How was the initial setup?
Installation for this solution is very easy, but you'll need to be a certified installer to find the setup easy.
What about the implementation team?
We implemented Azure SQL through an integrator and data partner.
What's my experience with pricing, setup cost, and licensing?
Azure SQL has licenses which you can pay yearly or monthly. You have the option to pay yearly or monthly for the license.
What other advice do I have?
Microsoft Azure is something that we are using. We are using Microsoft Azure from the Cloud. It's the public cloud we are using. We use multiple services on Azure, e.g. mDNS, Traffic Manager, Database, etc., depending upon the attributes and aspects. We're using Azure SQL.
We have a cloud team made up of 10 people who use this solution, then there are various application teams that also use Azure SQL. At the moment, we have no plans of increasing usage for this solution, but we're open to it.
I would recommend this solution to others looking into using it.
I'm rating Azure SQL a 10 out of 10.
Which deployment model are you using for this solution?
Public Cloud
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Microsoft Azure
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Development manager at Amdocs
Offers detailed information available for different formats and the high data availability
Pros and Cons
- "The data availability and speed are impressive, especially compared to legacy systems. The loading speeds are much faster on Azure SQL."
- "The user interface (UI) could be more flexible."
What is our primary use case?
I work for a service-based company that helps businesses migrate their applications to the cloud. So, we're implementers. We help with the migration process.
We primarily use Azure SQL when migrating data from legacy systems to the cloud based on customer preferences. If customers are looking for an Azure solution, we often recommend a Dedicated SQL pool based on their specific requirements. This allows them to store their data in cloud storage services and access it easily through the database.
What is most valuable?
Specifically for Azure SQL, I appreciate the detailed information available for different formats and the high data availability.
The data availability and speed are impressive, especially compared to legacy systems. The loading speeds are much faster on Azure SQL.
And for other Azure databases like Snowflake, the various features are helpful for development and testing. They allow us to create environments easily and with minimal cost, while maintaining high availability.
What needs improvement?
The user interface (UI) could be more flexible. It's not that the data access or storage format is bad, but the UI feels clunky and isn't up to par with other tools.
For how long have I used the solution?
I've been using Azure SQL and Synapse for the past two years. It's also known as a dedicated SQL pool. That's the one we're using for data warehouse support.
For the past two years, I've been using both Azure Synapse Analytics and Dedicated SQL pool, writing code, and utilizing other Azure services. But these two are the ones primarily related to data warehouses and databases.
What do I think about the stability of the solution?
Stability is high. We haven't faced any outages or downtime during my time using it. So, I'd give it a nine out of ten for stability.
What do I think about the scalability of the solution?
We did have some issues with data backups. Unlike traditional systems where backups were routine, with SQL Azure, managing data backups became an additional task. So, there have been issues with replication. But apart from that, scalability has been good.
I would rate the scalability an eight out of ten. We have enterprise businesses as our clients.
Which solution did I use previously and why did I switch?
I also use Snowflake, which is an individual cloud database. I have experience with other cloud data warehouses like Azure Data Factory, Azure Synapse Analytics, and SQL databases. I use Synapse and upload SQL code to it.
How was the initial setup?
I would rate my initial setup a nine out of ten, where one is difficult and ten is easy. So, the setup is easy.
What about the implementation team?
Deployment took an hour.
What was our ROI?
My clients have seen an ROI.
What's my experience with pricing, setup cost, and licensing?
Compared to other providers, it's definitely on the affordable side.
What other advice do I have?
Overall, I would rate the solution a nine out of ten.
Which deployment model are you using for this solution?
Public Cloud
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Microsoft Azure
Disclosure: My company has a business relationship with this vendor other than being a customer: Implementer
Buyer's Guide
Microsoft Azure SQL Database
January 2025
Learn what your peers think about Microsoft Azure SQL Database. Get advice and tips from experienced pros sharing their opinions. Updated: January 2025.
832,138 professionals have used our research since 2012.
Data Architect at Octopus
Quick scaling, reliable, and good support
Pros and Cons
- "The most valuable features of SQL Azure are its reliability and quick scalability."
- "SQL Azure could improve the feature set. They are catching up to Microsoft SQL Server."
What is our primary use case?
I am using SQL Azure for migrating existing SQL Databases into the cloud.
What is most valuable?
The most valuable features of SQL Azure are its reliability and quick scalability.
What needs improvement?
SQL Azure could improve the feature set. They are catching up to Microsoft SQL Server.
For how long have I used the solution?
I have used SQL Azure for approximately nine years.
What do I think about the stability of the solution?
SQL Azure is highly reliable and stable. I have not had a problem.
I rate the stability of SQL Azure a ten out of ten.
What do I think about the scalability of the solution?
The solution is highly scalable.
SQL Azure offers a large number of scalability targets, such as memory and CPUs, and the disc given is highly configurable. The speed it takes to scale from one level to the next is fast.
We have approximately 100 people using the solution, which are mostly virtual developers.
We plan to increase our usage, we are migrating Google databases to SQL Databases.
I rate the scalability of SQL Azure a nine out of ten.
How are customer service and support?
The support is good, but sometimes it takes a while to receive the resolution.
I rate the support of SQL Azure an eight out of ten.
How would you rate customer service and support?
Positive
Which solution did I use previously and why did I switch?
I was previously using SQL Server.
You are responsible for managing SQL Server on your own. Furthermore, although you have paid for the SQL Server license, it is now based on the number of cores and can be quite costly. However, it has more features than SQL Azure.
How was the initial setup?
The initial setup of SQL Azure is simple because it is in the cloud. There is not a lot to set up. If you do it manually, it can take five minutes. If it is done through DevOps pipelines, such as TerraForm, then it could take twenty seconds.
I rate the initial setup of SQL Azure a nine out of ten.
What's my experience with pricing, setup cost, and licensing?
The price of the solution is reasonable.
What other advice do I have?
The affordability of the solution allows for the swift and effortless creation of proof of concept projects to determine if it is suitable for their needs.
SQL Azure has all the enterprise features I need. To create enterprise solutions for a fairly good price point.
I rate SQL Azure a nine out of ten.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Founder at Druansh
A cost-effective solution that is easy to set up and easy to learn
Pros and Cons
- "The best thing about the solution is that it is tightly integrated with Azure Functions and Azure App Service, making it easy to deploy to the cloud."
- "Although the solution integrates well into Azure’s ecosystem, it has limited capability and is incompatible with many third-party applications or tools."
What is our primary use case?
We use the solution to create a relational database for a client. They were running SQL on-premise and wanted to migrate to Azure and create a single data warehouse.
What is most valuable?
The best thing about the solution is that it is tightly integrated with Azure Functions and Azure App Service, making it easy to deploy to the cloud.
What needs improvement?
The solution has a fully managed server, so the users have limited control over the underlying infrastructure. The customization options and flexibility are limited. The pricing structure is a bit complex because there are different pricing tiers based on database size, performance level, etc.
Although the solution integrates well into Azure’s ecosystem, it has limited capability and is incompatible with many third-party applications or tools.
For how long have I used the solution?
I have been using the solution for two to three years.
What do I think about the stability of the solution?
The solution is pretty stable. I rate the solution’s stability a nine out of ten.
What do I think about the scalability of the solution?
I rate the scalability an eight out of ten. We have struggled to scale up the instances at times. Around 80 to 90 people in the organization use the solution.
How was the initial setup?
The initial setup is very easy. Anyone who understands SQL can set up the solution.
What about the implementation team?
The implementation time depends on the type of database we set up. It took us less than a day to deploy the solution. If we have a simple scenario, it will take less than an hour to set up the solution once we have all the subscriptions.
Good documentation is available on SQL, so we do not need a vendor team to deploy the solution.
What was our ROI?
We have seen an ROI on the solution. Cloud-based services reduce infrastructure cost straightaway. The solution provides scalability and flexibility.
Also, a subscription-based learning model can be cost-effective. The ROI will vary depending on an organization's needs and usage pattern.
What's my experience with pricing, setup cost, and licensing?
There is no licensing cost for the solution.
What other advice do I have?
I am using the latest version of the solution. Our client had data from websites like Flipkart and Amazon for product and price information, and they wanted a relational database between these. The solution is pretty competitive when compared to other relational databases. We could have used Amazon RDS, but SQL Azure is much better.
The learning curve of the solution is minimal. If you plan to have third-party applications with SQL Azure, you may not be able to use certain features. Overall, I rate the solution a nine out of ten.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Account Manager at Jaffer Business Systems
A reliable and affordable solution to customize applications
Pros and Cons
- "The most valuable feature of the solution is that our customers do not have to manage the solution."
- "The solution has to scale up its expertise for hosting Oracle."
What is our primary use case?
Our customers in the bank sectors use the solution for their websites. Our private customers use the solution to customize their applications on the cloud because they do not want to buy separate hardware. Some of our customers also have their on-premise SAP hosted on Azure.
What is most valuable?
The most valuable feature of the solution is that our customers do not have to manage the solution. Partners manage and optimize the solutions for the customers.
The solution is also better cost-wise because if we host on hardware, we will have to change the hardware after four or five years. Also, if there is an issue with the hardware, the responsibility falls on the IT department. Customers do not like these responsibilities. With SQL Azure, everything is safe and secure. The clients pay a subscription fee and have fewer responsibilities.
What needs improvement?
Azure does not provide features like RDS for Oracle that AWS offers. The solution has to scale up its expertise for hosting Oracle.
For how long have I used the solution?
My organization has been a partner with Microsoft since 2008.
What do I think about the stability of the solution?
The solution is stable.
What do I think about the scalability of the solution?
The solution is scalable. Almost ten to twelve of our customers are using the solution.
How are customer service and support?
The support is good. We go to Microsoft for every escalation.
How was the initial setup?
The initial setup is pretty easy. Our team is interested in working for Azure and other Microsoft products. We don't require much support from Microsoft for setup.
What about the implementation team?
The deployment doesn't take much time. We only have to check for our client’s requirements. We can provide the services to the client within 15 to 20 days.
Our technical team manages the deployment. The team checks all Microsoft policies before discussing them with the customer. We draw up a proposal and then present it to our customers. We explain to our customers how their data will be added to Azure.
We may need two or three people to deploy the solution. Depending on the environment, the deployment takes one or two months or even 15 days. Once the deployment is done, the solution can be managed through a partner portal. We might also need two or three people from the customer’s organization to refresh or optimize the solution.
What's my experience with pricing, setup cost, and licensing?
The price could be slightly cheaper. Our customers pay for licenses annually.
What other advice do I have?
AWS secured much business in Pakistan because of RDS for Oracle. There is not much difference between AWS and Azure’s prices. AWS and Azure differ in price by a few dollars. Technically both solutions have different capabilities. AWS has a far better capability. People prefer AD authentication by AWS over Azure. We have Microsoft-certified trainers in Pakistan.
We have been asking our customers to choose Azure because they will get a lot of benefits by adopting a cloud solution. Since hardware is not easily available within Pakistan due to dollar disparity, a lot of people are choosing Azure.
We have been pushing Azure very aggressively for the past four to five years. People continue to implement the solution despite policy challenges. One of our customers wants to host nine to ten applications on Azure. There is a lot of demand for AWS and Azure. Overall, I rate the solution a nine out of ten.
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
Technical advisor and software architect at Technical advisor and software architect
Stores complex relational data with consistency requirements and handles query tuning and security very well
Pros and Cons
- "I prefer using Microsoft SQL Server because I like the experience and the way Microsoft handles the query tuning and security."
- "One of the nice features in Microsoft SQL Server is the SQL Server CLR, which we sometimes need to use to protect our procedures using C# or CLR. This is not available in the SQL Azure database."
What is our primary use case?
We use SQL Azure to store our relational data. Whenever I have complex relational data with consistency requirements, I use SQL Azure Database.
I'm currently working in a small startup. There are just two people using this solution now: a developer and myself. I'm working as a technical consultant and an architect.
What is most valuable?
Microsoft recently added a JSON feature. I use all the features in a normal relational database, and they're very helpful. I prefer using Microsoft SQL Server because I like the experience and the way Microsoft handles the query tuning and security. These are really good features for database experts.
What needs improvement?
One of the nice features in Microsoft SQL Server is the SQL Server CLR, which we sometimes need to protect our procedures using C# or CLR. This feature isn't available in the SQL Azure database. It's available in the Managed Instance in the Azure Database.
You can create SOAR procedures using C# and can get user-defined functions using C#. You can extend the database and the data files using CLR files. This feature isn't available on the Microsoft Azure SQL Database. I understand they can't add it because it's a managed service, and having CLR probably doesn't work for them, but it would be nice if they could add this feature.
For how long have I used the solution?
I have used this solution for almost six years.
What do I think about the stability of the solution?
I would rate the stability as eight out of ten.
What do I think about the scalability of the solution?
It is very scalable, depending on how much you're willing to pay. We can have up to 4,000 DTUs, but we haven't needed that much scalability.
How are customer service and support?
We had an instance where we weren't able to deploy Cosmos DB on a UAE data center, and Microsoft helped us. We haven't had any issues so far with technical support.
How was the initial setup?
Setup is straightforward. You just create an SQL Server instance account on Azure, and then you can create SQL databases. It's very easy to create tables and procedures. I mainly use the SQL data buckets inside Visual Studio. From there, I deploy databases to Azure from Visual Studio.
What about the implementation team?
It's easy to do the deployment in-house. Visual Studio provides a lot of functionality to make deploying solutions to Azure simple and easy.
What was our ROI?
Using SQL Server database with all the features will provide a good return on investment. Once you move to Azure, you remove all the capital expenses by having to acquire the license and deploy it on-premises.
What's my experience with pricing, setup cost, and licensing?
When you go with SQL Azure Database, you can create a small database, which is around $4 to $5 per month for development purposes. It's very cheap in that respect. I think it's a little bit expensive compared to other services that Microsoft offers on Azure. PostgreSQL, MySQL, and MariaDB are a bit cheaper than SQL Server.
If the price were lower, I think it would become more attractive for developers to use.
What other advice do I have?
I would rate this solution as eight out of ten.
It's a very easy solution. Microsoft also has Data Explore. The entire Microsoft environment makes things easy for developers. It's very easy to set up SQL on Azure. I highly recommend it. I really like it, and I've been working with SQL Server since 2000.
Which deployment model are you using for this solution?
On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Global Data Architecture and Data Science Director at FH
Offers ease of use, easy integration, and good technical support; its pay-per-use model makes cost control easier
Pros and Cons
- "What I like about SQL Azure is that it's similar to your on-premises SQL databases. It's not much different, so it's easy to start quickly on the solution if you know Microsoft SQL. I find its ease of use most valuable, and I also like that SQL Azure is also easily integrated with the Azure Cloud platform."
- "What would make SQL Azure better is users having the capability of managing the database solution from the cloud, instead of having to do it from an actual machine because currently, database management via SQL Azure is done on a virtual machine or a PC. The solution should have the data functionality of managing SQL databases inside the cloud."
What is our primary use case?
I'm using SQL Azure mostly for database purposes, including data modeling, data architecture for business applications, and also for Data Lake.
What is most valuable?
What I like about SQL Azure is that it's similar to your on-premises SQL databases. It's not much different, so it's easy to start quickly on the solution if you know Microsoft SQL. I find its ease of use most valuable, and I also like that SQL Azure is also easily integrated with the Azure Cloud platform.
What needs improvement?
What would make SQL Azure better is users having the capability of managing the database solution from the cloud, instead of having to do it from an actual machine because currently, database management via SQL Azure is done on a virtual machine or a PC. The solution should have the data functionality of managing SQL databases inside the cloud.
For how long have I used the solution?
I've been using SQL Azure for almost six years now.
What do I think about the stability of the solution?
SQL Azure is a stable solution.
What do I think about the scalability of the solution?
SQL Azure is a scalable solution.
How are customer service and support?
The technical support for SQL Azure is pretty good because it's from Microsoft. Based on the subscription you have, support would be included, and if you have a premium subscription with Microsoft, you can get all the support you need.
How was the initial setup?
SQL Azure is easy to set up because it's already part of your cloud infrastructure. You don't need to do any installation.
What was our ROI?
Your return on investment from SQL Azure would depend on your business applications. The solution will give you more scalability, and more functionality, and would reduce costs from on-premises to cloud databases, so there are a lot of cost reductions. As SQL Azure is pay-per-use, you can control your cost, so in terms of the return on investment, it's more centrally managed in the cloud, which means you don't need so many data warehouses to be managed separately in the infrastructure. You can reduce your infrastructure costs through SQL Azure as Microsoft has taken care of the infrastructure costs.
What's my experience with pricing, setup cost, and licensing?
In terms of the cost, SQL Azure is a pay-per-use solution, particularly because it's a cloud subscription, so you pay as much as you use it, but I cannot give a number because I don't manage the cost or the price for this solution.
What other advice do I have?
My company is using the cloud version of SQL Azure, so it's always the latest version.
There are thousands of people using the solution for business applications. My client is a big company with at least one thousand users of SQL Azure.
In terms of maintaining the solution, it's already managed as a Microsoft-managed product, so in that sense, you don't need people to maintain SQL Azure, but for the application database, you need one person for maintenance.
My advice to others looking into implementing the product is that if you are building a solution on Microsoft Cloud, you should choose SQL Azure for your data warehouse, database for your application, and your enterprise Data Lake needs.
My rating for SQL Azure is nine out of ten.
My company is a service company, so it's a partner, a customer, and a reseller.
Which deployment model are you using for this solution?
Public Cloud
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
Managing Director at sea-solutión
Has good stability, and you do not need to spend time to maintain it
Pros and Cons
- "Since SQL Azure is a stable solution, you do not need to spend time to maintain it."
- "The solution’s pricing needs improvement because it is too high."
What is our primary use case?
We have a web application that we deploy on Azure, and we use SQL Azure as a database to store the data.
What is most valuable?
Since SQL Azure is a stable solution, you do not need to spend time to maintain it.
What needs improvement?
The solution’s pricing needs improvement because it is too high.
For how long have I used the solution?
I have been using SQL Azure for less than three years.
What do I think about the stability of the solution?
I rate the solution’s stability an eight out of ten.
What do I think about the scalability of the solution?
Less than 100 users use the solution in our organization.
I rate the solution a seven or eight out of ten for scalability.
How are customer service and support?
Microsoft provides good and quick technical support.
How was the initial setup?
The solution's initial setup is easy and takes less than one hour.
What's my experience with pricing, setup cost, and licensing?
SQL Azure is an expensive solution.
What other advice do I have?
We use the solution to store not really big data, and the database is less than one gigabyte. The solution's integration with other Azure services is easy because it just needs a connection string to connect. SQL Azure is deployed on the cloud.
Users who can afford its price should use SQL Azure because it reduces setup time. Since it is a stable solution, you do not need to spend time to maintain it.
Overall, I rate the solution an eight out of ten.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Last updated: Jul 30, 2024
Flag as inappropriateBuyer's Guide
Download our free Microsoft Azure SQL Database Report and get advice and tips from experienced pros
sharing their opinions.
Updated: January 2025
Product Categories
Database as a Service (DBaaS)Popular Comparisons
Google Cloud SQL
MongoDB Atlas
SingleStore
Oracle Database as a Service
Google Cloud Spanner
Oracle Exadata Cloud at Customer
Yugabyte Platform
IBM Db2 on Cloud
Buyer's Guide
Download our free Microsoft Azure SQL Database Report and get advice and tips from experienced pros
sharing their opinions.
Quick Links
Learn More: Questions:
- When evaluating Database as a Service, what aspect do you think is the most important to look for?
- What would be the best application SQL optimizer over the WAN?
- Which database is the best for session cashing?
- What is the biggest difference between Google BigQuery and Oracle Database as Service?
- Which low-code (no-code) database solution do you prefer?
- Which databases are supported under DBaaS solutions?
- Why is Database as a Service important for companies?