Try our new research platform with insights from 80,000+ expert users
Co-Founder & Managing Director at a marketing services firm with 1-10 employees
Real User
A scalable solution for storing relational data in the cloud
Pros and Cons
  • "I am very happy with this solution; right now, I don't think there is anything I would change."
  • "The only problem we have with Azure is regarding the price."

What is our primary use case?

I use SQL Azure strictly for active data rescue.

All of my work is stored in the Microsoft Azure Cloud.

I am working on a special product with another person — it's a secret product, so, unfortunately, I can't talk about it.

What needs improvement?

I am very happy with this solution; right now, I don't think there is anything I would change.

More power should be included between the upgrades. We started with a less costly service but we needed more power. We paid a lot and upgraded but we still needed more power. The power should increase more between each upgrade.

For how long have I used the solution?

I have been using SQL Azure for three years.

What do I think about the stability of the solution?

SQL Azure is both very stable and scalable.

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.

How are customer service and support?

I have never had to contact customer support. There are several educational sites that I pay for that supply me with help.

How was the initial setup?

The initial setup was very straightforward. It's online, so I didn't need to install anything. I just had to choose options and activate them. 

What's my experience with pricing, setup cost, and licensing?

How much we pay is determined by how much we upgrade or downgrade our services. If you downgrade the service you pay less if you upgrade the services you pay more.

Microsoft has a cheap license for developers. Still, it was expensive for us because we are not a company, and we don't use crowdfunding, we used our own money to pay for the license.

What other advice do I have?

I would recommend SQL Azure to others.

On a scale from one to ten, I would give this solution a rating of ten.

Right now, with Azure, we have everything we need. The only problem we have with Azure is regarding the price.

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.
PeerSpot user
PeerSpot user
Business Analyst at a tech services company with 10,001+ employees
Real User
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.
PeerSpot user
Naresh Reddy - PeerSpot reviewer
Naresh ReddyEnterprise Solutions Architect at OORWIN LABS INC
Top 5Real User

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.

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.
reviewer1488372 - PeerSpot reviewer
Associate Manager at a consultancy with 501-1,000 employees
Real User
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.
PeerSpot user
MichaelSoliman - PeerSpot reviewer
Owner at Alopex ONE UG
Real User
Top 10
Provides fast access to data, but needs an SQL function optimizer
Pros and Cons
  • "This solution provides more comfort to the end-user compared to a normal SQL server."
  • "The management is entirely controlled by Microsoft, so there are some restrictions."

What is our primary use case?

I am a consultant and some of my clients use this solution for their database.

SQL Azure is a platform, as opposed to a product. You do not select a specific version. It has very little administrative ability, such as the ability to back it up, but it offers much more comfort for the user.

What is most valuable?

This solution has all of the advantages that are available in a normal SQL server, except it is presented in an online environment that can be used from everywhere. It provides fast access to data because the SQL server can calculate where the data is. It is a complexity of order one. So, it does not depend on the size of the table. This is why SQL servers are the favorite data source for any website.

This solution provides more comfort to the end-user compared to a normal SQL server.

What needs improvement?

This solution suffers from the same problems that come about in a normal SQL server. One issue is the optimization of function-heavy evaluations. If you define your own functions, the execution plan of the SQL server performs sub-passes of the execution path, which makes the process very slow. Even if there are very easy means to optimize them, it is still slow. The server should perform automatic function optimization. This is a problem in any implementation, Azure or otherwise.

The management is entirely controlled by Microsoft, so there are some restrictions.

For how long have I used the solution?

I have been using this solution for three years.

What do I think about the stability of the solution?

The solution is as stable as any SQL server. I agree with others who say that SQL is more stable than the Microsoft operating systems.

What do I think about the scalability of the solution?

This is a scalable solution.

How are customer service and technical support?

If you have a support contract then it is excellent. They will work at the problem until it has been resolved. The support is very professional.

Which solution did I use previously and why did I switch?

Our customer in Luxembourg is using an Oracle server, rather than SQL Azure because it was a specification of the project. I am not the one who decides which database technology will be used by my clients.

What other advice do I have?

This is the best product that Microsoft has. It is the same product as a normal SQL server but built on Azure. The management is different, depending on the hoster of the cloud.

I would rate this solution a seven out of ten.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user660030 - PeerSpot reviewer
Data Management Architect at a healthcare company with 201-500 employees
Vendor
Provides an option for maintaining structured data in smaller databases.

What is most valuable?

There is significant abstraction from beginner to intermediate database administration responsibilities. In this way, I can focus on my business objectives, as opposed to heavy upfront cost of ownership when compared to on-premises or IaaS alternatives.

How has it helped my organization?

It provides faster turnaround time to getting solutions customer facing.

What needs improvement?

It could have closer parity to on-premises capabilities. Introduce a graph database engine component.

For how long have I used the solution?

I have been using Azure since its inception.

What do I think about the stability of the solution?

Historically, SQL Azure has tended to choke at databases larger than 50GB, and in some cases, as small as 20GB. Granted, this starts becoming a function of database design.

Caveat: It's been a while since I last attempted to put larger sets of data into a single SQL Azure database. Now, if you don't use resilient connection tolerance practices (or technologies), then it may feel unstable. Here again, it becomes a function of design.

In other words, if you simply choose to use on-premises traditional designs and principles when interacting with SQL Azure, then there is a higher probability of it "feeling" unstable.

How is customer service and technical support?

I've seen and experienced some amazing service and then I've endured appalling interactions, too.

This becomes a function of your SQL engine skill, the diligence and appropriateness of your design, the support tier you purchased, and some luck if you connected with a support engineer who not only spoke your language, but also carried an attitude of chasing down a solution.

How was the initial setup?

The setup is super straightforward. I don't really find that question useful, or at least as useful as, "What is it like incrementally adjusting the design of the database?"

This is where Microsoft's eco-system further outshines the alternatives. Again, this is a much longer discussion, but it's folly to choose a platform, and even a technology, without considering the lifecycle of changes.

In an agile world, you have to ask how you are going to get that data tier to respond efficiently and within business requirements and tolerances.

What's my experience with pricing, setup cost, and licensing?

It's an elastic service, at least in its simplest definition, and a proactive one with some reactive capability. Therefore, there is value in monitoring usage and adjusting proactively to gain optimal savings.

Which other solutions did I evaluate?

Alternatives tended to be IaaS offerings hammered or butchered to be PaaS. So, frankly, the answer is that I don't know of other PaaS alternatives.

What other advice do I have?

SQL Azure is a good option for maintaining structured data, especially for smaller databases (0 - 25GB).

My solutions today leverage a plethora of structured and unstructured data. Therefore, having this service in close proximity to the resource groups I use for the other services is beneficial.

It does tend to constrain me to the Azure platform, as I've yet to find a vendor who can give me the RDBMS PaaS offering. Constrain makes it sound like “suck up some pain”. However, I have yet to find the Azure platform limiting.

Here is some context or insight. I was previously on the product team that heavily influenced the direction and feature set of SQL Server, both box (on-premises) and cloud. My focus and specialty is related to scaling the RDBMS tier to support high-demand applications.

To that end, SQL Azure was very useful for a certain set of business problems. At the time, I certainly would not have recommended anything larger than 50GB residing in a SQL Azure database.

I also felt strongly that a significant value proposition of cloud-based RDBMS solutions lay in the as yet untapped elastic-scale possibilities.

To that end, I developed a framework for customers to leverage, which found its way (in a crippled form) into what is today's SQL Azure elastic feature. What I'm trying to say is that true elastic-scale and distributed scale of SQL Azure is hobbled. That frustrates me.

The value proposition of using SQL Azure for mobile and web app solutions is also significant, and it remains as strong as ever. This is especially the case for solutions that enjoy the benefits of structured data.

The on-going improvements of SQL Azure reaching parity with an on-premises feature set is making SQL Azure a viable option for many applications that previously couldn't even begin to look at cloud-based, non-IaaS, therefore PaaS, offerings.

In my current role, I consider SQL Azure the leader for cloud-based RDBMS solutions, far ahead of any other cloud-based RBMS offering. Where I have structured data, SQL Azure is my de facto storage tier.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Solution architect at ACS
Real User
Top 5
A highly stable solution that has user-friendly VMs
Pros and Cons
  • "The most valuable feature of SQL Azure is the user-friendly VMs."
  • "The solution’s visibility could be improved."

What is most valuable?

The most valuable feature of SQL Azure is the user-friendly VMs.

What needs improvement?

The solution’s visibility could be improved.

What do I think about the stability of the solution?

The solution's stability is good, and we haven't faced any issues so far.

I rate SQL Azure a nine out of ten for stability.

What do I think about the scalability of the solution?

SQL Azure is a scalable solution. Around ten users are regularly using SQL Azure in our organization.

How was the initial setup?

The solution’s initial setup is straightforward.

What about the implementation team?

The solution’s deployment takes hardly a day.

What other advice do I have?

Overall, I rate SQL Azure ten out of ten.

Which deployment model are you using for this solution?

On-premises
Disclosure: My company has a business relationship with this vendor other than being a customer: Integrator
PeerSpot user
IT Manager at a pharma/biotech company with 201-500 employees
Real User
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?

I primarily use it for accounting and ERP solutions.

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.

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 technical 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.
PeerSpot user
reviewer2047446 - PeerSpot reviewer
Solutions Architect - Cloud at a manufacturing company with 10,001+ employees
Real User
A solution with good uptime and multi-region features with a valuable dashboard
Pros and Cons
  • "The dashboard is valuable."
  • "The solution can be improved by reducing the constraints available."

What is our primary use case?

Our primary use case for the solution is for applications. We get many applications in the environment, and most applications use Microsoft SQL, Azure SQL, and DBs, and a few use Postgres SQL. So primarily, the focus is to connect with the DB team and have a specific expert in the SQL environment.

How has it helped my organization?

We find the uptime and multi-region features available. Additionally, the dashboard is valuable.

What needs improvement?

The solution can be improved by reducing the constraints available on cloud and improving support response times.

For how long have I used the solution?

We have beee using the solution for approximately two years.

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. I rate is as nine out of ten.

How are customer service and support?

We have had a good experience with customer service and support. They are knowledgeable but sometimes take a while to give solutions. I rate customer service and support as seven out of ten.

How would you rate customer service and support?

Neutral

How was the initial setup?

The initial setup is straightforward. I rate is as eight out of ten.

What other advice do I have?

I rate the solution as eight out of ten. The solution is good but can be improved by reducing the constraints on cloud and improving support response times.

Disclosure: My company has a business relationship with this vendor other than being a customer: partner
PeerSpot user
Buyer's Guide
Download our free Microsoft Azure SQL Database Report and get advice and tips from experienced pros sharing their opinions.
Updated: January 2025
Buyer's Guide
Download our free Microsoft Azure SQL Database Report and get advice and tips from experienced pros sharing their opinions.