Try our new research platform with insights from 80,000+ expert users
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.

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?

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
Marco Cenzato - PeerSpot reviewer
Product Architect at Wolters Kluwer
Real User
Top 10
Enables us to manage highly intensive workloads and scale in real-time and on demand
Pros and Cons
  • "They have good documentation. It's concentrated information."
  • "Their support is nice but their responses aren't effective."

What is our primary use case?

We use the public cloud model of this solution. 

How has it helped my organization?

With Azure, we can achieve very high workloads (~6K queries/min) and, if necessary, scale databases in real-time with only one minute of downtime for our customers. It enables us to scale up on demand and to scale down when needed. 

What is most valuable?

The most valuable feature of Azure Database is the read-scaleout one: in Premium and Business tiers, the logic single DB consists of 4 identical DBs, the main one (writable) and three read-only synchronized copies; in our application we can use the three read-only copies for almost all of the read-only query and this allows workload distribution and minimizes the concurrency in write operations.

They have good documentation. It's concentrated information. 

What needs improvement?

Migrating existing application to SQL database had many problems, developing a new app for Azure Database not. 

Their support is nice but frequently their responses aren't effective. 

The documentation is always updated with the latest features but the documentation for the database features should be better. It doesn't specify when specific features will be released. The documentation needs improvement. They should improve the way they explain the information to the market.

It should have better support for UTF 8 (a feature already present on the on-premises version of SQL Database 2019) a for Hadoop integration.

For how long have I used the solution?

I have been using this solution for two years in a production environment and for four years in development.

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

How was the initial setup?

The initial setup was incredibly easy. Moving from a standard tier to a business tier is not so easy and the documentation isn't so clear the presence of the read scale out copies.

What other advice do I have?

I would rate it a nine 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
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.
PeerSpot user
Manager of Architecture/Design with 51-200 employees
Real User
You can arrange training and demos based on the client’s budget.

What is most valuable?

  • Cloud products reduce the cost of the production of software products
  • You do not have to buy the product at the up-front market cost
  • You pay for it as you use the product
  • You can develop a product on your own premises
  • Just give the key to the vendor, so that there are no separate deployment costs.
  • You save on travel and meals, as well as housing required for a development team required for deployment and implementation.
  • The distance between the client and development team is invisible.
  • You may arrange virtual-real trainings/demos based on the affordability of the client’s budget.
  • There is no requirement of special hardware, as costs and additional software are bared by the cloud platform. You can spend as you need based on what the client’s needs are and scale hardware and software up to the client’s needs.
  • Cost of the platform and the software upgrades are covered under the service contract.

How has it helped my organization?

We developed our product with a small team of .NET developers for a client, a law university in Delhi, India.

We received the requirements from conversations of our team with our client, over the phone, and with email.

There was minimal training required for the team to be trained in cloud, as every developer in the team had basic .NET skills.

This product was then intended to be used by law university students for their training in court room sessions as student lawyers debating against each other to deduce lawful judgements of a case under study.

We provided virtual chat rooms for the students and had facilitated a method to share video sessions of their debates in virtual court rooms.

What needs improvement?

Microsoft has delivered on its promise by providing a free, developer-student (community) edition of Visual Studio.

For how long have I used the solution?

I have used this for around 6-9 months to develop and implement the product.

What do I think about the stability of the solution?

There are questions in the developers’ and clients’ minds:

  • Since Azure is a pay-by-use product, what is the provision for the future?
  • If, for some reason, we lost this provision, what fallback parachute is Microsoft planning for customers?
  • What risk planning and hedging should the client do? There is no such possibility, but the concern must be addressed by Microsoft.

Physically owned products are also subject to failure. The hardware on premise also fails and needs to be maintained, so there is expected downtime.

Microsoft provides mirroring of cloud servers. There is a sure provision of backup and restore of the cloud environment.

By centralizing these services and products at a central location (datacenter), we are optimizing on services and goods cost and sharing these costs with other cloud dwellers.

By going towards the cloud, we are going towards a virus and spyware free environment.

We are moving away from special, owned hardware and products, to cloud-based datacenters, which exist in the other resource rich, low cost, areas.

This is Platform as a Service of the SOA revolution.

Along with overseas datacenters, we shall promote near shore or local datacenters to capitalize on the cloud advantage. We will also address issues of risk hedging, which will spur job growth in local areas.

What do I think about the scalability of the solution?

We didn’t have any scalability problems.

How are customer service and technical support?

We did not explore this option, but the response was good for whatever we did request.

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

We switched due to the advantages I mentioned earlier.

How was the initial setup?

You don’t have to install the product on the cloud platform. You receive a login with pre-pared software installs. Custom requirements need to be implemented or requested.

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

Every region of a country has cheaper locations that can provide cost advantages, and data center growth must be equally distributed on earth with electricity and resource rich, low cost, areas to keep the cost of the cloud minimal. This will also avert natural and man-made calamities.

The United States and other countries can take this cloud option to the next level of off-shoring without any immigration and terrorism issues, enabling development in impoverished areas of the world.

This can further cut down the cost of software development, other "down-the-line" products, services and goods, and will empower the poor and neglected of the world.

This will also improve trade between the countries. There are always imbalances amongst populations in any country in skills and monetary status. An equalizer could be achieved by allowing more trade, more freedom, and more pollination.

In India, we had to start development using the 3-month free subscription Azure platform .net and SQL . Now as far as I know, vs 2015 community edition is a free download. One can develop software application in it and deploy it with an Azure subscription which is pay as you use. All nitty-gritty development can be done by a development team. That's why Microsoft has delivered their dream cloud promise with the zero cost alternative of community edition.

Which other solutions did I evaluate?

We considered local cloud and physical install options. These options were expensive and less effective.

What other advice do I have?

Microsoft Cloud is reliable and dependable.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
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
Rafael Veloso - PeerSpot reviewer
Consultant at SoftwareONE
MSP
Top 20
Helpful support, scalable, and beneficial turning process
Pros and Cons
  • "The backup solution in Azure is great, the firewall settings in SQL are very easy to use and work very well. Additionally, the turning process is very good and has improved the SQL services and queries."
  • "SQL Azure could improve by adding more features."

What is our primary use case?

I have used SQL Azure for the backend tier application. If the customer has the flow change application with an application service, they will use the backend. I always suggest using SQL Server and Azure.

What is most valuable?

The backup solution in Azure is great, the firewall settings in SQL are very easy to use and work very well. Additionally, the turning process is very good and has improved the SQL services and queries.

What needs improvement?

SQL Azure could improve by adding more features.

For how long have I used the solution?

I have used SQL Azure within the past 12 months.

What do I think about the stability of the solution?

I have found SQL Azure to be stable.

What do I think about the scalability of the solution?

The scalability of SQL Azure is very good.

How are customer service and support?

The support of SQL Azure is very good.

How was the initial setup?

The implementation of SQL Azure is simple.

What other advice do I have?

I would recommend this solution to others.

I rate SQL Azure a nine out of ten.

Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
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
software engineer at a university with 11-50 employees
Real User
Great programming facility with good problem solving capabilities; very efficient
Pros and Cons
  • "The solution is efficient and easy to use."
  • "Lacks some tools on the SQL Server for data virtualization."

What is our primary use case?

Our core business is to make mathematical models for production and solutions. We don't develop or use software. The data comes with the Excel format stored in SQL and we write complex queries about the data and run it in our models. Our data is not sensitive and it's a matter of having a server for storage. I'm a software engineer.

What is most valuable?

SQL Azure is efficient and very easy to use. The programming facility is very good and the solution is great at solving problems. 

What needs improvement?

SQL Azure could offer a lot more services and applications. I'd also like to see some tools that we could use on the SQL Server for data virtualization. That would be an improvement. 

For how long have I used the solution?

I've been using this solution for 10 years. 

What do I think about the stability of the solution?

We don't run critical data and haven't had any issues with the stability. 

How are customer service and support?

We have a lot of experience and good programmers and IT administrators in the company, so we haven't needed customer support. 

How was the initial setup?

Our implementation was straightforward and carried out internally. We have 10 users of this solution, the majority are in production and engineering, with a couple in software engineering. 

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

Our license is pay-as-you-go and we pay around €200 per month. You need to keep an eye on this because with scaling the cost can increase quite quickly. 

Which other solutions did I evaluate?

This solution is more expensive than some others, but not as expensive as Amazon, Google and Oracle, which all have a lot of extra costs involved. 

What other advice do I have?

I recommend this solution and rate it 10 out of 10. 

Which deployment model are you using for this solution?

Public Cloud

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

Microsoft Azure
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Alvaro Olivares - PeerSpot reviewer
Head of Cloud Engineering at a financial services firm with 10,001+ employees
Real User
Top 5
Easy setup, good backup features, and good stability and scalability
Pros and Cons
  • "The backup features are the most valuable."
  • "Its compatibility with existing applications can be improved. Its compatibility is currently a little bit imbalanced."

What is our primary use case?

We use it as a backend product. We are using the Managed Instance and the SQL Database.

What is most valuable?

The backup features are the most valuable.

What needs improvement?

Its compatibility with existing applications can be improved. Its compatibility is currently a little bit imbalanced.

For how long have I used the solution?

I have been using this solution for about two years.

What do I think about the stability of the solution?

It is pretty good. It seems very stable.

What do I think about the scalability of the solution?

It has good scalability. We have about a thousand users.

How are customer service and technical support?

Technical support was very good. I would rate them a ten out of ten.

How was the initial setup?

The initial setup is pretty easy. The deployment took about a day.

What other advice do I have?

It is a good product for any new development or organization.

I would rate SQL Azure a nine out of ten. It is working fine right now, and I am pretty happy with this solution.

Which deployment model are you using for this solution?

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