Try our new research platform with insights from 80,000+ expert users
reviewer1352925 - PeerSpot reviewer
Senior Information Technology Manager at a aerospace/defense firm with 10,001+ employees
Real User
Easy to provision, scale up, and scale down
Pros and Cons
  • "We primarily and generally use it only for DB purposes. When it comes to the Azure part, we can easily provision, scale up, and scale down the generator machine. This kind of flexibility is the USP of SQL Azure. Its interface and ease of use are also valuable. It is very easy to use and integrate with multiple databases. If I need to pull in or import some data from my on-premises database, the ease with which you can connect and pull the data, not only from SQL Server but also from other flavors of MySQL or even Oracle, is very good."
  • "The way it has been designed, in the on-premises deployments, the underlying Windows OS is highly scalable but has a very large resource requirement. A lot of power-related and memory-related things are there, which I have not seen in the RHEL and Oracle. I have not tried SQL on RHEL EXEC. On Windows, infrastructure-wise, a very large workload is running on the SQL. This issue is related to Windows, not SQL."

What is our primary use case?

We are using it for an application in two different models, the PaaS model and the SaaS model. One is the product, so we are using it as a SaaS model. We are using the other one simply as a PaaS model.

For its deployment, we are sort of using the highest model in which one instance has only VM and the SQL installer on it. Another instance is simply using SQL Azure.

What is most valuable?

We primarily and generally use it only for DB purposes. When it comes to the Azure part, we can easily provision, scale up, and scale down the generator machine. This kind of flexibility is the USP of SQL Azure.

Its interface and ease of use are also valuable. It is very easy to use and integrate with multiple databases. If I need to pull in or import some data from my on-premises database, the ease with which you can connect and pull the data, not only from SQL Server but also from other flavors of MySQL or even Oracle, is very good. 

What needs improvement?

The way it has been designed, in the on-premises deployments, the underlying Windows OS is highly scalable but has a very large resource requirement. A lot of power-related and memory-related things are there, which I have not seen in the RHEL and Oracle. I have not tried SQL on RHEL EXEC. On Windows, infrastructure-wise, a very large workload is running on the SQL. This issue is related to Windows, not SQL.

For how long have I used the solution?

I have been using SQL Azure for two years. 

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.

What do I think about the stability of the solution?

As of now, we have less production workload on Azure, but whatever is there, it is pretty stable. So, from a very large workload perspective, I can't comment, but till now, I have not found any issue. I will consider it quite stable as of now.

What do I think about the scalability of the solution?

It is highly scalable.

How are customer service and support?

My team initiates the service request. We have unified support from Microsoft. The service request is through the service hub. This is, in fact, a very good change from the point of view of the overall approach towards support. We can open multiple or unlimited numbers of service requests on the service hub, and their response is also quite good.

How was the initial setup?

We started with just a simple client-server kind of application. Right now, we are basically in the full-phased data lake solution of Azure. So, it is in the design and architecture stages. When it is finalized, then we will implement a full-blown solution on Azure.

What other advice do I have?

I would, of course, highly recommend this solution. You cannot avoid SQL Server or SQL Azure if you are primarily working in the database domain. There are a lot of other databases available in the market, but the ease with which you can do the development and the overall support that you get cannot be compared with any other database. 

I would rate SQL Azure a 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
IT Support Engineer - AZURE Administrator at Mindspring Computing
Real User
Top 20
Straightforward setup, stable, and scalable
Pros and Cons
  • "The reason we moved to the cloud was for the convenience of not having any physical hardware to maintain."
  • "Microsoft could improve its documentation and support."

What is our primary use case?

We use SQL Azure for the SAP application, an accounting software that facilitates transactions between different departments. The financial trends we run on SAP are supported by SQL, which is the back end of that application.

What is most valuable?

The reason we moved to the cloud was for the convenience of not having any physical hardware to maintain. As a technical person, this has reduced the amount of maintenance I need to do, allowing me to focus more on backups since the Azure infrastructure takes care of itself. Additionally, this is cost-effective for the organization since we are not spending much time on servicing infrastructure. Furthermore, it is convenient because we only pay for the time we use the solution, and are not billed for the time we are not using it.

What needs improvement?

Microsoft could improve its documentation and support. Without the necessary knowledge and expertise, it can be difficult to navigate the platform and find a technical person to guide us through. There is not currently enough documentation available to make it easy to use. If I had not been certified in Azure, I would have faced a lot of difficulties.

I would like reports attached to my phone if there's an error that occurs within SQL Azure or if there are updates that need to run, I would like to receive notifications.

For how long have I used the solution?

I have been using the solution for two years.

What do I think about the stability of the solution?

The solution is stable. We only had one outage last year and it didn't even last for 30 minutes.

What do I think about the scalability of the solution?

The solution is scalable.

How are customer service and support?

The technical support has always been good, but recently I had two encounters, last year when I spoke to a consultant from Africa these people provided support, but it almost sounded as if they didn't have enough knowledge. They didn't have enough technical knowledge of my problem to call me back after they had consulted. The support didn't feel like it was Microsoft support contacting me.

How would you rate customer service and support?

Neutral

How was the initial setup?

The initial setup is straightforward and only took one day.

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

When looking at the long-term expenses associated with running software on an on-premises server, the costs are almost equivalent but when we include insurance for devices, onsite fees for servers, and other related costs, we may find that this is a cost-effective solution.

What other advice do I have?

I give the solution a ten out of ten. I don't see anything wrong with SQL Azure. I believe it's actually an advantage because previously we had to install SQL solutions on a physical computer. The good thing is that has been translated onto the cloud and that makes it a very good feature. SQL Azure itself, is a robust application that does a lot and integrates with a lot of applications. The reason I like SQL Azure better is that it's easily accessible and the setup is almost exactly the same as we do on the physical machines, but the good thing is there's no machine to maintain the grid.

We selected SQL Azure because it was recommended to us by the safety provider of our accounting software.

I recommend the solution to others.

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:
PeerSpot user
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.
Subject Matter Expert at Vision Software
Real User
A Cloud solution, with ensured availability, and performance
Pros and Cons
  • "The administration console in Azure, all in one is the most valuable feature."
  • "I think that the cost management in SQL is not clear because we may use some tax to identify products, but in some cases identifying the transactions in SQL is not easy for some financial cost centers."

What is our primary use case?

The primary use case is to pass services for applications of some customers, where they have maybe the front end in dot net and another language, and SQL service in Azure.

What is most valuable?

The administration console in Azure, all in one is the most valuable feature. Monitoring the transactions in Azure and the elasticity when we need to grow the databases for our customers.

What needs improvement?

I think that the cost management in SQL is not clear because we may use some tax to identify products, but in some cases identifying the transactions in SQL is not easy for some financial cost centers. Perhaps if in Azure cost management we have the opportunity to monitor the SQL cost in more detail, it will be helpful.

For how long have I used the solution?

I have been using the solution for around four years.

What other advice do I have?

I give the solution a nine out of ten.

In some cases, our customers need to move forward with their SQL projects and when they try to budget in the Azure pricing calculator some costs appear that in the production environment are very different. This becomes problematic for customers when they use SQL Pass services.

We are an IT company, so I'm an architect for that company using Azure solutions. Many users in many companies use SQL. I estimate maybe around 1,000 final users and technical staff from each company are using SQL Azure.

Which deployment model are you using for this solution?

Hybrid Cloud

If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

Microsoft Azure
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
PeerSpot user
it_user261489 - PeerSpot reviewer
Program and Project Manager at a tech services company with 10,001+ employees
Real User
Security features should be improved, but it has helped us to reduce a lot of customer infrastructure budgets.

What is most valuable?

  • Azure SQL database
  • Office 365 mail server

How has it helped my organization?

We are a solutions provider and we have implemented this solution for many organizations. With these customers, we have managed to reduce a lot of infrastructure budgets and to provide an eco-friendly setup. Organizations can reduce, by a lot, electricity consumption and simplify their cooling plant setup.

What needs improvement?

It needs to improve the security features, because people still aren't confident enough to use a public cloud.

For how long have I used the solution?

I've used it for one year alongside Office 365 and Windows VM.

What was my experience with deployment of the solution?

There wasn't much except some issues faced when migrating into the cloud.

What do I think about the stability of the solution?

Not much.

What do I think about the scalability of the solution?

No issues encountered.

How are customer service and technical support?

Customer Service:

It's very good.

Technical Support:

They have very good support and lots of online training as well as having seminars and customer support available. I have joined many sessions through the Microsoft Virtual Academy.

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

We didn't use a previous solution.

How was the initial setup?

It's not complex and, in actual fact, it's easy. Ready made set-ups are available any time.

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

The pricing is good, but there is still a gap if you are going to manage a large setup and a big growth of an organization. If that's the case, then pricing will be big challenge especially the pricing forecast and your analysis of growth and IT budget.

Which other solutions did I evaluate?

I have done some studies of SalesForce AWS among others .

What other advice do I have?

It's a nice, very advanced technology based project that is very secure and cost effective cut edge technology. There are lots of cost and technical resources that can be cut while implementing this solution, to manage cost budget IT infrastructure for any organization.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
reviewer2149464 - PeerSpot reviewer
Lead Technical Consultant and PM Manager with 11-50 employees
Consultant
Top 20
Good scalability and has an easy initial setup process
Pros and Cons
  • "Its technical support team is good."
  • "They should include more accessible functions for image tooling."

What is our primary use case?

We use the solution as a customer database for travel desk applications.

What is most valuable?

The solution suits well for our server requirements. It doesn't require an extensive system to run. So, it is a fast, limited, and affordable database serving our business purpose.

What needs improvement?

They should include more accessible functions for image tooling. Presently, we are using optional features for it.

For how long have I used the solution?

I have been using the solution for about two years.

What do I think about the stability of the solution?

The solution is moderately stable. I rate its stability an eight out of ten.

What do I think about the scalability of the solution?

It is a scalable solution. We have around 200 solution users in our organization. I rate its scalability an eight out of ten.

How are customer service and support?

The solution's technical support team is good.

How would you rate customer service and support?

Positive

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

Previously, I used Microsoft's on-premises version.

How was the initial setup?

The solution's initial setup was straightforward. I rate the process an eight out of ten. It took one or two days to deploy it. Since it is cloud-based, we followed the standard Azure mechanism.

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

The solution is moderately expensive. I rate the pricing a six out of ten.

What other advice do I have?

One should be clear about their reporting environment. For instance, Microsoft ecosystem reporting supports only Power BI. Secondly, one should ensure they utilize more customization options than already issued.

I rate the solution as eight. It is a familiar product for users who already work on Microsoft environments. If you need a limited cut-down version, it also has an option for a single database.

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
Marco Cenzato - PeerSpot reviewer
Product Architect at Wolters Kluwer
Real User
Top 10
Has great scalability and simple management of the infrastructure
Pros and Cons
  • "The scalability and simple management of the infrastructure are the most valuable features."
  • "The problem is the automated configuration."

What is our primary use case?

The solution is used for a lender's business application. 

What is most valuable?

The scalability and simple management of the infrastructure are the most valuable features. 

What needs improvement?

They have some problems with the introduced features in the latest version of the server. The multiple query planning parameters have problems. The problem is the automated configuration. Even when they address the problems, there are still issues.

The second issue is to audit the real users on behalf of whom we operate secret servers. Normally in our application, we use only a single connection to leverage the pooling.

For how long have I used the solution?

I have been working with SQL Azure for eight years. 

What do I think about the stability of the solution?

The solution is highly stable. I rate the stability a ten out of ten. 

What do I think about the scalability of the solution?

The solution is hugely scalable yet it does not support auto-scaling and it is very time-consuming. The PR database takes a lot of time hence one should keep another server synchronized with the dataset. Presently, ninety thousand users are using the solution. I rate the scalability a six out of ten. 

How are customer service and support?

The technical support is very good. 

How was the initial setup?

The initial setup is very straightforward. 

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

I would rate the pricing a seven out of ten. 

What other advice do I have?

I would rate the overall solution a nine 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: Partner
PeerSpot user
PeerSpot user
IT Manager at European University
Real User
East to deploy with good documentation but can be expensive
Pros and Cons
  • "The solution is quite straightforward to set up."
  • "I want the pricing to be improved."

What is our primary use case?

We decided to implement some forms for different purposes. We needed to implement it on-premises, so we did this on Azure to support the data from the forms implemented on a SQL server, and on Azure on several databases. It's very easy. 

What is most valuable?

The solution is quite straightforward to set up.

It can scale. 

The solution is stable and reliable. 

What needs improvement?

I want the pricing to be improved. They should try to lower it for their customers. 

For how long have I used the solution?

I've used the solution for one year.

What do I think about the stability of the solution?

The stability is good. There are no bugs or glitches, and it doesn't crash or freeze. 

What do I think about the scalability of the solution?

The solution can scale. I can't say how much as I don't have a comparable use case on the cloud and on-premises. 

We have about five people using the solution right now. For now, we do not have plans to increase usage.

How are customer service and support?

The support is good. They have a good document library. If there is a problem, we can figure it out. 

How was the initial setup?

The initial setup is very straightforward. It's not complex at all. For us, it did not take more than one or two hours. It was quick to deploy. 

We only need one person on hand for deployment and maintenance. They are a developer. 

What about the implementation team?

We did not use a consultant for the implementation process. We have a lot of experience in Azure and a lot of systems in Azure as well. 

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

We have a yearly licensing fee we need to pay. It's not a cheap solution. 

What other advice do I have?

I'd recommend the solution to other users. 

Based on the experience I've had, I would rate it seven 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
Samuel Lambrecht - PeerSpot reviewer
Principal Industry Consultant at Intelligent Operations Solutions
Consultant
The response time was better than expected
Pros and Cons
  • "The most valuable aspect of SQL Azure is the SQL language itself. It's open and everybody can use it at my company. Also, we thought in the beginning that the response time would be inadequate, but it's actually decent. It's much better than expected. Then again, I'm not a programmer, but that's what I hear from our development team."
  • "They should also simplify the security in Azure. We are using the cloud as a platform, so there is no physical infrastructure. We're using Azure components like databases and servers to create an application. Integrating those components in terms of permissions and security is challenging for us. Maybe there is a lack of knowledge on our side, but it's not straightforward."

What is our primary use case?

We use SQL Azure for what we call an inspection round. Inspection rounds are mainly used by an inspector in the field to check the compliance of the equipment, like if a given machine doesn't have enough instrumentation. 

In any kind of plant, there is an inventory of assets. Most companies have an inspector who goes to the field to check the condition and record some indicators. The results of the inspection are recorded in our software. All the data from the inspection round is stored in our database in Azure. That is what we use the Azure database for.

We created a custom PaaS. It's not a pre-built device in the cloud. Azure components like SQL Azure and a web server are combined to create this solution. Our SQL performs better in that space than a readymade device.

What is most valuable?

The most valuable aspect of SQL Azure is the SQL language itself. It's open and everybody can use it at my company. Also, we thought in the beginning that the response time would be inadequate, but it's actually decent. It's much better than expected. Then again, I'm not a programmer, but that's what I hear from our development team. 

What needs improvement?

There are some characteristics called "joins," like "inner join," "full join," "left join," "right join," etc. It's a little confusing for some coders. I think that could be simplified. 

I'm in the analytic space, so I would introduce a higher level of coding using artificial intelligence. SQL is quite close to English. They could add a voice interface where you speak into it, and the machine writes the code for you. My weakness in coding requires something automated, so I can be more proactive. 

They should also simplify the security in Azure. We are using the cloud as a platform, so there is no physical infrastructure. We're using Azure components like databases and servers to create an application. Integrating those components in terms of permissions and security is challenging for us. Maybe there is a lack of knowledge on our side, but it's not straightforward. 

The data modeling is not good for me. There are better tools than SQL Azure when you need to create the abstract part of the database design. It's weak. It's not user-friendly, and the notation is specific to Microsoft. I believe we use a third-party tool for data modeling because it's easier to use. Communicating with that tool is easier than SQL Azure. The model is nicer.

For how long have I used the solution?

I have been using SQL Azure for about five or six years. We started using the solution for one of our clients, a mining company, more than five years ago. They were the first customers to use our solution.

What do I think about the stability of the solution?

We don't have any issues with stability. The primary issues in the cloud are privileges, security, and integration between applications. That is a total mess for us. When we need to get the application servers access to the Azure database. 

What do I think about the scalability of the solution?

SQL Azure is scalable.

How are customer service and support?

I only contacted Azure support once, and it was decent. We asked some questions, and they replied. I cannot it say was great or awful. They met our expectations. 

How was the initial setup?

Setting up SQL Azure is easy. Even I can do it. 

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

We pay around $1,200 per year for one customer based on what they currently use. It's mainly processing and storage. SQL Azure is a bit more expensive than other solutions. There are free databases, but they don't have the scalability of the Azure cloud. It might not be affordable for some companies, but it's highly scalable.

What other advice do I have?

I rate SQL Azure eight out of 10. I would recommend it to others depending on their needs. It might be beyond the budget of some companies.

Generally, what I like about Azure as a cloud is the analytics you can apply on top of that data. Azure provides a number of high-performing solutions for data science and analytics. The main issue is that you need to build the architecture to create a product that provides value for your customers.

It's about imagination and creativity, and most of the tools are there. In my case, ease of use matters because I lack the knowledge to explore more, but our development team could do that easily. 

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
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.