I primarily use it for accounting and ERP solutions.
IT Manager at a pharma/biotech company with 201-500 employees
Since moving to the cloud I have less troubleshooting and the database has become more stable
Pros and Cons
- "The initial setup was straightforward. It took less than one day for deployment."
- "The solution could be less expensive. They need to work on their pricing model."
What is our primary use case?
How has it helped my organization?
I have an old SQL server, and it's not stable. I have two choices, to renew the server or move the data to Azure. So I decided to move everything to the cloud. The database has since become more stable, and I have less troubleshooting, which saves time and money.
What needs improvement?
The solution could be less expensive. They need to work on their pricing model.
For how long have I used the solution?
I've been using the solution for three months.
Buyer's Guide
Microsoft Azure SQL Database
December 2024
Learn what your peers think about Microsoft Azure SQL Database. Get advice and tips from experienced pros sharing their opinions. Updated: December 2024.
824,067 professionals have used our research since 2012.
What do I think about the stability of the solution?
The solution is very stable. I haven't faced any issues up to this point.
What do I think about the scalability of the solution?
It's scalable. I worked sales and marketing for Microsoft and I know it's scalable. You can increase and decrease the specs for the server on demand. When it comes to physical hardware, you can increase the specs if you get the wrong machine. With software, you have to pay more money. You can also easily scale down and decrease the specs and save some money if you like.
How are customer service and support?
I've used technical support for other Microsoft solutions, and I've found them to be very fast in their response time. They'll call you and help you fix the problem.
Which solution did I use previously and why did I switch?
I've never worked with another cloud solution. This is my first.
How was the initial setup?
The initial setup was straightforward. It took less than one day for deployment. I have a lot of experience, so it might take others three or four days to complete a setup. You only need one person for deployment and maintenance.
What about the implementation team?
I did the implementation myself.
What's my experience with pricing, setup cost, and licensing?
We pay less than $1000 monthly in licensing fees. There are no additional costs. When you start to use the cloud, you can move other services to the cloud as well. So I think we will pay more in the future when we move other services over. But right now we only use the ERP system with SQL Cloud.
Which other solutions did I evaluate?
I didn't really evaluate Amazon or Google. I just read up on them as Microsoft competitors.
What other advice do I have?
I'm currently moving my system onto the cloud. I'm using a hybrid version of the solution.
My advice to anyone looking to switch to the cloud is to stabilize the technology and to consider Amazon, Azure, and Google. If you don't have experience in the cloud, you have to consider all solutions and pick the best one for your company. I decided to go with Microsoft Azure because of my past experience. So if you don't have the experience to fall back on, consider all technologies as well as their cost, money, and features.
I would rate the solution eight out of ten because of the cost. I'd like it to be cheaper so we can afford to move more of our services to the cloud.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
software engineer at a university with 11-50 employees
Great programming facility with good problem solving capabilities; very efficient
Pros and Cons
- "The solution is efficient and easy to use."
- "Lacks some tools on the SQL Server for data virtualization."
What is our primary use case?
Our core business is to make mathematical models for production and solutions. We don't develop or use software. The data comes with the Excel format stored in SQL and we write complex queries about the data and run it in our models. Our data is not sensitive and it's a matter of having a server for storage. I'm a software engineer.
What is most valuable?
SQL Azure is efficient and very easy to use. The programming facility is very good and the solution is great at solving problems.
What needs improvement?
SQL Azure could offer a lot more services and applications. I'd also like to see some tools that we could use on the SQL Server for data virtualization. That would be an improvement.
For how long have I used the solution?
I've been using this solution for 10 years.
What do I think about the stability of the solution?
We don't run critical data and haven't had any issues with the stability.
How are customer service and support?
We have a lot of experience and good programmers and IT administrators in the company, so we haven't needed customer support.
How was the initial setup?
Our implementation was straightforward and carried out internally. We have 10 users of this solution, the majority are in production and engineering, with a couple in software engineering.
What's my experience with pricing, setup cost, and licensing?
Our license is pay-as-you-go and we pay around €200 per month. You need to keep an eye on this because with scaling the cost can increase quite quickly.
Which other solutions did I evaluate?
This solution is more expensive than some others, but not as expensive as Amazon, Google and Oracle, which all have a lot of extra costs involved.
What other advice do I have?
I recommend this solution and rate it 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.
Buyer's Guide
Microsoft Azure SQL Database
December 2024
Learn what your peers think about Microsoft Azure SQL Database. Get advice and tips from experienced pros sharing their opinions. Updated: December 2024.
824,067 professionals have used our research since 2012.
Associate Manager at a consultancy with 501-1,000 employees
Good interface and support, yet cheaper than most cloud environment solutions
Pros and Cons
- "The interface is awesome."
- "I would like to see integration with Snowflake."
What is our primary use case?
We are in infrastructure development. We are using this solution with Power BI to consume the data.
We are creating on top of this SQL server. It will be consumed by Power BI for the customers, where they can customize their reports.
What is most valuable?
I am delighted to use this solution.
The most valuable feature is the moment of data. It's infused data where we can pull the data and post it immediately.
Also, it can connect to different sources. It's a storage mechanism where you can consume the data and post it into the target systems.
The interface is awesome. It's ready and easy to use.
What needs improvement?
It is difficult to find any disadvantages when I can only see advantages in using SQL Azure.
When you have a subscription, the subscription itself is not secure. You have to add the user into the directory and you will be able to use it.
I would like to see integration with Snowflake.
For how long have I used the solution?
I have been using SQL Azure for a couple of months.
We are using the 2017 version.
What do I think about the stability of the solution?
It's a stable solution.
What do I think about the scalability of the solution?
It's a scalable product. We have eight members in our organization who are using this solution.
We have plans to continue using this solution.
How are customer service and technical support?
Technical support is good and always available.
Which solution did I use previously and why did I switch?
Previously, we did not use another product.
How was the initial setup?
The initial setup is straightforward and the installation is simple.
It only requires you to get a subscription. Once you have downloaded it, you can create it as a resource and you can already use it.
The number of members required to maintain this solution is dependant on the server.
What's my experience with pricing, setup cost, and licensing?
They have standard subscriptions that are not the entire version. If you have a full version of your subscription then you have the entire version that you can download.
When you no longer need it, you can just stop the services. You can reduce the amount you pay, which is an advantage. Essentially, it's a pay and use mechanism.
It's reasonably priced and when you compare it with other products in the cloud environment, it's cheaper.
What other advice do I have?
I would rate SQL Azure a nine out of ten.
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.
IT Manager at a financial services firm with 11-50 employees
Easy to scale and easy to integrate with our on-premises environment
Pros and Cons
- "We like the ease of integrating it with our on-premises environment. We use a hybrid model. We have a SQL Server on-premises, and we have an integration with the cloud version. We do CPU or disk intensive processes on-premises. For accessibility, we offload onto the cloud. When you do a lot of IO and things like that in the cloud, Microsoft charges for the CPU activity."
- "Price definitely will be the negative point. It is quite expensive."
What is most valuable?
We like the ease of integrating it with our on-premises environment. We use a hybrid model. We have a SQL Server on-premises, and we have an integration with the cloud version. We do CPU or disk intensive processes on-premises. For accessibility, we offload onto the cloud. When you do a lot of IO and things like that in the cloud, Microsoft charges for the CPU activity.
What needs improvement?
Price definitely may be a negative point. As for most of cloud based solution, certain cost components as CPU and IO usage may cause extremely hi costs.
For how long have I used the solution?
It has been a bit over a year.
What do I think about the stability of the solution?
It is stable.
What do I think about the scalability of the solution?
It is scalable. In fact, it is too easy to scale. It just scales and sends you the invoice. You have to tune it to lock it down, and then it doesn't go too far. These are the kind of things you have to take care of to avoid having bad surprises at the end of the month when they send you the resource usage invoice.
How are customer service and technical support?
I didn't contact them regarding SQL Server, but I have contacted them for Azure and Office 365 support. They are usually quite good.
How was the initial setup?
It is too easy. Initially, the database engine itself takes an hour, and that's it. Tuning it is another matter, but tuning is anyways a difficult task in itself.
What's my experience with pricing, setup cost, and licensing?
It is quite expensive. I would definitely recommend not using the pay-as-you-go model because this will just mean all your money will go to Microsoft. So, really make sure to control resource usage as much as possible.
What other advice do I have?
I would definitely recommend this solution. It is a very good product, and it is difficult to beat. I haven't got anything that I saw missing in it in terms of features. It is always integrated within Azure and Microsoft Office 365 ecosystems. If there is something that the database can't do, it is quite easy to have another path of the offering to take over. They are almost like AWS. They have so many services that it is really difficult not to be able to achieve things. There is always something or someone. It is just a matter of price. You also have access to the service, documentation, and even the user community.
I would rate SQL Azure an eight out of ten.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Business Analyst at a tech services company with 10,001+ employees
Stable and scalable but could better integrate with Python
Pros and Cons
- "Emergency mode is quite useful."
- "I haven't explored SQL Azure's features much, but I would like to see some better integration with Python."
What is our primary use case?
I'm an end-user. I'm a business analyst, so I'm using SQL Azure to do analysis.
What is most valuable?
Emergency mode is quite useful.
What needs improvement?
I haven't explored SQL Azure's features much, but I would like to see some better integration with Python.
For how long have I used the solution?
I've been using SQL Azure for approximately two years.
What do I think about the stability of the solution?
SQL Azure is stable.
What do I think about the scalability of the solution?
I think SQL Azure is scalable. Almost 200 people are using it in the commercial department.
How are customer service and support?
I can't say much about Microsoft support because the IT people are the ones who deal with the Microsoft support team. Whenever we have an issue, we put our IT team on it and leave everything to them. They try to handle it if they can or they might bring in some consultants from the Microsoft team.
Which solution did I use previously and why did I switch?
I previously used Oracle, but I didn't spend much time with it, so I really can't say. I don't think Oracle has any capabilities that SQL Azure lacks, and it's not used in as many companies and institutions.
How was the initial setup?
Setting up SQL Azure isn't complex.
What other advice do I have?
I rate SQL Azure seven out of 10.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Development Manager at Incepta
Very reliable, versatile, simple to use and reasonably priced
Pros and Cons
- "The solution has become easier to use over time and it's also reasonably priced."
- "Some issues with scalability."
What is our primary use case?
As consultants, we deploy this solution to our customers both on cloud and on-prem. Most of our clients buy the solution as an application package which requires a database. If they are a "Microsoft shop," I recommend they use SQL Server. I'm the development manager and we are customers of Azure.
What is most valuable?
I like the reliability of SQL Server and the solution has become easier to use over time, and I believe it will become more popular in the future. It's also reasonably priced. As a competitor, Oracle may have 10% of the features that SQL Server cannot offer but those features are for high-end database and high-end applications. Most clients don't need those extras and shouldn't have to pay for high-end features like the redundancy.
SQL has become more versatile because of features they continue to add. Every new version has new features and it pretty much covers everything in terms of memory, database, the caching, the redundancy, and high availability. I would say MS SQL server fully meets the requirement of 95% of my clients out there.
What needs improvement?
If you use the solution in the Microsoft environment, it's fine. But if you're using Java then it seems to be out of place. AWS has a new product called Aurora, it's a new database that can deal with both types of workloads: transactional and analytical. That's a big challenge for all the other databases including SQL, because most of the databases out there are designed for either type of workload but the Amazon AWS Aurora does both. With SQL, if they do the BI normally, you then have to replicate the production database to another database which is no longer necessary with Aurora. It's something SQL could include.
For how long have I used the solution?
I've been using this solution for several years.
What do I think about the stability of the solution?
This is a stable solution.
What do I think about the scalability of the solution?
I think they still have issues with scalability. For applications requiring scalability, I'd recommend using the database on the cloud and not on-premises. We have up to 200 users for this solution, mainly office workers and generally working in small to medium sized companies.
How are customer service and technical support?
Microsoft doesn't provide technical support, the support structure is not good. If you need something, you have to call them and the cost is $499 per incident ticket which is very expensive. The good thing about the SQL Server is that there is a lot of information out there in the community.
Which solution did I use previously and why did I switch?
I also used Oracle and I think it's a good solution for companies that already use Oracle. It makes sense for them to go with that solution as the database for their application. For a company that has no attachment, I recommend SQL.
How was the initial setup?
The initial setup was quite straightforward.
What other advice do I have?
If our clients are non-Microsoft clients and they have the money, then I recommend Oracle. But for ease of use, scalability, and value for money, I like SQL.
I would rate this solution an eight out of 10.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Consultant at SoftwareONE
Helpful support, scalable, and beneficial turning process
Pros and Cons
- "The backup solution in Azure is great, the firewall settings in SQL are very easy to use and work very well. Additionally, the turning process is very good and has improved the SQL services and queries."
- "SQL Azure could improve by adding more features."
What is our primary use case?
I have used SQL Azure for the backend tier application. If the customer has the flow change application with an application service, they will use the backend. I always suggest using SQL Server and Azure.
What is most valuable?
The backup solution in Azure is great, the firewall settings in SQL are very easy to use and work very well. Additionally, the turning process is very good and has improved the SQL services and queries.
What needs improvement?
SQL Azure could improve by adding more features.
For how long have I used the solution?
I have used SQL Azure within the past 12 months.
What do I think about the stability of the solution?
I have found SQL Azure to be stable.
What do I think about the scalability of the solution?
The scalability of SQL Azure is very good.
How are customer service and support?
The support of SQL Azure is very good.
How was the initial setup?
The implementation of SQL Azure is simple.
What other advice do I have?
I would recommend this solution to others.
I rate SQL Azure a nine out of ten.
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
Master of Information Technology at a individual & family service with 201-500 employees
Offers security verification and backup but the integration should be faster
Pros and Cons
- "The stability is good."
- "The initial setup was very complex."
What is our primary use case?
Our primary use case for SQL Azure is to operate our database.
What is most valuable?
The features I like most is that it offers a lot of securitt verification and backup from our side as well as from within SQL Azure.
What needs improvement?
Security can sometimes be a problem when it affects our business needs. It needs to integrate more security without stopping the service or our business. In some cases we have a lot of restriction on people who needs to use the database for whatever reason. We need more performance but in the same way we need more security - from the application and also in the Internet. The problem is therefore in the internet.
For how long have I used the solution?
We've been using the solution for two years now.
What do I think about the stability of the solution?
The stability is good at the moment. We are more dependable on the stability from the internet from our service provider. The solution is responsible for 99% of the stability, but most of our problems are due to our local internet provider.
What do I think about the scalability of the solution?
The scalability is good. We have 100 users and one can upgrade the system by performance and by the size of the storage. You can move between different types of storage using block or docket. You can use any way you choose without losing data. So the scalability it is very good. We plan to increase our usage.
How are customer service and technical support?
We are planning to redo the assessment about whether more people should be involved in the technical support.
How was the initial setup?
The initial setup was very complex. It is hard to explain, but the problem is when you have more than one service. We have only one service but the solution has multiple capabilities.
The deployment team installed the solution on one machine at a time, so it took very long. I chose a big database and within less than nine minutes I was able to collect data. So that was much faster.
What about the implementation team?
We used a vendor team and they have one or two guys who are responsible for the maintenance.
What other advice do I have?
When it comes to implementation, my advice would be to integrate between Microsoft platforms. I will rate it an eight out of ten as I would love to see faster integration.
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: December 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?
Python is well supported by AWS EC2, enabling smooth deployment and use of Python applications on EC2 instances. A large variety of EC2 instance types that support Python are available, and installing Python modules and frameworks is simple.