Azure SQL Database

(10)
4.2 out of 5 stars

Azure SQL Database is a relational database-as-a service using the Microsoft SQL Server Engine. SQL Database is a high-performance, reliable, and secure database you can use to build data-driven applications and websites in the programming language of your choice, without needing to manage infrastructure.

Work for Azure SQL Database?
Informixenterpriseedition 2x

Learning about Azure SQL Database?

We can help you find the solution that fits you best.

Azure SQL Database Reviews

Write a Review
Filter Reviews
Filter Reviews
  • Ratings
  • Company Size
  • User Role
  • User Industry
Ratings
Company Size
User Role
User Industry
Showing 10 Azure SQL Database reviews
LinkedIn Connections
Azure SQL Database review by <span>Leonid K.</span>
Leonid K.
Validated Reviewer
Verified Current User
Invitation from G2 Crowd
Reviewed On

Simple database for simple applications

What do you like best?

Azure SQL provides all necessary tools for Azure WebApps. It is using TSQL language and easy to learn for SQL Server DBAs. It can be scaled and has very interesting High-Availability and disaster recovery functionality. It looks more secure than SQL Server, because it using firewall for access management, It can be managed from Azure portal or SSMS, or using the new SQL Operations Studio tool. It can be tuned automatically and provides some performance insights, so you are able to see the bottlenecks in your deployment quickly and fix these before it comes to issue. It is integrated with Azure monitoring solutions, to see the issues and performance in real-time.

What do you dislike?

Applications could not be migrated from on-premises to Azure SQL without adjusting the code. Azure SQL does not provides backwards compatibility with SQL Server. Some useful functionality like in-Memory OLTP is missing there, so you could only rely on CPU and Storage performance. It also blocks you from using large enterprise scale databases in Azure.

Recommendations to others considering the product

If you are trying to move your application from on-prem, this is not for you

What business problems are you solving with the product? What benefits have you realized?

Using this for simple WebApps

Sign in to G2 Crowd to see what your connections have to say about Azure SQL Database
Headshots
Azure SQL Database review by <span>Anton S.</span>
Anton S.
Validated Reviewer
Verified Current User
Invitation from G2 Crowd
Reviewed On

Modern database solution in Azure

What do you like best?

Azure SQL database is the first step in cloud data platform, allows you using functionality similar to SQL Server in conjunction with modern technologies and features. Database is provided as PaaS, so you don`t have to manage it`s host or perform any system administration. Database using new features of cloud deployment, like automated tuning and performance insights, which allows you to reduce administrative efforts and follow best practices of cloud location. High Availability and disaster recovery features allows replication of database to another region and perform failover in case of Azure location outage. New security functions like firewall rules and virtual network integration allows to restrict access to only locations specified by you, but not make additional problems for your applications connected to these databases. Implementation of elastic pools for several databases will allow you to manage resources needed for every database without additional costs. Different pricing tiers will allow you to pick eactly what you need at current stage of work on your application. You can always increase resources when it will be needed and application will go live. You can configure auto=scaling so database will have more resources in case of increased load, and don`t consume much when it is idle.

What do you dislike?

Azure SQL database is not SQL Server, it just looks similar and have partially common functionality, in most cases you will have to adjust the code of your applications to have it working with Azure SQL database

Recommendations to others considering the product

If you are looking for more close approach to SQL Server, you might need to wait for SQL Database Managed Instance to go in public preview. It is much more close to SQL Server and probably will allow to leave your code is it is in more cases.

What business problems are you solving with the product? What benefits have you realized?

RDBMS solution for webapps

What Relational Databases solution do you use?

Thanks for letting us know!
Azure SQL Database review by <span>Michael T.</span>
Michael T.
Validated Reviewer
Verified Current User
Invitation from G2 Crowd
Reviewed On

Great database solution for Azure Web Applications

What do you like best?

Azure SQL Database works perfectly in pair with Azure WebApps, being provisioned as a PaaS solution it does not need to manage the server running it, so you just need database administration. It is very easy to deploy and connect for your application, at the same time it is very secure, access is being managed by firewall rules, virtual network integration and native SQL Server user access tools. Azure SQL has a number of additional tools for administration, like performance advisor which analyzing performance of queries running across the database and provides recommendations to increase it. Azure SQL Server also allows automatic tuning, like creation of missed indexes or dropping unused ones. Implementation of elastic pools allows you to share resources between several databases, so each database will have enough resources to run queries and don`t consume addition costs being idle. New query editor function, which is currently in preview, allows you to run queries directly from Azure portal. Great high-availability and disaster recovery options, allows you to ensure that database will remain online even in case of disaster.

What do you dislike?

Unfortunately Azure SQL has not the same set of features of on-premise SQL Server, that means that applications will need rewriting the code to adopt this.

Recommendations to others considering the product

You apps could not be easily migrated from on-premise to PaaS solution. As an option you could use regular SQL Server deployed on Azure VM, it will also provide some cool benefits of cloud location

What business problems are you solving with the product? What benefits have you realized?

PaaS Database service for Azure web application

Azure SQL Database review by <span>Donald H.</span>
Donald H.
Validated Reviewer
Verified Current User
Invitation from G2 Crowd
Reviewed On

Moved from bare metal to the clouds

What do you like best?

The best thing is not having to manage an actual server or database installation. No more patch Tuesdays to worry about or service pack updates.

Need another copy of that database to test with? Go to the portal and create a copy. You can even create shared resources so as to not incur extra costs.

Want to automate spin up & tear down? Easy peasy with PowerShell.

What do you dislike?

There are times when we've kicked off something that took a while to complete. It was hard to get insight into the progress of that task.

The other part I dislike is support. It can be tough to get support on the product when something goes wrong.

What business problems are you solving with the product? What benefits have you realized?

Lower costs and no more physical servers to manage.

Azure SQL Database review by <span>Timur Z.</span>
Timur Z.
Validated Reviewer
Invitation from G2 Crowd
Reviewed On

Failed to go-live with it

What do you like best?

The idea itself is perfect. Database as a service without managing it`s infrastructure. I beleive in future releases it will grow to something more suitable for complex workloads. Great resource management, elasticity and scaling options. Much better than Amazon RDS. Very secure solution. Perfectly works for simple web applications processing sensitive data

What do you dislike?

Functionality is still not enough for complex applications, we failed to go-live with it and had to deploy on-premise version of SQL Server on Azure virtual machine

Recommendations to others considering the product

Don`t try to connect it with applications that requires in-Memory OLTP or complex analytics

What business problems are you solving with the product? What benefits have you realized?

Data platform for web aplications

Azure SQL Database review by <span>Ivan R.</span>
Ivan R.
Validated Reviewer
Invitation from G2 Crowd
Reviewed On

Good solution as a database for you Azure Web Apps

What do you like best?

Azure SQL is very easy to deploy, security is perfect, access is managed by users and firewall rules, so you can control IP adresses from which database could be accessed

What do you dislike?

Limited functionality in comparision with on-premise SQL Server

Recommendations to others considering the product

Great solution for not very complex applications, if you need advanced features you`d better deploy on-premise version of SQL Server on Azure virtual machine

What business problems are you solving with the product? What benefits have you realized?

Allows developers to build both web-apps and databases in the same cloud location

Kate avatar
Kate from G2 Crowd

Learning about Azure SQL Database?

I can help.
* We monitor all Azure SQL Database reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. Validated reviews require the user to submit a screenshot of the product containing their user ID, in order to verify a user is an actual user of the product.