Paul Elson - PeerSpot reviewer
Applications Architect at Arthur Cox
Real User
Top 10
There is no infrastructure cost, and we can grow it or shrink it depending on the demand
Pros and Cons
  • "The main advantage of it is that there is no infrastructure cost. We don't have to host it here. So, there is no infrastructure cost."
  • "There is probably more functionality in our on-prem SQL Server than SQL Azure."

What is our primary use case?

We have a lot of stuff that is still on-prem, and we're only sticking our toe in the water with SQL Azure. For what we're doing, it is a simple database. We haven't yet put any of our harder stuff on Azure.

SQL Azure is in the cloud. So, it has to be the latest version. It is version agnostic.

What is most valuable?

The main advantage of it is that there is no infrastructure cost. We don't have to host it here. So, there is no infrastructure cost. 

The second advantage is elasticity. We can grow it or shrink it depending on the demand. We have no restraint on capacity.

What needs improvement?

There is probably more functionality in our on-prem SQL Server than SQL Azure. 

For how long have I used the solution?

I have been using this solution for about two years.

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

What do I think about the stability of the solution?

It is stable, and there are no issues.

What do I think about the scalability of the solution?

Its scalability is very good.

How was the initial setup?

It was straightforward.

What about the implementation team?

We have a third party for its deployment and maintenance.

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

We have the licensing fee, and we are also paying a third party to maintain it with an SLA.

There is no infrastructure cost, but its running costs are higher than expected. There is the cost of the Azure cloud, which is pricier than expected, but it is not specific to SQL Azure. It is specific to the cloud. You expect it to be cheaper, but it is more expensive to run it.

What other advice do I have?

I would advise going for it and exploring it. We've only dipped our toes in the water. We haven't put any of our main things. We're just toying with a few new applications, and we haven't brought everything across, but I would recommend it.

I would rate it an eight 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: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Independent Consultant at Unaikui
Real User
Top 5Leaderboard
Robust platform supporting deployment across multiple regions
Pros and Cons
  • "The automated scalability feature of SQL Azure has proven to be highly beneficial, particularly when deployed in the cloud."
  • "The product's pricing needs improvement."

What is our primary use case?

We use the product to extract data and present it for warehouse reporting.

What is most valuable?

The platform provides valuable scalability, stability, and robustness benefits.

What needs improvement?

The product's pricing needs improvement.

For how long have I used the solution?

We have been using SQL Azure for 3 years.

What do I think about the stability of the solution?

I rate the platform's stability an 8 out of 10.

What do I think about the scalability of the solution?

I rate the platform's scalability as 10 out of 10.

How was the initial setup?

The initial setup can be straightforward if you properly configure the product and utilize scripts effectively. Once the script is ready for cloud deployment, executing it is next. The solutions architect sets up the basic infrastructure using infrastructure as code principles. It involves carefully selecting resources, such as VMs and app services, and configuring them according to your requirements. Additionally, one needs to manage security aspects like opening and closing firewalls, which can introduce complexities to the setup process.

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

I recommend considering a pay-as-you-go pricing model initially.

What other advice do I have?

The automated scalability feature of SQL Azure has proven to be highly beneficial, particularly when deployed in the cloud. It can be done remotely, eliminating the need for manual intervention. However, it may become more challenging if the infrastructure reaches its limits, especially in vertical scaling scenarios.

Whether opting for AWS or Azure, the service offers guaranteed uptime, often around 99.9%. Additionally, it supports deployment across multiple zones and regions.

The transition from on-premises to SQL Azure can impact operational costs depending on the setup. It offers options like pay-as-you-use or dedicated services running 24/7. However, it's essential to evaluate your business case thoroughly before deciding.

I rate it an 8 out of 10.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
Flag as inappropriate
PeerSpot user
Buyer's Guide
SQL Azure
March 2024
Learn what your peers think about SQL Azure. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
768,857 professionals have used our research since 2012.
Zubair_Ahmed - PeerSpot reviewer
Senior Consultant at Veraqor
MSP
Top 5
A secure cloud-based relational database solution providing high availability and seamless integration into Azure services
Pros and Cons
  • "One of the most valuable aspects is its seamless integration with Azure Data Factory."
  • "There is room for improvement regarding the pricing structure."

What is our primary use case?

I'm currently involved in setting up pipelines on Azure for data extraction from a source to a target destination within specific time intervals. The goal is to automate the process of moving data efficiently.

How has it helped my organization?

Previously, the database was on-premises, but now, with the SQL database in the Azure cloud, extracting information from on-premises automatically makes it available in the Azure cloud. The data becomes instantly accessible in the cloud, making it more efficient for you to work with. It's a straightforward and easy process.

What is most valuable?

One of the most valuable aspects is its seamless integration with Azure Data Factory. Its value lies in the significant time savings as there's minimal competition or customization challenges. This smooth integration makes it easy for me to work with both seamlessly.

What needs improvement?

There is room for improvement regarding the pricing structure. It would be beneficial if the cost is reduced.

For how long have I used the solution?

I have been working with it for more than a year.

What do I think about the stability of the solution?

The system is impressively reliable and stable. I would rate it ten out of ten.

What do I think about the scalability of the solution?

I would rate the scalability capabilities eight out of ten.

How are customer service and support?

I've had a positive experience working with their technical support team. I would rate it nine out of ten.

How would you rate customer service and support?

Positive

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

I currently use the Sophos server management solution, which is an on-premises solution. The primary reason for switching to SQL Azure is our plan to migrate to cloud.

How was the initial setup?

The initial setup used to be a bit complex, but now it's much easier. I would rate it eight out of ten.

What about the implementation team?

The deployment process is remarkably quick, taking only a few minutes to connect to the cloud and set up data storage. There's a standard setup without the need for additional or advanced deployment tools. It is handled by a dedicated team, constituting around three to five percent of the overall process. This includes individuals responsible for deployment, validation, and user support, ensuring a straightforward and efficient deployment experience.

What was our ROI?

The return on investment is a significant advantage for our company, especially since we've implemented this product across multiple distributions and clients. The satisfaction of our clients with the product support is notable. I would rate it nine out of ten.

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

I find that they are relatively expensive, especially when compared to AWS, where the prices are notably lower.

What other advice do I have?

I would highly recommend it. Overall, I would rate it 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: I am a real user, and this review is based on my own experience and opinions.
Flag as inappropriate
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
Flag as inappropriate
PeerSpot user
Raghavaraju R - PeerSpot reviewer
Technical Lead at HCL Technologies
Real User
Top 5
Reliable with good security privileges and good templates
Pros and Cons
  • "The product is easy to set up."
  • "It does take some time to learn about the environment."

What is our primary use case?

This is one of the applications where we are supporting in production.

If we are using SQL STL, it is a manual process. If we use STL Azure, we will import all the templates from the Azure cloud or Microsoft cloud. There are already pre-defined templates and pre-defined procedures in Azure. We will be using those instead of manual processes. Azure is helping us to be more flexible and handle time scaling.

What is most valuable?

I have limited experience with the tool. It's hard to describe its best feature. 

It's pretty helpful from a technical standpoint.  It's also dominating other clouds, including AWS and Google. It's better at improving itself. 

The product is easy to set up.

It's stable and reliable. 

I find the product to be scalable. 

The solution is pretty affordable. 

Microsoft has a lot of useful security privileges. 

What needs improvement?

I haven't really come across any shortcomings. I also have limited experience. We need to do more training and research.

It does take some time to learn about the environment. 

For how long have I used the solution?

I've been using the solution for six months. 

What do I think about the stability of the solution?

The solution is stable and reliable. There are no bugs or glitches. It doesn't crash or freeze. 

What do I think about the scalability of the solution?

The solution is easy to scale. 

We have more than 1,000 people using the solution. I'm not sure of the exact number of users. We have multiple accounts and end customers. 

How are customer service and support?

In terms of technical support, we do have a lot of subscription privileges. We do have seniors, and tech leads to assist. They can discuss issues with the vendor and technical support.

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

We have used different solutions in the past. We found that if we worked manually, we would need more resources. With this solution, we have more time flexibility and stability. More complex things can be worked around.

How was the initial setup?

The initial setup is straightforward. 

It is easy. We only use one account, a Microsoft Azure account, and we can pull all templates from there. It's got an easy user interface and admin interface which makes implementation straightforward. All you have to do is deploy all the scenarios. After that, it will take some time and flexibility to understand the environment.

It takes six hours to finish all the setup, including completing the installation of SQL and integrating with Genesis.

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

We find the solution to be less expensive than other options. 

What other advice do I have?

We're customers and end-users.

I would recommend this solution. Microsoft is very efficient and forward-looking - making it less expensive to build the setup for Azure SQL. Even though we do have one Microsoft account, we can directly integrate it with everything at one time. We do have limited licenses which makes it less expensive compared to the Google cloud or AWS or whatever else is in the other market. 

I'd rate the solution eight 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: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
PedroNavarro - PeerSpot reviewer
BI Development & Validation Manager at JT International SA
Real User
Top 5
Stable product with fast setup
Pros and Cons
  • "The solution is quire more stable than other tools."
  • "I would like to the solutions scalability to be improved."

What is our primary use case?

We use this solution to store data MODS that are going to be consumed by Power BI.

What is most valuable?

The solution is quire more stable than other tools.

What needs improvement?

I would like to the solutions scalability to be improved.

For how long have I used the solution?

I have used this solution for the past three years.

What do I think about the stability of the solution?

This is a stable solution in general.

What do I think about the scalability of the solution?

It is moderately scalable in my opinion. On-premise, you can definitely scale it up better, but it is a bit restricted on the cloud.

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

We used Oracle Databases and SQL Server databases on-premise.

How was the initial setup?

The initial setup was easy for about five hundred users and it required just a couple of managers.

What about the implementation team?

Our consultants helped with the implementation and the process took maybe ten minutes.

What other advice do I have?

I would recommend this solution for those who are looking to integrate it. I would rate this an eight 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
Mangesh Masaye - PeerSpot reviewer
Manager at UPL
Real User
Top 10
Scalable and stable SQL database solution that's easy to install, with good technical support
Pros and Cons
  • "Database services and Active Directory related functions for this solution are good. Stable, scalable, and easy to install. Its technical support is good."
  • "Integration needs to be improved for this solution."

What is our primary use case?

We have multiple use cases for this solution, and it really depends on the application team requirements. Our analytics team uses it. We also use it for database migration.

What is most valuable?

What I found most valuable in Azure SQL are the functions related to Active Directory and the database services. You can do everything in Azure SQL.

What needs improvement?

Integration needs to be improved for this solution.

For how long have I used the solution?

We've been using Azure SQL since 2013.

What do I think about the stability of the solution?

Azure SQL is a stable solution.

What do I think about the scalability of the solution?

Azure SQL is scalable.

How are customer service and support?

We had to contact technical support about some of our issues, and it was good. They have good people.

How was the initial setup?

Installation for this solution is very easy, but you'll need to be a certified installer to find the setup easy.

What about the implementation team?

We implemented Azure SQL through an integrator and data partner.

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

Azure SQL has licenses which you can pay yearly or monthly. You have the option to pay yearly or monthly for the license.

What other advice do I have?

Microsoft Azure is something that we are using. We are using Microsoft Azure from the Cloud. It's the public cloud we are using. We use multiple services on Azure, e.g. mDNS, Traffic Manager, Database, etc., depending upon the attributes and aspects. We're using Azure SQL.

We have a cloud team made up of 10 people who use this solution, then there are various application teams that also use Azure SQL. At the moment, we have no plans of increasing usage for this solution, but we're open to it.

I would recommend this solution to others looking into using it.

I'm rating Azure SQL a 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
Vice President (Technology) at Shaligram Infotech LLP
Real User
Top 5Leaderboard
Around-the-clock access to your database, maintenance-free, and good performance
Pros and Cons
  • "The most valuable feature from the infra point of view is you don't have to keep any on-prem infrastructure, it is available all the time whenever you want to access it."
  • "The solution can be improved by reducing the cost so more users can be added."

What is our primary use case?

Our primary use case of this solution is to host our databases and it is fulfilling our requirements.

What is most valuable?

The most valuable feature from the infra point of view is you don't have to keep any on-prem infrastructure, it is available all the time whenever you want to access it.

What needs improvement?

The solution can be improved by reducing the cost so more users can be added.

For how long have I used the solution?

I have been using the solution for 15 months.

What do I think about the stability of the solution?

Our customers work in the space of small and medium businesses area segment. For them, the way the solution is being offered and used is working and is considered to be stable.

What do I think about the scalability of the solution?

Not much is required in terms of scalability. So the foreign enterprises which are spanning the globe that requires scalability could be different. Small and medium businesses have a presence only in one location or maybe a couple of cities within a country. this is a reasonably scalable solution for them.

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

The license is based on the number of users.

What other advice do I have?

I give the solution nine out of ten.

Currently, we have 25 to 30 developers using the solution.

There are alternative solutions available like Oracle or MySQL but I have not used any of them.

I recommend the solution.

Which deployment model are you using for this solution?

Private Cloud

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

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user