Azure SQL Database Reviews

146 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.3 out of 100

Do you work for this company? Manage this listing

Overall Rating

Reviewer's Company Size

Last Updated

By Topic

Industry

Department

Experience

Job Type

Role

Filtered By:

Reviews (1-19 of 19)

Anonymous | TrustRadius Reviewer
February 26, 2020

My Azure SQL Database Review

Score 10 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Handling the software updates so we don't have to.
  • Handling the availability so we don't have to.
  • There are limits to the size of the database that I'd like to see go away.
  • We don't have access to the server level counters that I miss but understand why we cannot get them.
Read this authenticated review
Arthur Zubarev | TrustRadius Reviewer
October 05, 2019

Azure SQL Database - Good Now, Getting Even Better

Score 8 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Scalability is #1: if it used to be an almost no-win endeavour to try to modernize your server or migrate to other hardware, with Azure SQL Database it becomes a press of a button.
  • All the tools simply work after you are on Azure SQL Database.
  • The applications do not need changes in order to start using Azure SQL Database.
  • Hybrid Cloud scenarios will work.
  • Clustering and failover - already there.
  • You can start monitoring the use and extract performance insights in a new way in Azure.
  • One needs to be aware that some T-SQL features are simply not available.
  • The programmatic access to server, trace flags, hardware from within Azure SQL Database is taken away (for a good reason).
  • No SQL Agent so your jobs need to be orchestrated differently.
  • The maximum concurrent logins maybe an unexpected problem.
  • Sudden disconnects.
  • The developers and admin must study the capacity and tier usage limits https://docs.microsoft.com/en-us/azure/azure-subscription-service-limits otherwise some errors or even transaction aborts never seen before can occur.
  • Only one Latin Collation choice.
  • There is no way to debug T-SQL ( a big drawback in my point of view).
Read Arthur Zubarev's full review
İhsan Akkarpuz | TrustRadius Reviewer
December 03, 2019

Secure Product Providing High-Performance

Score 9 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Easy implementation thanks to the team working on the product launch.
  • Set up features available are flawless.
  • Very well suited to our needs. We are a company with more than 3k+ white collar employees.
  • Data management and transfer is so secure, we feel there is no possibility for information theft from external sources.
  • There might be room for improvement in visual interface. Some of my colleagues complain about basic operations could be carried out more easily, like administering other users.
  • Set-up speed could be faster - currently it took around 10 min.
Read İhsan Akkarpuz's full review
Anonymous | TrustRadius Reviewer
November 19, 2019

Azure SQL - your solution for Agility and Scalability

Score 8 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • It's extremely agile in that you can add/reduce resources as necessary for your organizations needs with minimal down time or cost.
  • Zero need for on site software or servers to manage.
  • ETL processing is vastly improved running through the cloud.
  • Could perform better in accessing large data volumes.
  • Due to varying price structures, evaluation for your specific needs can be cumbersome.
  • Better system for notification/logging of DB errors.
Read this authenticated review
Anonymous | TrustRadius Reviewer
August 09, 2019

Easy decision, good price.

Score 9 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Control of access and security is easy to manage and share within our team. Response is quick and quite a bit of things are preloaded to help.
  • Having the SQL component reside directly within our subscription makes connecting and managing very easy and highly transparent. Added spots for notes on things like why an IP is whitelisted is very helpful when working with a large team that includes off-shore components.
  • Scalability is another bonus, easy to scale up or down during peak times, and even automate that function makes it almost competitive with something like Snowflake.
  • A little slow on processing complex or large Views. We use a lot of Views to feed our BI system, and the processing time could see some improvement, IMHO.
  • Additional monitoring components would be nice too, automating some built in performance measurement tools would be a nice feature.
  • Price can always be improved as well. It’s not bad, but room for improvement.
Read this authenticated review
Jacob Biguvu | TrustRadius Reviewer
July 01, 2019

Azure SQL database makes ease the transition to Cloud

Score 9 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Azure SQL database is low-cost option for development and production workloads.
  • Azure is a fully-managed SQL database. This falls into the industry category of PaaS (Platform-as-a-Service) and DBaaS (Database-as-a-Service) where the software and hardware that is hosted, maintenance is owned by Microsoft. This allows users to concentrate fully on database management and administration.
  • Azure SQL database offers a variety of deployment options such as you can have a single database with its own set of resources managed via a SQL database server. A single database is similar to a contained database in SQL Server. Other options to leverage are an elastic pool and managed instances.
  • Azure provided a deployment option with a feature "elastic pool" - where you can have a collection of databases with a shared set of resources managed via SQL database server. Easily the resources from the pool can be managed among the databases. This brings more performance and cost effective when the user want to manage the multi-tenant applications.
  • Azure provided another deployment option that is "SQL database managed instances" with absence of certain features comparing to the single SQL database.
  • In AWS, we have RDS concept - where servers are invisible and have only database access. The same concept can be seen in Azure but we don't need to see the servers. When Azure SQL Database is DBaaS and PaaS, no need to have access to the SQL Server of the database.
  • It would be great to provide administration related procedures or functions to analyze the performance and maintenance tasks.
Read Jacob Biguvu's full review
Michael Jipping | TrustRadius Reviewer
January 14, 2019

Azure SQL Databases is quick to scale

Score 10 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Extremely Flexible- You have the ability to increase and decrease the performance resources as needed without taking a downtime or other burden.
  • Connectivity- Connection to your SQL Database is easily accomplished with SSMS or PowerShell.
  • Speed- Azure SQL Databases are quickly set up. You can have access and begin using your database within minutes.
  • It would be appreciated for better integration between SSMS and Azure Database service. Example, you need to a provision user account with the Azure portal. It would be great to be able to do this within SSMS.
  • Being able to run a back from SSMS versus from within the Azure Portal would be great. (Ability to create a standard .bak database backup).
Read Michael Jipping's full review
Duncan Hernandez | TrustRadius Reviewer
November 15, 2018

Great answer for scalability!

Score 8 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • No more internal servers is a big plus.
  • Transition was relatively easy since we came from another Microsoft database before.
  • Query running time has significantly improved
  • Some of our older SSIS packages and SQL server jobs needed to be upgraded before a transition to Azure.
Read Duncan Hernandez's full review
Erik Ralston | TrustRadius Reviewer
November 06, 2018

Azure SQL Database: The Best PaaS offering for SQL Server

Score 10 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Providing a SQL Server instance at low entry-level cost and global high-availability
  • Elastic offerings so SaaS applications can cheaply have one-database-per-customer approach for high data segregation
  • Intelligence performance recommendations from both Azure and the SQL Server engine itself
  • Intelligent recommendations are not a silver bullet, since they often fail to detect opportunities that are obvious to a human database admin with any experience.
  • Certain advanced database features - most recently I found: column store indices - are locked behind pricing tiers that one would naively assume are just about performance.
Read Erik Ralston's full review
Atul Gupta | TrustRadius Reviewer
December 21, 2018

Azure Sql rocks

Score 10 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Agility of the platform
  • No infrastructure maintenance and worry about upgrading, it's managed.
  • Always on and universal availabilities
  • No worry about backup recovery
  • PowerBI connectors need improvement across 365 platform
  • Data bricks can be inherent feature
  • More robust integration to flow
Read Atul Gupta's full review
Anonymous | TrustRadius Reviewer
August 10, 2018

Intro to Azure SQL DB

Score 7 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • High availability
  • Security features
  • Ease of upgrade from on premise SQL
  • Lacks full feature parity with SQL server
  • More limited access to metrics for performance troubleshooting
  • Hard to understand metrics used for sizing
Read this authenticated review
Rick Hahn | TrustRadius Reviewer
March 13, 2018

The Hidden Savings of Using Azure

Score 10 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • The fact that it is available for the Azure cloud platform.
  • The fact that it is easy to license as a monthly subscription and software access is simple.
  • The fact that it functions exactly as its local server based counter part.
  • It appears to have a slight delay in revealing data in the client software, then data will appear almost instantly. It is an odd feel when using it until you get used to it.
  • It seems a bit slower than its local server based counter part.
  • The tool bars icons are a little different and took some getting used to.
Read Rick Hahn's full review
Simranjeet Singh | TrustRadius Reviewer
March 02, 2018

Easy to maintain large and complex data

Score 9 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • It is best to store large scale data. We can connect with it in any language.
  • Interface is very easy and the debugging feature is really effective at discovering real errors.
  • Speed of processing large files and store into database is very fast. Data export and import is very safe and simple.
  • Login security features protect against unauthorized users.
  • Overall it is the best tool to mange large and complex data, but it needs enhancements in the speed of accessing large data volumes.
  • Sometimes it get hung if we forcefully stop the select query.
  • It should show consistent performance through SQL profiler tool.
Read Simranjeet Singh's full review
Zimran Azim | TrustRadius Reviewer
July 27, 2016

Azure "The Best to catch a breath for your self"

Score 8 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • The great thing about is even you are a pro or a newbie with Azure, you will not be tired of setting up SQL Server, the befitting pipelining of AZURE to cloud service where you don't need it onsite.
  • You always don't need to update services, patches and deployment of supporting services. Cloud does make it someone else's job to do this.
  • Generally obviates the need for building high availability architectures; Azure databases built within it are automatically highly available.
  • Highly scalable and has vast support for non Microsoft technologies.
  • One of the ways SQL Azure manifests being part of the whole stack is by offering multiple levels of implementation. If you simply need a website and a database, you can hitch an SQL Azure instance to an Azure website and be done with it.
  • No schedulers available in case you require cron jobs.
  • Certain username are not allowed (root, admin, administrator).
Read Zimran Azim's full review
Tom Jaskula | TrustRadius Reviewer
February 24, 2016

Azure SQL Database - a modern cloud solution

Score 9 out of 10
Vetted Review
Review Source

Pros and Cons

  • The newest SQL Server features and functions are pushed to the service, so unlike onsite SQL there is never a need for upgrading.
  • Azure SQL database does not require onsite infrastructure.
  • Because this is a cloud solution, you will never need to patch the Operation System, install a service pack, or install an update.
  • Unlike onsite databases, scaling up or scaling down is very easy with Azure SQL database.
  • Azure SQL database does not contain the SQL Agent service, so if jobs needs to be scheduled you still need to do this using a traditional SQL Server.
  • Given that there are 10 different pricing options, It can be difficult to determine which one to select.
Read Tom Jaskula's full review
Anonymous | TrustRadius Reviewer
August 07, 2018

Azure SQL DB is an example of how a DBaaS should be done.

Score 9 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • It optimizes cost - pay per usage. It can scale up and down as needed.
  • It can be migrated to from Oracle, MySQL and other on premises databases.
  • It is always updated with management and administrative functionalities being added weekly.
  • Migration from on premises databases can be painful at first - but after couple of migrations it becomes easy.
  • Network capabilities and restrictions should be carefully evaluated.
  • It can be costly if you don't implement scale up/down automations.
Read this authenticated review
Anonymous | TrustRadius Reviewer
August 24, 2017

Reviewing Azure SQL Database

Score 9 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Marketing automation and tracking
  • SharePoint servers
  • General Business Intelligence
  • For what I use it for I haven't come across much
  • User interface could be improved
  • Navigation could be simplified
Read this authenticated review
Anonymous | TrustRadius Reviewer
November 17, 2015

Azure SQL - Making Life Easier

Score 10 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Point In Time Backup
  • High Availability
  • Scaling
  • Provide customers more examples with Azure Automation (ways of doing backups, etc.) and then emailing when there is a failure.
  • Decrease costs on premium.
  • Allow customers to define a longer point in time backup recovery period.
Read this authenticated review

Feature Scorecard Summary

Automatic software patching (18)
9.1
Database scalability (19)
9.4
Automated backups (19)
9.1
Database security provisions (19)
9.3
Monitoring and metrics (18)
8.3
Automatic host deployment (15)
9.0

About Azure SQL Database

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

Azure SQL Database Integrations

Azure SQL Database Technical Details

Operating Systems: Unspecified
Mobile Application:No