Try our new research platform with insights from 80,000+ expert users
it_user1294518 - PeerSpot reviewer
Solution Principal at a computer software company with 5,001-10,000 employees
Real User
A very mature product with good documentation and good stability
Pros and Cons
  • "The solution is a fairly mature product. It provides good stability."
  • "From a security perspective, although their features are decent, they can always be improved upon, updated, and refined to help protect clients better."

What is our primary use case?

We primarily use the solution for its Data Lake and Data Warehouse, in both cases for our customers.

What is most valuable?

The solution is easily integrated into other SQL solutions. It's flexible in that sense.

The solution is a fairly mature product. It provides good stability.

The initial setup isn't too difficult.

There is very good documentation. It's unbelievable, the amount of documentation on offer through Microsoft's site.

The security features are quite good.

What needs improvement?

In terms of management, you can't really pause things. It doesn't allow for that kind of capability.

From a security perspective, although their features are decent, they can always be improved upon, updated, and refined to help protect clients better.

I would love it if that had dynamic data masking and features of that nature.

For how long have I used the solution?

I've been using the solution for two years at least at this point.

Buyer's Guide
Microsoft Azure SQL Database
May 2025
Learn what your peers think about Microsoft Azure SQL Database. Get advice and tips from experienced pros sharing their opinions. Updated: May 2025.
851,823 professionals have used our research since 2012.

What do I think about the stability of the solution?

The stability of the solution is pretty good. It's a mature product, so you don't get bugs or glitches, and they update it regularly. It doesn't crash. It's reliable.

What do I think about the scalability of the solution?

The solution can scale well. That's not a problem at all. If a company needs to scale, they can do so easily.

How are customer service and support?

Microsoft's technical support is great. We're satisfied with their service. They have a pretty extensive online database and an online community that is quite helpful. It's all very helpful.

If you need to reach them in person, you need to have a licensing agreement in place. If you purchase that, you can get more personalized assistance.

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

We previously used SQL on-premises servers. It's very easy to migrate over to the cloud if you have that setup. It's basically one-to-one.

How was the initial setup?

The initial setup isn't complex. It's pretty straightforward. However, it does take a long time to provision and manage everything. It can take a couple of hours typically to deploy the solution.

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

You do have to pay for technical support. If you have it in your licensing agreement, you will gain access to a team you can call if you run into issues.

I'm not sure of the exact licensing costs. From a cloud perspective, a client would be charged based on consumption, so the pricing would depend on elements such as how many users or how many queries (and how complex), et cetera. 

I do know that it's competitive pricing, however. Most solutions of this caliber are around the same price. They compete with each other.

What other advice do I have?

We're Microsoft partners.

The solution is constantly being updated. We're on whatever the latest version/update is at any given time.

We're a consultancy, so we work with a variety of clients and adjust solutions based on their needs.

I'd advise new users to take advantage of the documentation on offer from Microsoft. It will really help them understand the solution.

Overall, I'd rate the solution 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: Partner
PeerSpot user
reviewer2032284 - PeerSpot reviewer
Head, Information Technology at a manufacturing company with 10,001+ employees
Real User
Integrates well with Microsoft products and can expand but needs to have mobile capabilities
Pros and Cons
  • "We're a Microsoft customer, so it fits in with everything else we work with."
  • "The product could be more competitive in terms of features, security, and scalability."

What is our primary use case?

We have HR applications including a lead system and also traveling expenses. We're using SQL for items like that.

What is most valuable?

The solution offers good plugin capabilities. We're a Microsoft customer, so it fits in with everything else we work with. 

The solution can scale. 

What needs improvement?

From a user standpoint, there isn't really any need for improvement. 

We'd like the solution to be available on mobile phones. 

The product could be more competitive in terms of features, security, and scalability.

For how long have I used the solution?

We've been using the solution for around three years. 

What do I think about the scalability of the solution?

The scalability would be a bit better. That said, right now, I am happy with how it can scale. As a user, you always want it to be better; however, as of now, it's not too bad. 

I'm not sure how many people are using the solution in our company at this time. 

How are customer service and support?

I've never used technical support services. I can't speak to how well they respond when a customer has an issue. 

What other advice do I have?

We're a Microsoft customer. 

I'm not part of the development team. I'm not sure which version our company is on. 

I'd rate the solution six out of ten. While it's fine for use online, we'd like it to be more mobile. If it were on mobile, I would rate it higher. 

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
Microsoft Azure SQL Database
May 2025
Learn what your peers think about Microsoft Azure SQL Database. Get advice and tips from experienced pros sharing their opinions. Updated: May 2025.
851,823 professionals have used our research since 2012.
Daniel_Marin - PeerSpot reviewer
Software Developer at Generate Impact
Real User
Beneficial centralized authentication, scalable, and reliable
Pros and Cons
  • "The most valuable feature of SQL Azure is centralized authentication because I'm using the domain, user name, and password, for Microsoft 365 account with multifactor authentication and the security has been working well."
  • "I was using a user list for connecting a program in OTF for getting information. The connection in SQL Azure can improve by being easier because at the moment I have to use private certificates for user authentication. I had to do additional configuration to have the connections."

What is our primary use case?

SQL Azure is used for the replication of a CRM database. if get information from this database and try to replicate it on other servers and other systems. I'm getting the transactional data information.

What is most valuable?

The most valuable feature of SQL Azure is centralized authentication because I'm using the domain, user name, and password, for Microsoft 365 account with multifactor authentication and the security has been working well.

What needs improvement?

I was using a user list for connecting a program in OTF for getting information. The connection in SQL Azure can improve by being easier because at the moment I have to use private certificates for user authentication. I had to do additional configuration to have the connections.

For how long have I used the solution?

I have been using SQL Azure for approximately six months.

What do I think about the stability of the solution?

SQL Azure is stable, I have not had any issues.

What do I think about the scalability of the solution?

The scalability of SQL Azure is easy to do.

We have a lot of people in my organization using this solution. We have a large company.

How are customer service and support?

I have not used support.

How was the initial setup?

The initial setup of SQL Azure is difficult and complex. I have to use a lot of certificates, private keys, and public keys to establish a connection.

What other advice do I have?

SQL Azure is a really good tool. I recommend using this solution instead of a normal SQL server, its an improvement,

I rate SQL Azure a nine out of ten.

Which deployment model are you using for this solution?

Private Cloud
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
reviewer1407519 - PeerSpot reviewer
Chief Technology Officer & Vice President, Delivery at a recruiting/HR firm with 1-10 employees
Real User
Easy to scale, easy to deploy, good pricing, and has lots of out-of-the-box features
Pros and Cons
  • "It is easily scalable, and it is faster than SQL Server. It is also less expensive than using SQL Server. It has the pay-as-you-go model, and the charges are based on the usage."
  • "There are some limitations for cross-database queries and features. The migration of data from older systems should be easier. For deployment, there are too many options, which sometimes makes it difficult to figure out the best option. There is not enough information to help you to find the best option for deployment. There should be more documentation about this."

What is our primary use case?

We use it for benefits management in the healthcare domain. 

How has it helped my organization?

It helps us deploy new applications very quickly. We have set up everything on Azure, including SQL Azure. 

It has a lot of out-of-the-box features, which is useful. It is easy to move applications for disaster recovery or availability, and all these features are out of the box.

What is most valuable?

It is easily scalable, and it is faster than SQL Server. It is also less expensive than using SQL Server. It has the pay-as-you-go model, and the charges are based on the usage.

What needs improvement?

There are some limitations for cross-database queries and features. The migration of data from older systems should be easier.

For deployment, there are too many options, which sometimes makes it difficult to figure out the best option. There is not enough information to help you to find the best option for deployment. There should be more documentation about this.

For how long have I used the solution?

I have been using this solution for a couple of years.

What do I think about the scalability of the solution?

It is easily scalable. We have around 60 to 70 users. We'll be increasing its usage. We are gradually moving to SQL Azure for all our requirements.

How are customer service and technical support?

Their technical support is prompt, but some of our issues have not been addressed, even though the team is trying. We didn't have a good experience with them for a couple of issues, but overall, they have been good.

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

We got everything ready-made in Azure because our all applications are in the .NET framework and SQL, so we found SQL Azure to be the most suitable option.

How was the initial setup?

It is straightforward, but if you're migrating data from SQL Server, it is quite time-consuming and not so easy.

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

I am not aware of the exact pricing, but our monthly bill for Azure is around 80,000. It is less expensive than using SQL Server. It has the pay-as-you-go model, and the charges are based on the usage.

What other advice do I have?

If you are migrating from older systems, you should know that CLR is not supported in SQL Azure. Data migration can also be a challenge.

I would rate SQL Azure a nine 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.
PeerSpot user
reviewer1443378 - PeerSpot reviewer
IT Manager at a financial services firm with 11-50 employees
Real User
Top 20
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.
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.

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 5Leaderboard
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
Buyer's Guide
Download our free Microsoft Azure SQL Database Report and get advice and tips from experienced pros sharing their opinions.
Updated: May 2025
Buyer's Guide
Download our free Microsoft Azure SQL Database Report and get advice and tips from experienced pros sharing their opinions.