TrustRadius: an HG Insights company

Azure SQL Database

Score8.9 out of 10

279 Reviews and Ratings

Get a Demo

What is Azure SQL Database?

Azure SQL Database is Microsoft's relational database as a service (DBaaS).

Categories & Use Cases

Key Features

Learn about the best (and worst!) features Azure SQL Database has to offer, as determined by TrustRadius' reviewers.
Based on 279 ratings of Azure SQL Database's features
View all features

Top Performing Features

  • Automated backups

    Automated backup enabling point-in-time data recovery

    Category average: 8.3

  • Automatic host deployment

    Compute instance replacement in the event of hardware failure

    Category average: 7.4

  • Automatic software patching

    Patches applied to database automatically

    Category average: 8.7

Areas for Improvement

  • Database scalability

    Ease of scaling compute or memory resources and storage up or down

    Category average: 9

  • Database security provisions

    Provision for database encryption, network isolation, and identity access management

    Category average: 8.8

  • Monitoring and metrics

    Built-in monitoring of multiple operational metrics

    Category average: 6.7

Reviews

What users are saying about Azure SQL Database.
View all reviews

Azure SQL Database is truely a step forward

Oliver MichelsView profile
DevOps Principal in Information Technology at Bechtle (10,001+ employees employees)

Use Cases and Deployment Scope

Azure SQL Database is a big step forward for us, as we no longer need to patch the database server or patch the operating system. It's a truely SQL-as-a-Service which allows dynamic up- and down scaling of the server. Gone are the tedious tasks to configure the DB, even Recovery is pre-configured.

Pros

  • Up- and Downscaling
  • Setup
  • Backup and Recovery

Cons

  • A SQL-Worksheet Tool in Azure Portal would be really nice

Return on Investment

  • RoI is great

Usability

Alternatives Considered

Oracle Database and MySQL

Other Software Used

MySQL

Best In Class Database

Incentivized
Muddassar InayatView profile
IT Solutions Consultant in Information Technology at Gulf Commercial Group (501-1000 employees employees)

Use Cases and Deployment Scope

Currently, we are using it for Microsoft PowerApps Business Applications and we prepared all the data models for Azure SQL Database. Its interface is easy to use and within less time we can create databases, add tables and prepare views, and immediately those databases are available for other applications which are already on the cloud.

Pros

  • Available all the time.
  • Robust database.
  • All apps easily connect with it.
  • Easy to create data models.
  • Easy management.

Cons

  • Table creation and addition of new columns.
  • Add more datatypes.

Return on Investment

  • Time saving.
  • Easy connect.
  • Spending less time to managed it.
  • Easy interface for developers.
  • Developer are available widely to work on SQL.

Alternatives Considered

frevvo

Other Software Used

PowerApps, Microsoft Teams, Microsoft Windows

Cloud-based relational database service that is both intelligent and scalable.

Incentivized
Niloofar Keshvari NiaView profile
IT Operations and Support Specialist in Information Technology at AZEREX LLC. (1-10 employees employees)

Pros

  • With managed SQL in the cloud, you can build applications tailored to your business needs.
  • Rapidly adaptable server less cloud computing and hyper-scale storage.

Cons

  • Define smart plans to determine the price according to the needs and type of each business so that startups and small companies can benefit from it better.
  • Develop more user-friendly UI wizard for migration SQL server

Return on Investment

  • There is no need to change the codes during the migration to SQL and the cost of hiring a developer is saved
  • At peak usage and workload, when resources are intelligently managed, there is no need to pay extra.

Alternatives Considered

Couchbase and Amazon Relational Database Service (RDS)

Other Software Used

Microsoft Azure, Microsoft Access, Microsoft 365 Business Premium

Microsoft Azure SQL Database - Good Value - Great Features!

Incentivized
Scott KennedyView profile
Director, eCommerce Analytics and Digital Marketing in Marketing at Franklin Sports (201-500 employees employees)

Pros

  • Azure SQL Database does a really nice job connection to the Power BI business intelligence service without the need for a data gateway for report refreshes.
  • Azure SQL Database has a very easy upgrade path from a database to a data warehouse.
  • Azure SQL Database has a simple billing structure.

Cons

  • The Azure platform can be a little confusing sometimes with all the different options. Such is the Microsoft way.
  • If you forget to put rate limits on your jobs, it's possible that your cost could explode.
  • Learning the new Azure data tools to replace SSIS takes a while.

Return on Investment

  • Our database costs have decreased over time by 20%.
  • Our engineer spends much less time managing API calls with some of the new features available.
  • Our engineer is planning on using the Power Query embedded feature to streamline some ETL processes.

Alternatives Considered

Microsoft SQL Server

Other Software Used

Microsoft Power BI, Microsoft Teams, Airtable

Microsoft Azure SQL Database: Fully Managed and secure SQL database

Incentivized
Rishabh KhannaView profile
Software Engineer in Information Technology at MothersonSumi INfotech & Designs Ltd. (MIND) (501-1000 employees employees)

Pros

  • It is fully managed and secure SQL database.
  • It is highly available and scalable.
  • It provides automatic backup and restore.
  • Documentation of Azure SQL is perfect with all best practices.

Cons

  • I would love to see some new sizes of databases for compute and storage.
  • prices related to different size can be improved.
  • performance can be improved to reduce the latency.

Return on Investment

  • It was easy for our developers to setup and use this service.
  • It has helped us in reducing the cost of managing SQL database.
  • Its ability to scale up and down based on requirement is best.

Alternatives Considered

Amazon Relational Database Service (RDS), Microsoft SQL Server and Google Cloud SQL

Other Software Used

Amazon Relational Database Service (RDS), Google Cloud SQL, Microsoft SQL Server