I'm using SQL Azure mostly for database purposes, including data modeling, data architecture for business applications, and also for Data Lake.
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?
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.
Buyer's Guide
Microsoft Azure SQL Database
November 2024
Learn what your peers think about Microsoft Azure SQL Database. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.
816,406 professionals have used our research since 2012.
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
BI Development & Validation Manager at JT International SA
Stable product with fast setup
Pros and Cons
- "The solution is quire more stable than other tools."
- "I would like to the solutions scalability to be improved."
What is our primary use case?
We use this solution to store data MODS that are going to be consumed by Power BI.
What is most valuable?
The solution is quire more stable than other tools.
What needs improvement?
I would like to the solutions scalability to be improved.
For how long have I used the solution?
I have used this solution for the past three years.
What do I think about the stability of the solution?
This is a stable solution in general.
What do I think about the scalability of the solution?
It is moderately scalable in my opinion. On-premise, you can definitely scale it up better, but it is a bit restricted on the cloud.
Which solution did I use previously and why did I switch?
We used Oracle Databases and SQL Server databases on-premise.
How was the initial setup?
The initial setup was easy for about five hundred users and it required just a couple of managers.
What about the implementation team?
Our consultants helped with the implementation and the process took maybe ten minutes.
What other advice do I have?
I would recommend this solution for those who are looking to integrate it. I would rate this an eight out of ten.
Which deployment model are you using for this solution?
Public Cloud
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Buyer's Guide
Microsoft Azure SQL Database
November 2024
Learn what your peers think about Microsoft Azure SQL Database. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.
816,406 professionals have used our research since 2012.
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?
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.
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.
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.
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 inappropriateArchitect of Business Intelligence Solutions at Nestle
Easy to manage solution for analytics and business intelligence
Pros and Cons
- "It's user-friendly. Compared to other solutions, it's based more on clicks, not on scripts. It's easy to manage."
- "There could be more collaboration with other tools like Data Factory and Databricks."
What is our primary use case?
We are using this solution for analytics and business intelligence.
The solution is deployed on-prem and on cloud. The cloud provider is Microsoft.
There are tens of thousands of users. In my market in Poland, there are maybe 1,000 using the application based on the solution.
What is most valuable?
It's user-friendly. Compared to other solutions, it's based more on clicks, not on scripts. It's easy to manage.
What needs improvement?
There could be more collaboration with other tools like Data Factory and Databricks.
For how long have I used the solution?
I have been using this solution for 20 years.
What do I think about the stability of the solution?
It's stable.
What do I think about the scalability of the solution?
It's scalable, but it could be better.
How are customer service and support?
I don't use support because the documentation is very good, and the solution is easy to manage.
How was the initial setup?
In Azure, deployment takes minutes. It's easy.
What's my experience with pricing, setup cost, and licensing?
The cost is around $2,000 per month.
What other advice do I have?
I would rate this solution 8 out of 10.
My advice is to read the documentation and blogs.
Which deployment model are you using for this solution?
Hybrid Cloud
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Amazon Web Services (AWS)
Disclosure: I am a real user, and this review is based on my own experience and opinions.
AVP at MIDDAY INFOMEDIA LIMITED
A managed cloud database cloud-based Microsoft SQL Servers, provided as part of Microsoft Azure services
Pros and Cons
- "The initial setup is straightforward."
- "Operational cost needs improvement."
What is our primary use case?
We use it for supporting an application from another platform to Azure.
What needs improvement?
Operational cost needs improvement.
For how long have I used the solution?
I have been using SQL Azure for 6-8 months.
What do I think about the stability of the solution?
It is a stable solution.
What do I think about the scalability of the solution?
It is a scalable solution.
How was the initial setup?
The initial setup is straightforward. The designing process is involved in the deployment.
What other advice do I have?
Overall, I would 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: Apr 11, 2024
Flag as inappropriateAccount 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
Lead Engineering at GlobalLogic
It's good with transactional systems.
Pros and Cons
- "SQL Azure is good with transactional systems."
- "If it's a transitional system, there is a lot of reporting, so the solution becomes a bit slow when it's churning out tons of data, but it's good for a mid-sized application"
What is our primary use case?
We use SQL Azure to integrate the on-prem resources with the cloud. It creates a replica of our database in the cloud. We have more than 50 users.
What is most valuable?
SQL Azure is good with transactional systems.
What needs improvement?
If it's a transitional system, there is a lot of reporting, so the solution becomes a bit slow when it's churning out tons of data, but it's good for a mid-sized application
For how long have I used the solution?
We've been using SQL Azure for around five years.
What do I think about the scalability of the solution?
We are using SQL Azure extensively. It is still being utilized in the gigabyte and petabyte range for older applications, as well.
How are customer service and support?
We are a gold partner, so we have the option to use gold-tier support.
How was the initial setup?
Deploying SQL Azure is easy. It takes only one engineer to deploy.
What's my experience with pricing, setup cost, and licensing?
We have an enterprise license.
What other advice do I have?
I rate SQL Azure nine out of 10. I would recommend it to others.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Buyer's Guide
Download our free Microsoft Azure SQL Database Report and get advice and tips from experienced pros
sharing their opinions.
Updated: November 2024
Product Categories
Database as a Service (DBaaS)Popular Comparisons
Google Cloud SQL
MongoDB Atlas
Oracle Database as a Service
Google Cloud Spanner
Yugabyte Platform
Oracle Exadata Express Cloud Service
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?