TrustRadius Insights for Azure SQL Database are summaries of user sentiment data from TrustRadius reviews and, when necessary, third party data sources.
Pros
Reliability and Accessibility: Users consistently praise Azure SQL Database for its constant availability, emphasizing its reliability and ease of access. They find it reassuring that the platform is always accessible when needed, ensuring uninterrupted workflow and data access.
Ease of Use: Reviewers commonly highlight the simplicity in creating data models and managing databases with Azure SQL, making these tasks straightforward and user-friendly. This ease of use streamlines their workflow, simplifies database management processes, and allows them to focus on more critical aspects of their work.
Integration Capabilities: Many users appreciate how easily all their applications connect with Azure SQL Database, enhancing usability and integration possibilities. This seamless integration allows for efficient collaboration between different tools within their ecosystem, promoting a cohesive working environment.
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.
Likelihood to Recommend
It is best used for the Dot Net based and cloud-based applications where the user needs to connect with it immediately to start using with it.
The Azure SQL Database service offers premium performance and durability, powered by AI. It takes advantage of server less computing and hyperscale storage resources that free you from infrastructure management task. It solves the concern of space constraints and records with cloud flexibility. Speed, security along with other useful and practical features have made it one of the best options. Azure SQL Database server-less used by the executive projects development department and many of the company's clients in the financial and civil sector.
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
Likelihood to Recommend
Your upcoming app can be built faster on a fully managed SQL database and can be moved into Azure with a few to no application code changes. Flexible and responsive server less computing and Hyperscale storage can cope with your changing requirements and one of the main benefits is the reduction in costs, which is noticeable.
We have an online application that is used by most employees, this online application depends on several SQL Databases for storing and accessing information, we needed a [cloud-based] DBaaS service to host the databases of the solution and provide a cost-effective way of scaling up and down based on our application usage since after hours the utilization is incredibly low, Azure SQL did the job quite nicely with the auto-scale capability and helped reduce the costs and optimize the performance.
Pros
An excellent option for cloud-based database hosting
Great if you already have on-premises SQL Databases that you want to migrate to the cloud
Cost-effective solution for cloud DB hosting with great scaling capabilities
Cons
Although it's a great option for migrating on-premises SQL DBs, it lacks some of the features of the on-premises SQL Server Instances
Server Collation is limited to SQL_Latin1_General_CP1_CI_AS
Logs support only [the] Full Recovery Model, which doesn't scale well for databases that contain logs/audit trail, or databases that contain engine jobs such as HangFire DBs
Doesn't Support CLR, so certain on-premises databases with CLR are not compatible, so you are most likely left with the AzureSQL Managed Instance for this functionality
Likelihood to Recommend
Azure SQL is great for migrating already on-premises SQL Databases considering the compatibilities between the two, however, some limitations can interrupt the migrations and require some structure/schema changes to the database which can be [time-consuming]. Overall, if you are building your solution from scratch, and prefer to use [...] familiar technology, Azure SQL is a great option, that is secure, flexible[,] and scalable, however, if you are migrating from on-premises, the decision to use Azure SQL Database depends on how compatible your current database is with it and whether its features are sufficient for your requirements or not. It is a recommended solution though, and a very [cost-effective] one indeed!
VU
Verified User
C-Level Executive in Information Technology (Information Technology & Services company, 201-500 employees)
It is used in firm-wide operations via RDP to enter data into a proprietary vertical market legal database. It resolves the problem of a law firm that is in several cities across the US.
Pros
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.
Cons
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.
Likelihood to Recommend
If you are a small operation and your focus is on dollar for dollar comparison to a local server based product, it will seem more expensive, until you look at the big picture of total cost of ownership. In the alternative if you consider the cost of IT with this product compared to a local server based product it shakes out in your favor. Specifically when you consider that IT help can be had remotely from around the world at huge savings and by being cloud based you can get some very brilliant but value based talent by shopping globally. Azure products help accomplish this because IT can add and remove features and resources without any need for local boots on the ground. Where local servers and databases are subject to power outages, tampering by local employees, local access security issues.... It is just built for high availability on a more reliable backbone with secure access from anywhere.
Azure database is currently used by a specific department at my organization and we mainly focus on auditing and monitoring so it pretty much serves our purpose and most importantly it is easily secured with firewall and DNS resolutions. Migrating databases is no more a hectic task from shifting a large scale database to a more managed engine.
Pros
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.
Cons
No schedulers available in case you require cron jobs.
Certain username are not allowed (root, admin, administrator).
Likelihood to Recommend
Sync and migration tools: If you already have a clutch of SQL Server-stored data somewhere and want to either sync it with SQL Azure or passively migrate it via sync, Microsoft has published a service -- the appropriately named SQL Data Sync to accomplish this. Use of the service itself is free, and all inbound data to Azure costs nothing, so you won't have to worry about racking up costs by syncing gigabyte-sized tables.
Azure SQL database can be used to replace traditional onsite SQL Server databases. It is a fit for many different business funtions within many different verticals and horizontals.
Pros
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.
Cons
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.
Likelihood to Recommend
SaaS shops that need to react quickly to customer demand can benefit greatly from the speed and ease at which a database can be created and scaled. Azure SQL Database also works extremely well with PowerBI and a plethora of other Azure services.
Azure SQL database is not likely to be a fit for replacing the database behind a large ERP, this isn't what its meant for. It also is not a fit if you have over 1 TB of data.
