Raed Gharzeddine - PeerSpot reviewer
Technical advisor and software architect at Technical advisor and software architect
Real User
Top 5Leaderboard
Stores complex relational data with consistency requirements and handles query tuning and security very well
Pros and Cons
  • "I prefer using Microsoft SQL Server because I like the experience and the way Microsoft handles the query tuning and security."
  • "One of the nice features in Microsoft SQL Server is the SQL Server CLR, which we sometimes need to use to protect our procedures using C# or CLR. This is not available in the SQL Azure database."

What is our primary use case?

We use SQL Azure to store our relational data. Whenever I have complex relational data with consistency requirements, I use SQL Azure Database.

I'm currently working in a small startup. There are just two people using this solution now: a developer and myself. I'm working as a technical consultant and an architect.

What is most valuable?

Microsoft recently added a JSON feature. I use all the features in a normal relational database, and they're very helpful. I prefer using Microsoft SQL Server because I like the experience and the way Microsoft handles the query tuning and security. These are really good features for database experts.

What needs improvement?

One of the nice features in Microsoft SQL Server is the SQL Server CLR, which we sometimes need to protect our procedures using C# or CLR. This feature isn't available in the SQL Azure database. It's available in the Managed Instance in the Azure Database.

You can create SOAR procedures using C# and can get user-defined functions using C#. You can extend the database and the data files using CLR files. This feature isn't available on the Microsoft Azure SQL Database. I understand they can't add it because it's a managed service, and having CLR probably doesn't work for them, but it would be nice if they could add this feature.

For how long have I used the solution?

I have used this solution for almost six 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.
767,995 professionals have used our research since 2012.

What do I think about the stability of the solution?

I would rate the stability as eight out of ten.

What do I think about the scalability of the solution?

It is very scalable, depending on how much you're willing to pay. We can have up to 4,000 DTUs, but we haven't needed that much scalability.

How are customer service and support?

We had an instance where we weren't able to deploy Cosmos DB on a UAE data center, and Microsoft helped us. We haven't had any issues so far with technical support.

How was the initial setup?

Setup is straightforward. You just create an SQL Server instance account on Azure, and then you can create SQL databases. It's very easy to create tables and procedures. I mainly use the SQL data buckets inside Visual Studio. From there, I deploy databases to Azure from Visual Studio.

What about the implementation team?

It's easy to do the deployment in-house. Visual Studio provides a lot of functionality to make deploying solutions to Azure simple and easy.

What was our ROI?

Using SQL Server database with all the features will provide a good return on investment. Once you move to Azure, you remove all the capital expenses by having to acquire the license and deploy it on-premises.

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

When you go with SQL Azure Database, you can create a small database, which is around $4 to $5 per month for development purposes. It's very cheap in that respect. I think it's a little bit expensive compared to other services that Microsoft offers on Azure. PostgreSQL, MySQL, and MariaDB are a bit cheaper than SQL Server.

If the price were lower, I think it would become more attractive for developers to use.

What other advice do I have?

I would rate this solution as eight out of ten. 

It's a very easy solution. Microsoft also has Data Explore. The entire Microsoft environment makes things easy for developers. It's very easy to set up SQL on Azure. I highly recommend it. I really like it, and I've been working with SQL Server since 2000.

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
Architect of Business Intelligence Solutions at Nestle
Real User
Easy to manage solution for analytics and business intelligence
Pros and Cons
  • "It's user-friendly. Compared to other solutions, it's based more on clicks, not on scripts. It's easy to manage."
  • "There could be more collaboration with other tools like Data Factory and Databricks."

What is our primary use case?

We are using this solution for analytics and business intelligence.

The solution is deployed on-prem and on cloud. The cloud provider is Microsoft.

There are tens of thousands of users. In my market in Poland, there are maybe 1,000 using the application based on the solution.

What is most valuable?

It's user-friendly. Compared to other solutions, it's based more on clicks, not on scripts. It's easy to manage.

What needs improvement?

There could be more collaboration with other tools like Data Factory and Databricks.

For how long have I used the solution?

I have been using this solution for 20 years.

What do I think about the stability of the solution?

It's stable.

What do I think about the scalability of the solution?

It's scalable, but it could be better.

How are customer service and support?

I don't use support because the documentation is very good, and the solution is easy to manage.

How was the initial setup?

In Azure, deployment takes minutes. It's easy.

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

The cost is around $2,000 per month.

What other advice do I have?

I would rate this solution 8 out of 10.

My advice is to read the documentation and blogs.

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?

Amazon Web Services (AWS)
Disclosure: I am a real user, and this review is based on my own experience and opinions.
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.
767,995 professionals have used our research since 2012.
Ahmed-Ramy - PeerSpot reviewer
CEO at TMentors
Real User
Seamless management and the remote access in SQL Azure with good reliability
Pros and Cons
  • "It's the type of product that doesn't need much technical support assistance as it works seamlessly."
  • "It's a little bit limited in terms of functionality."

What is our primary use case?

We use it also for database management, as a database engine.

We use it for different projects - mainly when we have lots of data and the customer can't afford to pay the license for SQL Server, which is not cheap. That's the main reason we use MySQL or Postgres or other databases. 

What is most valuable?

The management and the remote access in SQL Azure are seamless.

The solution is extremely scalable.

We've found the stability to be quite good.

It's the type of product that doesn't need much technical support assistance as it works seamlessly.

What needs improvement?

Some data types are not available on SQL Azure while it's available on SQL Server. It's a little bit limited in terms of functionality. The difference is not huge. You can go back and forth between them. We used to do this all the time. However, it is something to note.

Maybe they need to add the data types that exist in SQL Server, not in SQL Azure. That would make it better.

The pricing can be high in certain countries as Microsoft doesn't adjust for regional pricing. 

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. The performance is good.

What do I think about the scalability of the solution?

The product is on the cloud. It's very scalable for that reason. If a company needs to expand it, it can do so.

How are customer service and support?

Most of the time no one needs support on SQL products or services. That said, the support in Azure is amazing. We never encountered an issue that they didn't solve. This speaks to the quality of Azure.

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

We also use SQL Server. The main difference is SQL Server is a full-featured database engine, whereas MySQL is based on what we call a file-based database, which is similar to flat files as a database engine.

The recommendation of which to use is based on the use case. It depends on what use case the customer will need. If they don't have the capacity to manage their own server, I would recommend Azure, as it's managed. You don't have to worry about the management and administration.

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

The pricing is prevalent for everything Microsoft. The thing is, they don't allow different pricing for different regions. Some countries are price sensitive.

What other advice do I have?

I'm an end-user.

I'd rate the solution at a nine out of ten.

Disclosure: My company has a business relationship with this vendor other than being a customer: partner
PeerSpot user
Lakshman Nimmakayala - PeerSpot reviewer
Enterprise Cloud Architect at UBS Financial
Real User
Top 5
Supports major capability requirements, easy to install, and scalable
Pros and Cons
  • "The most valuable aspects of this solution are the integration with the darknet stack especially Microsoft, table groups, supports major capability requirements, and SQL always-on feature."
  • "The solution could improve by supporting more operating systems."

What is our primary use case?

SQL is basically a relation database, it can be used for any key-value related data models. Anything which is a table and column-based can be used. If you are an already existing SQL customer or a document tester worker, then I think it is common to go for SQL or Oracle. More present, you have Cosmos DB, it can be used as both SQL and NoSQL databases. This is the database that we are exploring today, and what we are using more.

What is most valuable?

The most valuable aspects of this solution are the integration with the darknet stack especially Microsoft, table groups, supports major capability requirements, and SQL always-on feature.

What needs improvement?

The solution could improve by supporting more operating systems.

In a future release, I would like to see more development on SQL servers on containers where you can manage a skill across multi-clouds.

For how long have I used the solution?

I have been using this solution for four years.

What do I think about the scalability of the solution?

We have more than 10,000 users using the solution in my organization. 

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

We use Oracle products running in parallel with this solution but for different parts of our business. There are at times different requirements needed but most of the Windows systems work with this solution.

How was the initial setup?

The installation was easy. They have a tool to assist with the migration of your old database to SQL.

What about the implementation team?

We have a database team which is approximately 200 people. They do the engineering, optics, development, and operations. 

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

There is a license required to use the solution and it cost $30 to do the installation.

What other advice do I have?

I would recommend this solution and we plan to use it in the future.

I rate SQL Azure a nine out of ten.

Which deployment model are you using for this solution?

Hybrid Cloud
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
PeerSpot user
SehrishTahir - PeerSpot reviewer
Account Manager at Jaffer Business Systems
Real User
Top 5Leaderboard
A reliable and affordable solution to customize applications
Pros and Cons
  • "The most valuable feature of the solution is that our customers do not have to manage the solution."
  • "The solution has to scale up its expertise for hosting Oracle."

What is our primary use case?

Our customers in the bank sectors use the solution for their websites. Our private customers use the solution to customize their applications on the cloud because they do not want to buy separate hardware. Some of our customers also have their on-premise SAP hosted on Azure.

What is most valuable?

The most valuable feature of the solution is that our customers do not have to manage the solution. Partners manage and optimize the solutions for the customers. 

The solution is also better cost-wise because if we host on hardware, we will have to change the hardware after four or five years. Also, if there is an issue with the hardware, the responsibility falls on the IT department. Customers do not like these responsibilities. With SQL Azure, everything is safe and secure. The clients pay a subscription fee and have fewer responsibilities.

What needs improvement?

Azure does not provide features like RDS for Oracle that AWS offers. The solution has to scale up its expertise for hosting Oracle.

For how long have I used the solution?

My organization has been a partner with Microsoft since 2008.

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. Almost ten to twelve of our customers are using the solution.

How are customer service and support?

The support is good. We go to Microsoft for every escalation.

How was the initial setup?

The initial setup is pretty easy. Our team is interested in working for Azure and other Microsoft products. We don't require much support from Microsoft for setup.

What about the implementation team?

The deployment doesn't take much time. We only have to check for our client’s requirements. We can provide the services to the client within 15 to 20 days.

Our technical team manages the deployment. The team checks all Microsoft policies before discussing them with the customer. We draw up a proposal and then present it to our customers. We explain to our customers how their data will be added to Azure.

We may need two or three people to deploy the solution. Depending on the environment, the deployment takes one or two months or even 15 days. Once the deployment is done, the solution can be managed through a partner portal. We might also need two or three people from the customer’s organization to refresh or optimize the solution.

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

The price could be slightly cheaper. Our customers pay for licenses annually.

What other advice do I have?

AWS secured much business in Pakistan because of RDS for Oracle. There is not much difference between AWS and Azure’s prices. AWS and Azure differ in price by a few dollars. Technically both solutions have different capabilities. AWS has a far better capability. People prefer AD authentication by AWS over Azure. We have Microsoft-certified trainers in Pakistan.

We have been asking our customers to choose Azure because they will get a lot of benefits by adopting a cloud solution. Since hardware is not easily available within Pakistan due to dollar disparity, a lot of people are choosing Azure. 

We have been pushing Azure very aggressively for the past four to five years. People continue to implement the solution despite policy challenges. One of our customers wants to host nine to ten applications on Azure. There is a lot of demand for AWS and Azure. Overall, I rate the solution a nine out of ten.

Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
PeerSpot user
Sunil Singh - PeerSpot reviewer
Lead Engineering at GlobalLogic
Real User
Top 10
It's good with transactional systems.
Pros and Cons
  • "SQL Azure is good with transactional systems."
  • "If it's a transitional system, there is a lot of reporting, so the solution becomes a bit slow when it's churning out tons of data, but it's good for a mid-sized application"

What is our primary use case?

We use SQL Azure to integrate the on-prem resources with the cloud. It creates a replica of our database in the cloud. We have more than 50 users.

What is most valuable?

SQL Azure is good with transactional systems.

What needs improvement?

If it's a transitional system, there is a lot of reporting, so the solution becomes a bit slow when it's churning out tons of data, but it's good for a mid-sized application

For how long have I used the solution?

We've been using SQL Azure for around five years.

What do I think about the scalability of the solution?

We are using SQL Azure extensively. It is still being utilized in the gigabyte and petabyte range for older applications, as well.

How are customer service and support?

We are a gold partner, so we have the option to use gold-tier support.

How was the initial setup?

Deploying SQL Azure is easy. It takes only one engineer to deploy.

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

We have an enterprise license. 

What other advice do I have?

I rate SQL Azure nine out of 10. I would recommend it to others.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Enterprise End User Operations at a comms service provider with 1,001-5,000 employees
Real User
A stable solution that offers good stability and excellent content management
Pros and Cons
  • "The stability is good and the performance is fantastic. Even when we try to do an inquiry into issues we can do it easily."
  • "The initial setup is complex."

What is our primary use case?

Our primary use case is for content management and publishing offsite for external users. We also use it as the intranet to get the largest professional view of the SharePoint version.

What is most valuable?

In SQL we tend to do normal queries. The features we use quite a bit are the backup and monitoring and also the export and import tools for data. We use all of these on a daily basis.

What needs improvement?

We're still discovering aspects of the solution. We haven't yet deployed all of the components, so I'm not sure of what additional features we'd like to see.

For how long have I used the solution?

I've been using the solution for since 2010.

What do I think about the stability of the solution?

The stability is good and the performance is fantastic. Even when we try to do an inquiry into issues we can do it easily. The administration of the tool itself is perfect and the performance is good. On the safety level, we have layers of a firewall. I think this makes it more secure, to help secure the level of encryption and the encryption of the data itself. 

What do I think about the scalability of the solution?

We deploy the solution on four machines and are using VMware. We can continue to add on top of this as much as we like. Scalability isn't a problem at all.

How are customer service and technical support?

We have many layers of technical support, starting with us and our own team. The vendor of our region also provides support if we need it.

How was the initial setup?

The initial setup is complex.

We had to do some data collecting and we had issues with having redundant databases, meaning we had to do some synchronization between the databases. We did the integration of the networks and handled the clustering on top of the components of SQL. At the beginning we faced some issues, especially getting the servers to talk to each other. We needed to do some workarounds, but ultimately we were successful.

What about the implementation team?

We did the implementation ourselves. 

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

We have a three-year contract. The cost was somewhere around $70-80,000 for the original deployment, which was about two years ago. In the future, we may need to expand our license to include more company employees.

Which other solutions did I evaluate?

We did a survey for seeing what technologies were in the market. We ended up with Microsoft because of the general business requirements. Also, we could add the components to the solution for product management. We could add document management, for example, and many other alternatives that covered various business requirements. We ended up with this solution because of the ability to utilize the components. We also had the flexibility of using other plug-ins that helped with the commercial aspects of the business.

What other advice do I have?

We use the private cloud version of the solution.

I would rate the solution nine out of ten. I would recommend it.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Hammad  Khan - PeerSpot reviewer
Deputy Manager at S2 Consulting Services
Real User
Easy to integrate and relatively affordable in a developing market
Pros and Cons
  • "We have multiple applications running for our customers that we can integrate into Azure SQL."
  • "Scalability is an issue because we can't upgrade to new versions due to hardware limitations."

What is our primary use case?

About 25 people in my office use SQL Azure. Including customers, there are about 400-500 people.

What is most valuable?

We have multiple applications running for our customers that we can integrate into Azure SQL.

What needs improvement?

Scalability is an issue because we can't upgrade to new versions due to hardware limitations. 

For how long have I used the solution?

I've been using SQL Azure for a couple of years.

What do I think about the stability of the solution?

I rate SQL Azure nine out of 10 for stability because we haven't faced any major issues.

What do I think about the scalability of the solution?

I rate SQL Azure six out of 10 for scalability.

How are customer service and support?

We haven't used technical support because we haven't faced any major challenges, but I would rate their documentation and knowledge base eight out of 10. 

How would you rate customer service and support?

Positive

How was the initial setup?

I rate SQL Azure eight out of 10 for ease of setup. In the worst-case scenario, deployment takes a few days. A couple of employees could do it easily. Usually, it's an admin and a developer. 

What was our ROI?

I rate SQL Azure six out of 10 for ROI. We've seen a 40-50% ROI

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

I rate SQL Azure eight out of 10 for affordability. I live in a developing country where cost is always an issue. The price should be negotiable, and there should be more discounts.

What other advice do I have?

I rate SQL Azure eight out of 10. I recommend it because we haven't faced any major issues. 

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: Distributor
PeerSpot user