Try our new research platform with insights from 80,000+ expert users
Cloud Solution Engineer at a financial services firm with 5,001-10,000 employees
Real User
Cost-effective, very scalable and reliable, and lets you easily migrate your on-premise SQL instance
Pros and Cons
  • "Its cost benefit is most valuable because you are charged per data unit instead of licensing. You can easily migrate your on-premise SQL to the cloud with a managed instance. That's what it is designed to do. It is easy to take your on-premise or older SQL instance and move it to the cloud. It makes it easy to get off your on-premise SQL and start utilizing the cost benefit of the cloud."
  • "I'm not really a SQL DBA, so I can't go into the depths of the areas that need to be improved. They can maybe make it a bit easier to educate people on how to develop SQL Server in Azure. They can provide some free seminars and webinars and more training in general for easier migration. I know there is some stuff on Microsoft learning, but it would be helpful and useful to have more up-to-date content."

What is our primary use case?

We're slowly progressing through the delivery of our production system or landing zone in the cloud. Nothing is in production yet.

What is most valuable?

Its cost benefit is most valuable because you are charged per data unit instead of licensing. You can easily migrate your on-premise SQL to the cloud with a managed instance. That's what it is designed to do. It is easy to take your on-premise or older SQL instance and move it to the cloud. It makes it easy to get off your on-premise SQL and start utilizing the cost benefit of the cloud.

What needs improvement?

I'm not really a SQL DBA, so I can't go into the depths of the areas that need to be improved. They can maybe make it a bit easier to educate people on how to develop SQL Server in Azure. They can provide some free seminars and webinars and more training in general for easier migration. I know there is some stuff on Microsoft learning, but it would be helpful and useful to have more up-to-date content.

For how long have I used the solution?

We've been dabbling with it for the last couple of years. 

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

What do I think about the stability of the solution?

Based on our experience, it is very stable and very reliable.

What do I think about the scalability of the solution?

It has got Microsoft's backbone on it. It is very scalable. At this stage, we don't have many users because we're still busy migrating over to Azure cloud. In the next year, we'll probably have close to a million customers because that's what we've got on our books.

How are customer service and support?

I have interacted with them. They are very good for out-of-the-book solutions, but when we get to integrations with non-Microsoft applications, it can be a little bit more tricky. You also have to involve the vendor of that specific product to deal with problems related to integration, but, in general, Microsoft's support is pretty good. I've never found it to be poor in any way.

What about the implementation team?

For the number of customers we have, we probably only need three or four people, which is not a lot. If you look at it that way, it is actually quite cost-effective.

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

It is beneficial in terms of cost because you are charged per data unit instead of licensing.

What other advice do I have?

I would absolutely recommend this solution to others. If they are going for Azure, they probably don't have a choice. I would advise others to get used to all the options and ideas of SQL PaaS, SQL managed instances, and SQL on VMs. They should get their head around which one is best for their company. They should make sure that it fits their company's vision of where they want to go with their databases because it may or may not be the best solution for everybody. That's why there are a couple of options, so just make sure to select the right one.

I would rate SQL Azure an eight out of ten. It is best in many ways. There is nothing better than this from Microsoft from the database aspect.

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.
PeerSpot user
Team Lead, Enterprise Computing Platforms at a tech services company with 201-500 employees
Real User
No admin overhead, stable, and scalable, but needs better pricing and compatibility with other vendors
Pros and Cons
  • "We don't have to manage it much. It is managed by Microsoft, which makes it easy for us because there is no admin overhead for managing the servers. It is also easily scalable. During peak hours, it can scale higher."
  • "We have a very small database running on SQL Azure. We have not been able to load bigger systems on it. It is still not something that is feasible. All our heavy-duty systems are on SAP, and it should have more compatibility with other vendors such as SAP. Its price can definitely be lower. It is pretty pricey."

What is most valuable?

We don't have to manage it much. It is managed by Microsoft, which makes it easy for us because there is no admin overhead for managing the servers. 

It is also easily scalable. During peak hours, it can scale higher.

What needs improvement?

We have a very small database running on SQL Azure. We have not been able to load bigger systems on it. It is still not something that is feasible. All our heavy-duty systems are on SAP, and it should have more compatibility with other vendors such as SAP. 

Its price can definitely be lower. It is pretty pricey.

For how long have I used the solution?

We've been using SQL Azure for about three years.

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 easily scalable. We have five people who are working with this solution.

How are customer service and technical support?

Their technical support is very good for SQL Azure. Basically, based on my experience, we usually don't have any problem with support for Microsoft products. If we are seeking support for something like Linux or something that is not exactly a Microsoft product, it is a little disappointing.

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

Its price can definitely be lower. It is pretty pricey.

What other advice do I have?

I would rate SQL Azure a seven out of ten. It works like any other SQL database, and it is pretty good.

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
August 2024
Learn what your peers think about Microsoft Azure SQL Database. Get advice and tips from experienced pros sharing their opinions. Updated: August 2024.
802,829 professionals have used our research since 2012.
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
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.

How are customer service and technical 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
Data Engineer at a consultancy with self employed
Real User
Top 20
Easy to deploy, straightforward setup, and stable
Pros and Cons
  • "The hardware is all managed by Microsoft."
  • "The pricing plans when using multiple Microsoft solutions are complex and have room for improvement."

What is our primary use case?

The solution is used to manage our databases in the cloud.

What is most valuable?

The hardware is all managed by Microsoft.

What needs improvement?

The pricing plans when using multiple Microsoft solutions are complex and have room for improvement.

For how long have I used the solution?

I am currently using the solution.

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.

How are customer service and support?

The technical support is good.

How was the initial setup?

The initial setup depends on the requirements but is easier than the on-prem SQL.

What was our ROI?

I have seen a return on investment.

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

The pricing is flexible and can be adapted based on our requirements but the pricing options are complex especially if we are using a VM.

What other advice do I have?

I give the solution a nine out of ten.

Maintenance is minimal and can easily be done.

I suggest researching the solution on Microsoft.com where there is a good learning platform before using the solution.

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
Real User
A user-friendly environment with good flexibility for adding modules or features
Pros and Cons
  • "The solution effectively handles storing and maintaining information in databases."
  • "The solution requires familiarity with its language so can be tricky."

What is our primary use case?

I use the solution for database maintenance. 

What is most valuable?

The environment is user friendly and there is good flexibility for adding modules or features. 

The solution effectively handles storing and maintaining information in databases. 

What needs improvement?

The solution requires familiarity with its language so can be tricky. A simplified language would be appealing to users. 

A more user-friendly format for certain modules is desired. 

The application and interface can be a bit heavy to install.

For how long have I used the solution?

I have been using the solution for one year. 

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. It takes a bit of knowledge about the process but then is really easy.  

How are customer service and support?

I have not needed technical support. 

How was the initial setup?

The setup can be a bit of a challenge until you get used to it. Once you have familiarity with it, setup is okay and takes about 30 minutes. 

What about the implementation team?

A colleague assisted me with implementation. 

What other advice do I have?

I recommending using the solution because it is effective and user friendly. 

I rate the solution 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
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
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
Buyer's Guide
Download our free Microsoft Azure SQL Database Report and get advice and tips from experienced pros sharing their opinions.
Updated: August 2024
Buyer's Guide
Download our free Microsoft Azure SQL Database Report and get advice and tips from experienced pros sharing their opinions.