Try our new research platform with insights from 80,000+ expert users
reviewer2595900 - PeerSpot reviewer
Senior IT Analyst at a government with 1,001-5,000 employees
Real User
It seamlessly integrates with applications like SharePoint Online, PowerApps, and PowerFlow
Pros and Cons
  • "Azure SQL is easy to integrate and simplifies things from a licensing perspective. We're comfortable with SQL versus other types of databases, so we feel better talking to Microsoft."
  • "I rate Microsoft Azure SQL Database nine out of 10."
  • "Adding users to Azure SQL could be easier. You need to script it out, but it would be nice if it had a UI where you can click and add them. It's not a major thing because we script things all the time, but it would be a minor thing that helps us."
  • "Adding users to Azure SQL could be easier. You need to script it out, but it would be nice if it had a UI where you can click and add them."

What is our primary use case?

We primarily use SQL on Azure for reporting and incident situation awareness around our area. It's utilized for public information dissemination regarding different safety programs, ensuring nothing too complicated or in-depth.

How has it helped my organization?

Azure SQL is easy to integrate and simplifies things from a licensing perspective. We're comfortable with SQL versus other types of databases, so we feel better talking to Microsoft.

What is most valuable?

Reporting and incident situation awareness around our area and just reporting public information. The database seamlessly integrates with other Microsoft applications like SharePoint Online, PowerApps, and PowerFlow. We don't have to worry about maintenance, such as patching the servers. Leveraging other Microsoft technologies outside of our network is a lot easier.

It's a lot easier to create databases. There are some limitations in terms of permissions, but you can create databases by clicking a few buttons. You only need to provide the user authentication, and that's it.

What needs improvement?

Adding users to Azure SQL could be easier. You need to script it out, but it would be nice if it had a UI where you can click and add them. It's not a major thing because we script things all the time, but it would be a minor thing that helps us.

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

For how long have I used the solution?

I have been using SQL on Azure for about ten years.

What do I think about the stability of the solution?

I haven't encountered any real latency issues. Our internal database is heavily utilized, but externally on the Azure SQL, we don’t push it to its limit.

What do I think about the scalability of the solution?

Based on our limited use cases, Azure SQL appears highly scalable without any issues.

How are customer service and support?

It's really a non-factor at this point, as we are comfortable with the system's ease of use.

How would you rate customer service and support?

Positive

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

I've used MySQL and other databases before, but our organization decided to go with Microsoft, and it felt natural due to my background as a .NET developer.

How was the initial setup?

The initial setup was straightforward, and the integration process has become much easier over time.

What other advice do I have?

I rate Microsoft Azure SQL Database nine 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.
Flag as inappropriate
PeerSpot user
RyanWhite - PeerSpot reviewer
Digital Consulting Coe Lead & Delivery Engineer at Lunavi-wa
Real User
It's almost identical to the on-prem solution with additional features and integration
Pros and Cons
  • "I like that Microsoft Azure SQL Database is almost identical to an on-premise SQL Server except for a few things, like how you edit rows and some jobs that you can't run."
  • "Microsoft Azure SQL Database scales well, allowing us to increase our compute level or add more instances as required."
  • "They could improve Azure SQL by adding some of the features available on-prem, such as cross-database queries and the ability to run particular jobs. We need to migrate those to something else, like a function or logic app."
  • "They could improve Azure SQL by adding some of the features available on-prem, such as cross-database queries and the ability to run particular jobs. We need to migrate those to something else, like a function or logic app."

What is our primary use case?

We primarily use Microsoft Azure SQL Database for application databases for web applications and sometimes native iOS and Android platforms. We also employ it for the backend and analytics, often migrating data over to Fabric and One Lake for Power BI analytics.

How has it helped my organization?

Microsoft Azure SQL Database is quite impactful as we use it for most projects. 

What is most valuable?

I like that Microsoft Azure SQL Database is almost identical to an on-premise SQL Server except for a few things, like how you edit rows and some jobs that you can't run. It has some useful features and integrations, like Microsoft Fabric.

What needs improvement?

They could improve Azure SQL by adding some of the features available on-prem, such as cross-database queries and the ability to run particular jobs. We need to migrate those to something else, like a function or logic app. 

Data transformation units are also confusing to sell to our clients because they're these weird, nebulous things. Do you need five or 50? 

For how long have I used the solution?

I have been using Microsoft Azure SQL Database since it first started in 2009.

What do I think about the stability of the solution?

Microsoft Azure SQL Database does not seem to have any significant latency issues and handles millions of rows well.

What do I think about the scalability of the solution?

Microsoft Azure SQL Database scales well, allowing us to increase our compute level or add more instances as required.

How are customer service and support?

The learning resources and documentation provided by Microsoft are very helpful. There are many free learning segments and videos available to guide users through various aspects of Azure SQL Database.

How would you rate customer service and support?

Positive

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

I worked with SQL Server since version 6.5 in the late nineties and have continued to use it through various versions. I have also used other database platforms like ADB and MongoDB, but I prefer SQL Server due to its superior tools and features. I've used Cosmos DB for a few things, and we use Azure AI Search, a cognitive search pronounced by a different name. So use that, you know, Azure AI services. 

Azure SQL and Cosmos DB are our main solutions unless the client wants to use Oracle, Postgres, or MySQL. We will use whatever they want to use. On the analytics side, we use Fabric and One Lake, and we do the analytics of Power BI.

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

If we use a smaller or free-sized Microsoft Azure SQL Database, it is extremely cost-effective and much cheaper than on-premise enterprise licenses, which are expensive.

Which other solutions did I evaluate?

Other database solutions I have used include Cosmos DB for certain AI applications, as well as Oracle, Postgres, and MySQL when clients prefer those solutions.

I started working with SQL at SQL Server six point five in the late nineties. So, I mean, I went to SQL seven, two thousand, and then, you know, just been using it ever since. I've used other platforms, like I said, with ADB and, like, even with MongoDB and DevOps. It's just kinda my favorite one. I like the tools the best. Yeah. Seeking Server Management Studio is probably the best IDE out there for databases. All the other ones, are a little bit slow and clunky. Okay. So

What other advice do I have?

I would rate Microsoft Azure SQL Database a nine 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: My company has a business relationship with this vendor other than being a customer: MSP Partner
Flag as inappropriate
PeerSpot user
Buyer's Guide
Microsoft Azure SQL Database
December 2024
Learn what your peers think about Microsoft Azure SQL Database. Get advice and tips from experienced pros sharing their opinions. Updated: December 2024.
824,067 professionals have used our research since 2012.
Jason McCullagh - PeerSpot reviewer
Senior Director at a tech vendor with 501-1,000 employees
MSP
Reduced our total cost of ownership because we don't have to spin up an environment just to contain SQL
Pros and Cons
  • "Valuable features of Microsoft Azure SQL Database include its quick deployment capabilities, the ability to spin up an environment easily, and seamless integration with Microsoft products."
  • "Microsoft Azure SQL Database has significantly reduced our total cost of ownership by eliminating the need for a dedicated environment to host SQL."
  • "There needs to be a hybrid model for situations where not all customers want a cloud-based SQL solution."
  • "The latency and availability of Microsoft Azure SQL Database can be problematic when connecting to an instance in a geographically distant location."

What is our primary use case?

Our primary use case for Microsoft Azure SQL Database is storage configuration. We store all our connector configurations in the database, ensuring seamless operational integration.

How has it helped my organization?

Microsoft Azure SQL Database is easy to use and allows for rapid deployment.

While integrating the AI app with Azure SQL Database is a consideration, it's more for configurations. I believe the next steps should involve exploring search indices and technologies like Fabric.

This solution has had a certain impact on our organization. It has reduced our total cost of ownership because we don't have to spin up an environment just to contain SQL. All our databases now run in Azure, eliminating the need for on-premises instances.

Microsoft SQL Server seamlessly integrates with other Microsoft applications and is the central repository for all our connector configurations.

Microsoft Azure SQL Database has significantly reduced our total cost of ownership by eliminating the need for a dedicated environment to host SQL. Migrating all databases to Azure and removing on-premises instances has resulted in approximately a 70 percent reduction in TCO.

What is most valuable?

Valuable features of Microsoft Azure SQL Database include its quick deployment capabilities, the ability to spin up an environment easily, and seamless integration with Microsoft products. The transition to Azure SQL has certainly reduced our organization's total cost of ownership as it negates the need for on-premises infrastructure. The recent announcement about Copilot spinning up and creating SQL tables and stored procedures indicates the continuous improvement and added value it brings.

What needs improvement?

There needs to be a hybrid model for situations where not all customers want a cloud-based SQL solution. This model would facilitate transitions from on-premises instances to cloud-based versions.

For how long have I used the solution?

I have been using Microsoft Azure SQL Database for about 15 years.

What do I think about the stability of the solution?

The overall stability is good as it functions smoothly for our organization's needs.

The latency and availability of Microsoft Azure SQL Database can be problematic when connecting to an instance in a geographically distant location. For example, connecting from New York to an instance in Australia can result in network issues. Therefore, it is preferable to provision an instance local to the connection point to optimize performance and minimize latency.

What do I think about the scalability of the solution?

Microsoft Azure SQL Database allows easy scaling up and across without the need for physical infrastructure adjustments.

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

We did not switch from another solution because we are a Microsoft-oriented company and have seamlessly used Microsoft products for many years.

What was our ROI?

Azure SQL Database has helped reduce our total cost of ownership because we don't have to spin up an environment just to contain SQL.

What other advice do I have?

I would rate Microsoft Azure SQL Database as a solid eight out of ten due to the room left for improvement. Microsoft has potential areas for enhancement and always seeks growth.

The migration of our database to Microsoft Azure SQL proceeded smoothly without challenges. This strategic business decision to transition from on-premises to Azure SQL was proactively incorporated into our roadmap.

Which deployment model are you using for this solution?

Public Cloud

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

Microsoft Azure
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
Flag as inappropriate
PeerSpot user
Praveen Chaudhary - PeerSpot reviewer
Service Delivery Manager at a outsourcing company with 1,001-5,000 employees
MSP
Top 5Leaderboard
Flexible and user-friendly Azure solution empowers dynamic trading environments
Pros and Cons
  • "It's easy to use and maintain. If we look at the development of the maintenance team, we are not directly responsible for any infrastructure issues. We have too many positive sides to that. No maintenance, easy to use, and we'll know the limits very well."
  • "It's very difficult to investigate if something wrong is going on behind the scenes. If we are facing a problem that our application is doing a CPU spike and when we look at the dump of the details, the processes that our application is generating are not consuming more than 40-50% of CPU. But we don’t know where it is going, who's generating it, and who's consuming the CPU. Even Microsoft says they don’t know."

What is our primary use case?

While we have a trader client or warehouse management, we use SQL Azure because the volume of trading activity keeps changing. Maintaining on-premises solutions or infrastructure for this is difficult, as the user demand can fluctuate significantly throughout the month. For example, at the end of the month, there is a high volume of orders and data as traders push their orders to their incoming entries. This can cause the user demand to spike and then drop off again. Hence, we need a flexible infrastructure that can scale up and down to meet the changing demand.

What is most valuable?

It's easy to use and maintain. If we look at the development of the maintenance team, we are not directly responsible for any infrastructure issues. We have too many positive sides to that. No maintenance, easy to use, and we'll know the limits very well. So, users cannot come and say that these are the problems we are facing.

What needs improvement?

Mostly, it is the cost. Microsoft services are costly, which is the only problem we face. So, pricing is an area of improvement.

Another downside is that it's very difficult to investigate if something wrong is going on behind the scenes. If we are facing a problem that our application is doing a CPU spike and when we look at the dump of the details, the processes that our application is generating are not consuming more than 40-50% of CPU. But we don’t know where it is going, who's generating it, and who's consuming the CPU. Even Microsoft says they don’t know. They simply said we cannot give you the details. So, a bit of control over such processes or maybe analytics for it is something that needs improvement as well.

For how long have I used the solution?

In the last four or five years, a couple of clients have been more into Azure databases. So, depending on the client, we use this solution. 

How was the initial setup?

Installation is easy. It has been changed the way it is being done. Once you do that, it's okay.

What about the implementation team?

It is difficult to maintain it on-premises. If you are maintaining everything on your own, you need somebody who knows security. Everything comes into your bucket. So, you need to focus more on the infrastructure side and the maintenance of the application.

Which other solutions did I evaluate?

I've worked with clients who have multiple multifunction solutions, where some solutions use some technologies, and some use some.

What other advice do I have?

SQL Azure is very well maintained. Most of the services are good. If not the best, but they're good—no such complaints.

Overall, I would rate SQL Azure a nine out of ten.

Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
PeerSpot user
reviewer2596431 - PeerSpot reviewer
Software Engineer at a financial services firm with 51-200 employees
Real User
Has greatly improved maintainability by eliminating the need to manage on-premises SQL servers
Pros and Cons
  • "The ease of scaling the server up and down by simply pressing a few buttons in a dropdown menu has made our lives significantly more comfortable, especially as we aim to process more data this year by utilizing the cloud."
  • "We've noticed an unexpected increase in the cost of running the server over the past few months."

What is our primary use case?

We use it primarily as a data warehouse. We receive a lot of data from external vendors, and our goal is to consolidate all the information. Using data from various sources, we generate reports to support internal teams in the organization, mainly for operational tasks.

How has it helped my organization?

Microsoft Azure SQL Database has greatly improved maintainability by eliminating the need to manage on-premises SQL servers. The ease of scaling the server up and down by simply pressing a few buttons in a dropdown menu has made our lives significantly more comfortable, especially as we aim to process more data this year by utilizing the cloud.

It has helped to reduce our organization's total cost of ownership when it comes to our IT team who don't spend as much money on hardware, cooling, monitoring temperatures, and tasks like that. I know that IT people don't have to come into the office on weekends to make upgrades, do maintenance, or if there are alerts, and tasks like that.

What is most valuable?

It is easy to use. We interface with it using SQL Server Management Studio, which only requires a change in connection, so the interface remains consistent. This simplicity in usability, along with improved organizational productivity where we no longer need to maintain on-premises SQL servers, is invaluable. Scaling up and down the server with ease is a significant benefit, particularly as we aim to handle an increased data workload this year. Additionally, the integration of multiple services within Azure simplifies our operations. 

My company is in the early stages of exploring its ability to power next-generation AI applications. We've tried AI Studio. It's a little too data science-y for what our team does. Trying to connect our data with AI has a high learning curve.

It's been really easy to integrate with other Microsoft applications. We're currently in the middle of migrating a bunch of ETL packages and processes to Azure Data Factory. Everything living in Azure makes it really easy. 

Maintainability has increased a lot. We don't have to maintain the on-prem SQL Server because we don't have to maintain anything anymore. Maintainability has increased a lot in terms of the amount of time needed to do that. It's been really nice being able to scale the server up and down. It's made our lives a lot easier, especially since we're trying to ingest much more data this year.

What needs improvement?

We're trying to manage our costs better. We've noticed an unexpected increase in the cost of running the server over the past few months. Addressing pricing clarity and alignment would help us. Also, incorporating AI functionalities like Copilot into SQL Server Management Studio could enhance productivity by assisting with query writing and troubleshooting.

For how long have I used the solution?

Professionally, I have been using SQL for about five years. At my company, we used on-premises databases for a long time, and in January of this year, we migrated to Microsoft Azure SQL Database. We have been running it for eleven months now.

What do I think about the stability of the solution?

So far, there have been no issues reported with latency and availability.

What do I think about the scalability of the solution?

The experience has been positive. It is easy to scale up when needed and scale back down if required.

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

We used on-premises SQL servers. The switch to Microsoft Azure SQL Database was influenced by the elimination of maintenance required for on-premises systems and the desire to manage all technologies under one umbrella within Azure, considering our existing cloud footprint.

How was the initial setup?

The initial setup was straightforward. It involved changing the connection string within SQL Server Management Studio, maintaining consistency in interfacing.

The team that migrated struggled with replication in the very beginning where replicating our database for redundancy seemed like it was over replicating. The amount of storage that it was taking up was four to five x our actual database size. We had to increase the capacity of it and that increased cost for a little bit until we shut down the replication. 

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

The price for running the server increased more than expected in recent months, and better alignment of pricing expectations is needed. Notably, costs related to IT staff coming into the office on weekends or monitoring hardware have presumably decreased.

Which other solutions did I evaluate?

During our evaluation, pricing was a key consideration, and Microsoft Azure's pricing model was more appealing compared to other competitors. The extensive cloud footprint we already had in Azure contributed to our choice.

What other advice do I have?

On a scale from one to ten, I rate the overall product an eight.

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
Principle Architect at Siemens Industry
Real User
Significantly reduces our operational overhead, freeing us from backup worries and allowing us to focus on other priorities
Pros and Cons
  • "Provisioning the instance, connecting to it, and deploying full-stack applications end-to-end on Azure is much easier than AWS."
  • "Microsoft's expertise in SQL Server is a significant advantage."
  • "The managed SQL MI does not allow us to control the zone it runs in, which affects latency."
  • "We need improvement in the latency between availability zones. The managed SQL MI does not allow us to control the zone it runs in, which affects latency."

What is our primary use case?

Our primary use case for Microsoft Azure SQL Database is to bring up our products and run them on Azure as we have our own TCX products. We have been using AWS in the back end, but we are now expanding to Microsoft Azure.

How has it helped my organization?

The native SQL runs great on Microsoft, and the integration with Microsoft applications like Office makes it seamless.

Microsoft Azure SQL Database significantly reduces our operational overhead, freeing us from backup worries and allowing us to focus on other priorities. Additionally, SQL Managed Instance provides clear usage visibility and enables on-demand scaling to meet our evolving needs.

Microsoft Azure SQL Database is our go-to database for our products, such as SQL or Oracle. The usability, ease of use, and fine-tuning are beneficial, especially for our IO-intensive application. It empowers us by running our availability through the product side.

What is most valuable?

Provisioning the instance, connecting to it, and deploying full-stack applications end-to-end on Azure is much easier than AWS

Azure SQL provides built-in security and useful troubleshooting tools for identifying and taking action whenever issues arise.

What needs improvement?

We need improvement in the latency between availability zones. The managed SQL MI does not allow us to control the zone it runs in, which affects latency. It's crucial for us that customers should not be concerned about which availability zone it's running as long as the response time and latency are consistent.

For how long have I used the solution?

I've been using Microsoft Azure SQL Database for approximately three months.

What do I think about the stability of the solution?

We experience some latency issues.

What do I think about the scalability of the solution?

We are working on a scalability performance test for SQL MI and comparing it with AWS.

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

We are expanding our cloud infrastructure from AWS to include Microsoft Azure. Azure's managed database services eliminate the operational overhead of running our own database, allowing us to quickly deploy and connect to pre-configured instances without manual tuning or backups.

How was the initial setup?

The setup is straightforward, being a managed service, so operational overhead is minimized.

What was our ROI?

We anticipate seeing savings as we start using Microsoft Azure SQL more extensively.

What other advice do I have?

I would rate Microsoft Azure SQL Database eight out of ten. Our experience has been good overall, except for the latency issue. If latency issues are resolved in future releases, I would rate it higher.

Microsoft's expertise in SQL Server is a significant advantage. Their resources are beneficial, and a primary reason for choosing SQL MI is the reduced operational overhead. By eliminating the need for a dedicated database administration team, we can avoid the costs and complexities associated with managing and distributing the database. This is a crucial factor in our decision-making process.

We use nearly all of Azure's services, including virtual machines, application gateways, firewalls, load balancers, and SQL Managed Instances. Our projects involve a comprehensive engagement with the Azure platform.

Which deployment model are you using for this solution?

Hybrid Cloud

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

Microsoft Azure
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
Flag as inappropriate
PeerSpot user
reviewer2595918 - PeerSpot reviewer
Head of Data and AI at a financial services firm with 501-1,000 employees
Real User
It's easy to use and feels similar to on-premise systems
Pros and Cons
  • "Shifting our corporate programs to the cloud is more or less the same due to the ease of implementation. We've cut costs by around 70 percent."
  • "We've cut costs by around 70 percent."
  • "One area for improvement is setting up logs, especially for servers like VM SQL. It was also tricky to connect services on VNets to on-premise."
  • "One area for improvement is setting up logs, especially for servers like VM SQL. It was also tricky to connect services on VNets to on-premise."

What is our primary use case?

Our primary use cases are logging for behavioral analysis similar to Google Analytics and transaction logging for our web pages for customers.

How has it helped my organization?

We use Azure Hybrid Benefit because we're a legacy company, and we have a SQL database from many years ago. We are migrating some databases to the cloud have seen a nice reduction in costs using this hybrid benefit. Shifting our corporate programs to the cloud is more or less the same due to the ease of implementation. We've cut costs by around 70 percent. 

What is most valuable?

Azure SQL is easy and feels similar to on-premise systems. The cloud solution is effortless to set up.

What needs improvement?

One area for improvement is setting up logs, especially for servers like VM SQL. It was also tricky to connect services on VNets to on-premise. We also had difficulty integrating some Azure resources. For example, app services in Azure Kubernetes may be difficult to integrate if these servers are on a VNet.  Semantic search or vector search should be enabled by default.

For how long have I used the solution?

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

What do I think about the stability of the solution?

Azure SQL's latency was amazing with local data storage, but we had challenges using external tables in packets and delta tables. We're facing some high latencies, about one or five seconds for small packets delta tables. This could be improved.

What do I think about the scalability of the solution?

We haven't utilized workloads for Azure SQL Database's scalability. We employ stored procedures for processing alongside database externals, making scalability less tested on our end.

How are customer service and support?

The Microsoft support plan has a one-hour SLA, which was crucial in our decision-making process regarding database options.

How would you rate customer service and support?

Positive

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

We previously used VM SQL and have SQL Managed Instance now. We are not using Azure SQL database to power AI applications. We use NetGood Database SQL 2025 to search.

How was the initial setup?

We had to migrate some legacy SQL databases to the cloud. The process went smoothly.

What was our ROI?

We reduced our TCO using Azure SQL.

What other advice do I have?

I would rate Microsoft Azure SQL Database eight out of 10. If VNet integration was improved, I would rate it higher. The integration with VNets was a critical issue.

Which deployment model are you using for this solution?

Hybrid Cloud

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

Microsoft Azure
Disclosure: My company has a business relationship with this vendor other than being a customer: Enterprise agreement
Flag as inappropriate
PeerSpot user
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.

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