No more typing reviews! Try our Samantha, our new voice AI agent.
Berry Van Esch - PeerSpot reviewer
Principal Cloud Specialist at a manufacturing company with 1,001-5,000 employees
Real User
Top 5
Nov 19, 2025
Automatic performance tuning and strong data protection have supported reliable database hosting
Pros and Cons
  • "The feature I like the most about Microsoft Azure SQL Database is the scaling part."
  • "I think Microsoft Azure SQL Database should be cheaper. The license is expensive, but not always; it depends on the case regarding pricing and licensing."

What is our primary use case?

My main use case for this solution is hosting application databases.

What is most valuable?

The feature I like the most about Microsoft Azure SQL Database is the scaling part.

It is cost-effective, which is why I appreciate that feature.

I find Microsoft Azure SQL Database very easy to use. Some basic knowledge from Azure is needed, but then you can use it quite easily.

I am using the automatic tuning feature in Microsoft Azure SQL Database for some applications. It scales when there is more need for performance, so that has been the impact on my database performance.

The solution's security features, such as using Defender, have a positive impact on my data protection strategies. Defender helps protect our data.

What needs improvement?

I think Microsoft Azure SQL Database should be cheaper. The license is expensive, but not always; it depends on the case regarding pricing and licensing. The cost could be lower in some cases.

For how long have I used the solution?

I have been using Microsoft Azure SQL Database since 2016.

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

What do I think about the stability of the solution?

I have not experienced any real issues.

What do I think about the scalability of the solution?

I find it scales workloads well; it scales automatically if you use the correct settings.

How are customer service and support?

I have had experience with customer support and technical support, but not for SQL. The experience is sometimes good and sometimes not as good; it depends on the person you get and the product overall for Microsoft.

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

I sometimes used Azure SQL Managed Instance before choosing Microsoft Azure SQL Database. The reason I use the other one is based on application requirements; that is the only reason.

If it is possible, I would consider switching to Microsoft Azure SQL Database completely, but most applications I have do not support any other tool, so I have no choice.

How was the initial setup?

The deployment and the migration process of this platform are easy and straightforward.

What was our ROI?

It has helped me reduce my company's total cost of ownership.

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

I do use Azure Hybrid Benefits. I have seen less cost as a benefit since implementing this feature, and it is cheaper.

What other advice do I have?

We are exploring the usage of AI in our company. I think Microsoft Azure SQL Database has a place in that AI environment.

I do not know about Microsoft Azure SQL Database's ability to power next-generation AI applications since I have not used that feature, so I only have information from the marketing slides from Microsoft and the sessions, but I have no real experience.

I use the native backup option and have experience with the backup and restore functionalities. It works so far. I assess the reliability in terms of maintaining uptime and availability as good.

Microsoft's expertise in SQL Server is not important to us when considering cloud database options. My advice for other companies thinking of getting Microsoft Azure SQL Database is to use it. They should start with a proof of concept and a test environment, and then if it is successful, roll out to the production environment. I would rate this solution an 8 overall.

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. Partnership
Last updated: Nov 19, 2025
Flag as inappropriate
PeerSpot user
Senior Deputy Director at Central Provident Fund Board (CPFB)
Real User
Top 10
Nov 19, 2025
Saves engineering effort by managing infrastructure and supports seasonal traffic demands without hardware upgrades
Pros and Cons
  • "Transitioning from a traditional on-premise SQL database to Microsoft Azure SQL Database is beneficial because features such as auto-indexing allow us to scale during peak seasons and scale back on demand, which is very useful for handling our spiky peak traffic based on seasonal factors, avoiding the need to purchase more hardware as required with traditional setups."
  • "My only concern regarding the pricing, setup cost, and licensing of Microsoft Azure SQL Database is that we have a large database size but limited compute requirements, which has forced us to move towards a higher core just to meet our database sizing requirements."

What is our primary use case?

Microsoft Azure SQL Database serves as our main database for our application and microservice infrastructure.

What is most valuable?

What I appreciate most about Microsoft Azure SQL Database is that the infrastructure is managed by Microsoft, which means we do not need to worry about patching, relieving significant time from our engineers.

Transitioning from a traditional on-premise SQL database to Microsoft Azure SQL Database is beneficial because features such as auto-indexing allow us to scale during peak seasons and scale back on demand, which is very useful for handling our spiky peak traffic based on seasonal factors, avoiding the need to purchase more hardware as required with traditional setups. Moving to the cloud saves us not only engineering hours for operations but also helps us manage our spiky website traffic more effectively.

What needs improvement?

I would change Microsoft Azure SQL Database by removing the four terabyte limit and reconsidering how the database cores relate to the storage.

For how long have I used the solution?

I have been using Microsoft Azure SQL Database for four years.

What do I think about the stability of the solution?

My experience with Microsoft Azure SQL Database's automatic tuning has revealed that while we have been using it, we realized the SQL database index that was created was somehow reverted a few days later, likely because of the nature of how our application behaves due to random and spiky web traffic. This may indicate the index was added but reverted later, which was likely caused by our application behavior contributing to this outcome.

What do I think about the scalability of the solution?

I have not used the intelligent performance features of Microsoft Azure SQL Database. Microsoft Azure SQL Database's security features, including Defender for Database, meet our compliance standards as it helps us check all our permissions, roles, and accounts, alerting our team in the event of any changes made, and ensuring we address vulnerabilities detected by Defender for SQL Database.

How are customer service and support?

Regarding customer service and technical support from Microsoft, we are currently on a mission-critical support plan, and the engineers provide timely advice. In one incident involving website outages due to high database I/O, the engineers helped pinpoint the exact problem and guided us on how to resolve it.

How would you rate customer service and support?

Positive

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

Before choosing Microsoft Azure SQL Database, I was using an on-premises legacy system.

How was the initial setup?

My experience with the deployment process of Microsoft Azure SQL Database is straightforward, as we are using Entity Framework to deploy our database changes and Terraform for the infrastructure. Using Entity Framework to deploy our database schema has been good without any problems.

What was our ROI?

The biggest return on investment for us when using Microsoft Azure SQL Database is the time savings since we do not need to manage SQL database updates regularly as it is now fully managed by Microsoft.

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

My only concern regarding the pricing, setup cost, and licensing of Microsoft Azure SQL Database is that we have a large database size but limited compute requirements, which has forced us to move towards a higher core just to meet our database sizing requirements. We will be checking with the SQL database team on how to transition from our current setup to eventually a hyperscale database.

What other advice do I have?

My advice for other companies considering Microsoft Azure SQL Database is to understand their database requirements and, if they have a larger data size, to consider Managed Instance before committing to SQL Database. I rate this product 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?

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
Last updated: Nov 19, 2025
Flag as inappropriate
PeerSpot user
Buyer's Guide
Microsoft Azure SQL Database
June 2026
Learn what your peers think about Microsoft Azure SQL Database. Get advice and tips from experienced pros sharing their opinions. Updated: June 2026.
900,644 professionals have used our research since 2012.
Database Administrator at a energy/utilities company with 1,001-5,000 employees
Real User
Top 10
Nov 19, 2025
Managed services have simplified database administration and improved backup and recovery processes
Pros and Cons
  • "The compatibility with SQL Server for transitioning legacy systems to Microsoft Azure SQL Database is very important because it gives us assurance that what we experience today, we can get the same performance on the other side."
  • "Microsoft Azure SQL Database could improve by providing more support for Availability Groups within Managed Instance."

What is our primary use case?

Microsoft Azure SQL Database serves as our database after we migrated a database to the cloud and we're checking it out to see if that will be somewhere we want to go with a lot more of our applications.

What is most valuable?

Managed Instance is the feature of Microsoft Azure SQL Database that I like the most.

I have not yet used Microsoft Azure SQL Database intelligent performance features.

My experience with Microsoft Azure SQL Database automatic tuning is intermediate, but it has definitely helped because it takes a lot of the guesswork out of manually going through and finding what could be causing some bottlenecks.

I assess the effectiveness of Microsoft Azure SQL Database security features in meeting compliance standards as pretty good.

Microsoft Azure Active Directory integration and Microsoft Azure Key Vault have helped me manage data security.

The compatibility with SQL Server for transitioning legacy systems to Microsoft Azure SQL Database is very important because it gives us assurance that what we experience today, we can get the same performance on the other side.

One example of how these features have benefited my organization is backup and recovery, which is almost identical to how we do it because as DBAs, your most important job is to make sure the data is available.

What needs improvement?

Microsoft Azure SQL Database could improve by providing more support for Availability Groups within Managed Instance.

For how long have I used the solution?

We have been using Microsoft Azure SQL Database for eight months now.

What do I think about the scalability of the solution?

One challenge we faced deploying Microsoft Azure SQL Database was refreshing the databases because we keep copies of them and refresh them to other environments.

How are customer service and support?

I would describe my experience with customer service and technical support as excellent, from the few times we have had to reach out.

How would you rate customer service and support?

Positive

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

We were using a similar solution previously, which was SQL Server on-premise.

How was the initial setup?

Latency and how strong support would be if something goes wrong stood out in my evaluation process before selecting Microsoft Azure SQL Database.

What was our ROI?

We have seen a return on investment.

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

I would say I am at a basic experience level with the pricing, setup costs and licensing because while I am the administrator for the service, I do not provision the services and worry about the cost.

When it comes to licensing costs, it is a lot cheaper when you have Managed Instance versus a standalone SQL server.

What other advice do I have?

Use the tools that Microsoft provides to assess your current environment if you are considering using Microsoft Azure SQL Database. I would rate this overall review as a nine.

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?

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
Last updated: Nov 19, 2025
Flag as inappropriate
PeerSpot user
reviewer2778789 - PeerSpot reviewer
Head Of IT Infrastructure at a consultancy with 10,001+ employees
Real User
Top 20
Nov 21, 2025
Improves response time for critical applications but requires better recommendations and large-scale suitability
Pros and Cons
  • "The feature I like the most in Microsoft Azure SQL Database is the recovery point of time to recover the database when needed, which has benefited my organization by improving response time in seconds and milliseconds, and this will improve customer experience and satisfy the commercial team as well."
  • "What worked with Microsoft Azure SQL Database is good, but the challenge I faced is that it does not fit for a large-scale or tier-one business application."

What is our primary use case?

My main use case for Microsoft Azure SQL Database is hosting an in-house application to serve different business streams.

What is most valuable?

The feature I like the most in Microsoft Azure SQL Database is the recovery point of time to recover the database when needed.

These features have benefited my organization by improving response time in seconds and milliseconds, and this will improve customer experience and satisfy the commercial team as well.

What needs improvement?

Microsoft Azure SQL Database can be improved by getting recent recommendations from Microsoft's side to be applied on a quarter basis, such as the latest batch update.

For how long have I used the solution?

In a POC, I have been using Microsoft Azure SQL Database for one or two years.

What do I think about the scalability of the solution?

What worked with Microsoft Azure SQL Database is good, but the challenge I faced is that it does not fit for a large-scale or tier-one business application.

How are customer service and support?

I would evaluate customer service and technical support for Microsoft Azure SQL Database as very good.

On a scale from one to ten, I would rate service and technical support an eight because it needs improvement, especially for accelerating support or solving a problem immediately or having expertise available around the clock, because there might be a mid-tier experience from the support team, and in some cases, we need to involve an expert immediately to solve our cases.

How would you rate customer service and support?

Positive

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

Prior to adopting Microsoft Azure SQL Database, I was using another solution such as PostgreSQL and Oracle databases in place, and we have open sources as well in place, such as Mongo SQL or Mongo database.

How was the initial setup?

I would describe my experience with deploying Microsoft Azure SQL Database as good.

What was our ROI?

I have seen a return on investment with Microsoft Azure SQL Database.

The return on investment I can share is that it improves customer experience, and improving customer experience means getting more customer base to use our products, and this is ROI for using such products.

Which other solutions did I evaluate?

Before selecting Microsoft Azure SQL Database, I considered other solutions such as Oracle and PostgreSQL.

What other advice do I have?

I have not yet used Microsoft Azure SQL Database's intelligent performance features.

My experience with Microsoft Azure SQL Database's automatic tuning is that the database should be optimized and tuned very well, either by doing something to enhance the performance or by consulting support teams to give advice to be applied, such as the latest patch set, or to analyze queries to get optimizer feedback to be applied immediately in order to get applications tuned all the time.

I assess the effectiveness of Microsoft Azure SQL Database's security features in meeting compliance standards as compliant with our security rules.

I have not seen Azure Active Directory integration and Azure Key Vault help manage data security.

The capability with SQL Server for transitioning legacy systems to SQL Databases is important to me as we depend on a famous database technology such as Oracle, but we need to mix and match our technologies in terms of databases and SQL as well, such as Azure SQL, in order to have heterogeneous environments, not depending on one solo vendor. We are trying to move a mid-tier or a small tier to Microsoft Azure SQL Database.

My advice to other organizations considering Microsoft Azure SQL Database is to move a mid-tier or a small team to Microsoft Azure SQL Database. I give this review an overall rating of seven.

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 does not have a business relationship with this vendor other than being a customer.
Last updated: Nov 21, 2025
Flag as inappropriate
PeerSpot user
Software Engineer at a tech consulting company with 11-50 employees
Real User
Top 10
Nov 19, 2025
Connects data seamlessly to support API development and consolidates infrastructure efficiently
Pros and Cons
  • "Microsoft Azure SQL Database benefits my company on a day-to-day basis as it serves as an excellent place to store our database and data."
  • "Microsoft Azure SQL Database is one of those solutions that helps consolidate our infrastructure, though unfortunately it is not the only solution we use."

What is our primary use case?

My main use case for Microsoft Azure SQL Database is to connect source data for our APIs and hydrate different things for that.

What is most valuable?

I appreciate Microsoft Azure SQL Database because I enjoy SQL. It works well out of the box, and I know what I'm getting. The product functions as expected without requiring much maintenance.

Microsoft Azure SQL Database benefits my company on a day-to-day basis as it serves as an excellent place to store our database and data. I would appreciate the ability for all teams to operate on one database instead of several different systems. Microsoft Azure SQL Database is one of those solutions that helps consolidate our infrastructure, though unfortunately it is not the only solution we use.

What needs improvement?

I think Microsoft Azure SQL Database can be improved, but I do not use it frequently enough to identify significant pain points.

For how long have I used the solution?

In my area of expertise, I have been working for about three years, and in my current position, I have been using Microsoft Azure SQL Database for only about one year.

What do I think about the stability of the solution?

Regarding reliability, I would generally consider Microsoft Azure SQL Database quite reliable in maintaining uptime and availability.

What do I think about the scalability of the solution?

My impressions of Microsoft Azure SQL Database's ability to scale workloads are positive. I think it works very well with no complaints.

How are customer service and support?

Microsoft's expertise in SQL Server is very good when considering cloud database options. I have not used the support myself, but the documentation is very up-to-date. If I ever need to look something up, it is quite easy to find.

How would you rate customer service and support?

Positive

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

We have different solutions implemented across our organization. I know that we have some relational and some non-relational options, which is probably part of the reason for having multiple systems. The main differences between those solutions and SQL would be the relational versus non-relational aspect. We use a lot of legacy software, so that probably plays into some compatibility aspect. Beyond that, I am not certain about other differences.

Other than the relational versus non-relational distinctions, I am not entirely clear on why we maintain these different solutions.

How was the initial setup?

The migration and deployment process of Microsoft Azure SQL Database is quite straightforward. If I ever encounter issues, Copilot is quite helpful, as is the documentation. I would not say it is very complicated.

What was our ROI?

From my point of view, the biggest return on investment with Microsoft Azure SQL Database is that it is great to store our customer data and everything for our different products and be able to access that easily as we want to. I do not know what we put into it, so I am not certain what that looks like from an ROI perspective. However, it works smoothly, I have no complaints, and it is a good database solution.

Microsoft Azure SQL Database has probably helped reduce my company's total cost of ownership.

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

I have never looked at the pricing, setup costs, and licensing for Microsoft Azure SQL Database.

Which other solutions did I evaluate?

I am not considering switching away from Microsoft Azure SQL Database or conducting a proof of concept of another solution.

What other advice do I have?

I would rate Microsoft Azure SQL Database as a five on a scale from one to five in terms of ease of use.

I assess Microsoft Azure SQL Database's ability to integrate with other Microsoft applications as excellent, with no complaints.

I have not had hands-on experience with Microsoft Azure SQL Database working with AI. I know that functionality exists, and part of what I am trying to focus on at Ignite this year is learning how I can integrate different AI solutions and workflows with Microsoft Azure SQL Database.

I am not using the automatic tuning feature in Microsoft Azure SQL Database.

I do not know what impact Microsoft Azure SQL Database's security features have on my data protection strategies, if any.

I am not using the data encryption feature on Microsoft Azure SQL Database, or at least not knowingly.

I have not used the backup and restore functionalities of Microsoft Azure SQL Database. Our database engineers have touched that before, but I have never used it. It seems to work as intended.

We are still using other solutions alongside Microsoft Azure SQL Database.

My advice for other companies that are considering Microsoft Azure SQL Database is to go for it, especially if you are using other Microsoft products. It seems to integrate with everything very well, and it just works.

I have rated this review a nine out of ten overall.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
Last updated: Nov 19, 2025
Flag as inappropriate
PeerSpot user
reviewer2779185 - PeerSpot reviewer
System Architect at a financial services firm with 10,001+ employees
Real User
Top 20
Dec 8, 2025
Supports third-party applications and simplifies migration through seamless security integration
Pros and Cons
  • "Hosting these types of databases on-premises can be challenging, but if you have the ability to do it on Azure, that is beneficial, and it also removes security obstacles as well."

    What is our primary use case?

    My main use cases for Microsoft Azure SQL Database are third-party applications.

    What is most valuable?

    The features of Microsoft Azure SQL Database that I appreciate the most are Availability Groups.

    My organization benefits from consolidation efforts with these features.

    Active Directory integration and Azure Key Vault have helped manage data security.

    User permissions authentication to Microsoft Azure SQL Database is something that has been helpful.

    What needs improvement?

    I have no comments at the moment on how Microsoft Azure SQL Database can be improved.

    I have no comments on additional features that I would like to see released in the next release.

    I do not have any comments at this time.

    For how long have I used the solution?

    I have been using Microsoft Azure SQL Database for less than a year.

    What do I think about the stability of the solution?

    I have not used Microsoft Azure SQL Database intelligence features.

    What do I think about the scalability of the solution?

    Regarding my experience with SQL Database Automatic Tuning, I have not used it yet.

    How are customer service and support?

    I have not raised any issues regarding customer service and technical support.

    On a scale from one to ten, I would rate customer service technical support a seven.

    I would probably give that rating based on my previous history opening up other support cases with Microsoft.

    How would you rate customer service and support?

    Positive

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

    Prior to adopting Microsoft Azure SQL Database, I was using on-premises SQL Server environments to address similar needs.

    The adoption of more Azure services led me to consider a change.

    How was the initial setup?

    I have no comments describing my experience with deploying Microsoft Azure SQL Database.

    I faced no challenges, but it was seamless because I already had Microsoft Entra and Active Directory set up with seamless permissions and an established environment.

    Which other solutions did I evaluate?

    Before selecting Microsoft Azure SQL Database, I considered Postgres.

    What stood out to me in my evaluation process was the ease of getting the third-party application to support SQL Server.

    What other advice do I have?

    I am currently looking into transitioning legacy systems to Microsoft Azure SQL Database to perform an on-premises migration from SQL infrastructure to Azure SQL.

    In this particular use case with Microsoft Azure SQL Database, it actually moves many of the hurdles away. Hosting these types of databases on-premises can be challenging, but if you have the ability to do it on Azure, that is beneficial, and it also removes security obstacles as well.

    I have no comments on anything they can improve on, change, or any additional release I would like to see.

    I would rate this review an eight overall.

    Which deployment model are you using for this solution?

    On-premises

    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.
    Last updated: Dec 8, 2025
    Flag as inappropriate
    PeerSpot user
    Charley Hanania - PeerSpot reviewer
    Data Platform Specialist at QS2 AG - Quality Software Solutions
    Real User
    Top 5
    Dec 16, 2024
    It is very easy to implement, manage, and offers great insights into what is happening inside the engine
    Pros and Cons
    • "Microsoft Azure SQL Database is integrated into other Azure capabilities and has a great foundation being on SQL Server with a long history of security, performance, and usability from a DBA perspective."
    • "SQL Server has helped to significantly reduce the total cost of ownership."
    • "Microsoft Azure SQL Database could improve by having better tooling in terms of connecting to other database platforms and better capabilities around programmable interfaces. There should be more fine-tuning on the storage layer. I would like to see T-SQL improvements to automatically translate features from other database platforms for easier migration, as well as some improvements around column store and native capabilities like those in Iceberg and PowerK built into the SQL Server product."

    What is our primary use case?

    The primary use cases for Microsoft Azure SQL Database are to establish relational databases in the cloud and database-focused applications that are cloud-ready.

    How has it helped my organization?

    SQL has been a game changer for many of the organizations I have worked for. It is very easy to implement, manage, and offers great insights into what is happening inside the engine. 

    What is most valuable?

    Microsoft Azure SQL Database is integrated into other Azure capabilities and has a great foundation being on SQL Server with a long history of security, performance, and usability from a DBA perspective. 

    Once you've set up a server, adding databases is easy. There's a minor challenge with having data in separate databases that you want to connect like we do on premises.

    I'm looking forward to using some of these new AI-driven functions that have come out around vectorization. Having the data closer to my transactional databases or data makes it easy to augment and enhance the Database and applications I currently use.

    It's great that Azure SQL now seamlessly integrates with Microsoft Fabric. It's a first-tier service in the cloud that connects to web applications and other databases. The data transformation orchestration capabilities within Database Factory and similar capabilities make it effortless to move that stuff forward.

    What needs improvement?

    Microsoft Azure SQL Database could improve by having better tooling in terms of connecting to other database platforms and better capabilities around programmable interfaces. There should be more fine-tuning on the storage layer. I would like to see T-SQL improvements to automatically translate features from other database platforms for easier migration, as well as some improvements around column store and native capabilities like those in Iceberg and PowerK built into the SQL Server product.

    For how long have I used the solution?

    I have used Microsoft Azure SQL Database for about seven years.

    What do I think about the stability of the solution?

    The latency in the cloud is great, but it increases for hybrid applications. I hope this will improve over time, potentially due to changes in the networking stack in Azure

    What do I think about the scalability of the solution?

    Microsoft Azure SQL Database scales well within paid limits, but once size restrictions and top-tier thresholds are hit, transitioning becomes difficult. It would be beneficial if it could scale without a difficult transition process.

    How are customer service and support?

    The expertise and support from Microsoft, especially at conferences and through documentation on their website, are valuable. They have invested significantly, although there is room for more investment in training materials to ensure our people are well-trained and have information readily available for managing the solution.

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

    It is much better than the other database platforms that we have used.

    How was the initial setup?

    Migrating our data and that of our customers from on-premises to the cloud was seamless. Azure Hybrid Benefit helped make the transition straightforward, particularly in like-to-like scenarios.

    We had some trouble with SQL Agent and maintenance capabilities. It was difficult to transition those into the cloud, so we had to reinvent a couple of things because they weren't available in the cloud. There was a cost, and there was some confusion a number of times about what the expectation should be when it goes into the cloud.

    What was our ROI?

    SQL Server has helped to significantly reduce the total cost of ownership. In one company that I led, we reduced costs from $20 million to about $5 million per year.

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

    Azure Hybrid Benefit reduced costs by facilitating an easy transition of on-premises databases to the cloud. Licensing discussions were straightforward, minimizing the challenges of moving data to the cloud.

    What other advice do I have?

    I would rate the overall solution between eight and nine, as it covers the majority of our needs and competes better than most other databases we use.

    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 does not have a business relationship with this vendor other than being a customer.
    PeerSpot user
    Maanda Ambani - PeerSpot reviewer
    Senior AI Specialist at Nedbank
    Real User
    Top 20
    Nov 28, 2024
    Resources like storage automatically scale up without any manual intervention
    Pros and Cons
    • "SQL is easy to use and easily integrates with many systems. There aren't many code changes needed when you're using SQL databases. Integrating Azure SQL with other Microsoft applications is instant because they're all Microsoft solutions."
    • "Our migration to Azure for most databases has increased our organization's efficiency and reduced the maintenance required to manage on-premises infrastructure."
    • "There isn't any new improvement that I can think of at the moment. We have different deployment choices, such as running SQL on an Azure VM or deploying SQL-managed instances. The managed instance is a significant improvement over running SQL in an Azure VM."

    What is our primary use case?

    Currently, SQL is our main database repository within the bank. All of our client data is stored on the SQL database, and it's the main database we use in the field. Most of our critical systems are on SQL databases.

    How has it helped my organization?

    Our migration to Azure for most databases has increased our organization's efficiency and reduced the maintenance required to manage on-premises infrastructure. With on-premises infrastructure, you have to build and maintain your setup. It has reduced our downtime. We've improved our productivity because we can automate database deployments and script execution within the database.

    What is most valuable?

    SQL is easy to use and easily integrates with many systems. There aren't many code changes needed when you're using SQL databases. Integrating Azure SQL with other Microsoft applications is instant because they're all Microsoft solutions. 

    What needs improvement?

    There isn't any new improvement that I can think of at the moment. We have different deployment choices, such as running SQL on an Azure VM or deploying SQL-managed instances. The managed instance is a significant improvement over running SQL in an Azure VM.

    For how long have I used the solution?

    I have used Azure SQL for about four years.

    What do I think about the stability of the solution?

    Initially, we had latency issues with SQL databases because we hadn't optimized the platform. Over time, we overcame these challenges with support, and now we no longer experience latency issues. We can't tell the difference between running on-prem or Azure because we no longer have those latency issues.

    What do I think about the scalability of the solution?

    Azure SQL databases allow easy scaling. Microsoft manages the underlying infrastructure in a managed instance environment, so all you consume is the database. Resources like storage automatically scale up without any manual intervention.

    How are customer service and support?

    We have an enterprise agreement with Microsoft, which provides us with excellent support. Microsoft played a significant role, even from a training perspective, and provided resources that directed us toward the right deployment path.

    How would you rate customer service and support?

    Positive

    How was the initial setup?

    Deploying Azure SQL is straightforward. We had a few challenges, but Microsoft offers an excellent training program. They ensured we got the training to understand the deployment. For example, we wanted to deploy the traditional framework clusters, but Microsoft pointed us in the right direction to raise our resources.

    What was our ROI?

    It's hard to quantify because we didn't calculate the costs when we were on-premises, but it may have lowered the total cost of ownership because you only purchase the storage you need and pay for what you're using. If you're managing your own data center, you always have to overprovision your systems and pay for storage space you're not using. I think it's cost-efficient.

    What other advice do I have?

    I would rate the overall solution an eight out of ten.

    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 does not have a business relationship with this vendor other than being a customer.
    PeerSpot user
    reviewer2595303 - PeerSpot reviewer
    Sr. Principal Database at a manufacturing company with 10,001+ employees
    Real User
    Top 20
    Nov 27, 2024
    Enables us to significantly enhance our operational efficiency
    Pros and Cons
    • "The integration with Azure Data Factory is seamless and straightforward, described as just a click away."
    • "Azure SQL Database has significantly reduced our total cost of ownership by eliminating the need for managing physical infrastructure, including data warehouses and data centers."
    • "Certain features available commercially may not be applicable in our gov cloud."
    • "Sometimes, we encounter limitations due to our use of a government cloud environment, which differs from commercial cloud platforms."

    What is our primary use case?

    Azure SQL serves a variety of purposes across our client base. It supports both customer-facing and internal products, depending on the specific needs of each client.

    How has it helped my organization?

    Using Azure SQL Database is not difficult.

    I'm excited about the Azure SQL database's ability to power next-generation AI applications because its capabilities unlock greater potential.

    The Azure Hybrid Benefit simplifies the process of migrating servers to the cloud by reducing the licensing complexities and costs associated with running Windows Server or SQL Server workloads in Azure.

    Integrating Azure SQL database with other Microsoft applications is easy. For someone with my level of experience, it is not complicated at all. 

    We remain committed to delivering our services with consistent willingness and enthusiasm. Utilizing Azure SQL Database has enabled us to maintain our productivity levels without interruption. This technology significantly enhances our operational efficiency.

    Azure SQL Database has significantly reduced our total cost of ownership by eliminating the need for managing physical infrastructure, including data warehouses and data centers.

    What is most valuable?

    The integration with Azure Data Factory is seamless and straightforward, described as just a click away. From my experience, this integration is not overly complicated for someone at my level. However, it might be challenging for a newcomer. Additionally, Azure SQL helps in reducing the company's total cost of ownership because we don't have to manage on-premises infrastructure. Migrating servers is easier, and there is less concern about licensing. These features also aid in cost reduction.

    What needs improvement?

    Sometimes, we encounter limitations due to our use of a government cloud environment, which differs from commercial cloud platforms. Certain features available commercially may not be applicable in our gov cloud. To overcome this, we collaborated with the network team to develop alternative solutions. We always approach tasks with multiple plans, A, B, and C to proactively address potential challenges and avoid reactive problem-solving.

    For how long have I used the solution?

    I have been using Microsoft Azure SQL Database for two years.

    What do I think about the stability of the solution?

    The latency and availability of the Azure SQL database have been satisfactory thus far.

    What do I think about the scalability of the solution?

    As Azure SQL database is a Platform-as-a-Service offering managed by Microsoft, we are confident in its ability to scale workloads effectively.

    How are customer service and support?

    Microsoft provides excellent service and is always available to support us. They are very supportive and engaged.

    How would you rate customer service and support?

    Positive

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

    We were predominantly a Microsoft shop, and choosing Azure SQL was a natural progression from on-premises to the cloud.

    What about the implementation team?


    What was our ROI?


    What other advice do I have?

    I would rate Azure SQL eight out of ten. This is because things change frequently, bringing new features and capabilities we haven't fully explored yet. I always leave room for growth, considering potential challenges we haven't encountered.

    Microsoft's SQL Server expertise was a key factor in our decision to adopt their cloud database solutions. Their consistent support and readily available communication have proven invaluable, particularly the helpful human interaction we've experienced.

    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 does not have a business relationship with this vendor other than being a customer.
    PeerSpot user
    reviewer2596227 - PeerSpot reviewer
    Enterprise employee at a computer software company with 1,001-5,000 employees
    Real User
    Top 10
    Dec 16, 2024
    It's easy to provision and integrates well on the back end with our functions and logic apps
    Pros and Cons
    • "It integrates well on the back end with our functions and logic apps."
    • "I rate Microsoft Azure SQL Database nine out of 10."
    • "There is a need for dynamic scaling support without losing current transactions. That should be part of the standard offering to SKUs. It doesn't have Auto SQL. We have HyperSQL, but there are limitations on the Elastic Pool. It only allows 25 databases. It would help if we could automatically analyze and optimize long-running queries instead of handling these tasks manually."
    • "There is a need for dynamic scaling support without losing current transactions. That should be part of the standard offering to SKUs."

    What is our primary use case?

    We use Microsoft Azure SQL Database mainly for the backend of the transaction of data. It is used for various sectors like healthcare, patient data, and ERP.

    What is most valuable?

    Azure SQL's user interface makes it easy to provision a database. It integrates well on the back end with our functions and logic apps. While Azure SQL is probably not a good fit for running AI-based applications on top of it, AI might provide better performance monitoring or bottleneck analysis. AI can help the SQL server operate better. 

    What needs improvement?

    There is a need for dynamic scaling support without losing current transactions. That should be part of the standard offering to SKUs. It doesn't have Auto SQL. We have HyperSQL, but there are limitations on the Elastic Pool. It only allows 25 databases. It would help if we could automatically analyze and optimize long-running queries instead of handling these tasks manually. 

    For how long have I used the solution?

    We have been using Azure SQL Database for about 10 years.

    What do I think about the stability of the solution?

    For our solution, Microsoft Azure SQL Database has been accessible, though there are performance bottlenecks related to old code and long-running or poorly optimized queries.

    What do I think about the scalability of the solution?

    Scaling is primarily manual unless using Elastic Pool. Automatic scaling without transaction loss is a desired feature. Scalability could be improved with auto scale options.

    How are customer service and support?

    Our interaction with Microsoft has been limited as our team is experienced. However, we recently worked with Microsoft on the new database watcher feature and confirmed limits for the hyperscale with Elastic Pool.

    How would you rate customer service and support?

    Positive

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

    Our solution was initially built for an on-premises data center using SQL Server as the backend. Moving to Azure, we continued with Azure SQL Database because it supports the majority of needed functionalities.

    How was the initial setup?

    We used managed instances and standard offerings to manage the transition from on-prem data hosting to Azure, given the lack of auto-scaling.

    What about the implementation team?

    Our internal DBA team handled the implementation, leveraging their expertise to ensure a smooth process.

    What was our ROI?

    Our main savings come from using Elastic Pool, which reduces costs by 30 to 40 percent for multiple databases and 10 percent from vCore provisioning. The serverless feature should save a lot, but the database is rarely paused or parked, so we don't save as much as we should. 

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

    We do not use Azure Hybrid Benefits because of company policy. Hence, all licensing costs are associated with Azure SQL licensing rather than bringing on-prem licenses to Azure.

    Which other solutions did I evaluate?

    Options like Cosmos DB and vector databases are considered for AI applications. However, we stay with Azure SQL for transactional data stores.

    What other advice do I have?

    I rate Microsoft Azure SQL Database nine out of 10. It's still missing some features, so I deducted one point. 

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