Overview
What is Azure SQL Database?
Azure SQL Database is Microsoft's relational database as a service (DBaaS).
My Azure SQL Database Review
Microsoft Azure SQL Database - Good Value - Great Features!
Simple, Fast, and Powerful
Cloud-based relational database service that is both intelligent and scalable.
Too expensive to be really useful overall.
Going to the cloud with Microsoft SQL, Azure SQL Database is surely the way to go!
Microsoft Azure SQL Database: Fully Managed and secure SQL database
AZURE cost effective reliability!
Secure Product Providing High-Performance
Azure SQL - your solution for Agility and Scalability
Azure SQL Database - Good Now, Getting Even Better
Easy decision, good price.
Azure SQL database makes ease the transition to Cloud
Azure SQL Databases is quick to scale
Awards
Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards
Popular Features
- Database scalability (27)10.0100%
- Automated backups (27)9.999%
- Database security provisions (27)9.090%
- Monitoring and metrics (26)9.090%
Pricing
2 vCORE
$0.5044
6 vCORE
$1.5131
10 vCORE
$2.52
Entry-level set up fee?
- No setup fee
Offerings
- Free Trial
- Free/Freemium Version
- Premium Consulting/Integration Services
Product Demos
How to connect to Azure SQL Database from Azure Data Studio | Data Exposed
What is Azure SQL Database Hyperscale?
Features
Database-as-a-Service
Database as a Service (DBaaS) software, sometimes referred to as cloud database software, is the delivery of database services ocer the Internet as a service
- 8.1Automatic software patching(25) Ratings
Patches applied to database automatically
- 10Database scalability(27) Ratings
Ease of scaling compute or memory resources and storage up or down
- 9.9Automated backups(27) Ratings
Automated backup enabling point-in-time data recovery
- 9Database security provisions(27) Ratings
Provision for database encryption, network isolation, and identity access management
- 9Monitoring and metrics(26) Ratings
Built-in monitoring of multiple operational metrics
- 9Automatic host deployment(22) Ratings
Compute instance replacement in the event of hardware failure
Product Details
- About
- Integrations
- Tech Details
- FAQs
What is Azure SQL Database?
Azure SQL Database Integrations
Azure SQL Database Technical Details
Deployment Types | Software as a Service (SaaS), Cloud, or Web-Based |
---|---|
Operating Systems | Unspecified |
Mobile Application | No |
Frequently Asked Questions
Comparisons
Compare with
Reviews and Ratings
(274)Attribute Ratings
Reviews
(1-5 of 5)My Azure SQL Database Review
- 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.
- Automatic software patching
- 100%10.0
- Database scalability
- 80%8.0
- Automated backups
- 90%9.0
- Database security provisions
- 100%10.0
- Monitoring and metrics
- 90%9.0
- Automatic host deployment
- 100%10.0
- It's cheaper for us than maintaining our own hardware but it's easy to spend more to get more, i.e. price creep.
- It's very easy and quick to build out a new database to test/POC a new project.
Secure Product Providing High-Performance
- 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.
- Automatic software patching
- 80%8.0
- Database scalability
- 100%10.0
- Automated backups
- 90%9.0
- Database security provisions
- 100%10.0
- Monitoring and metrics
- 100%10.0
- Automatic host deployment
- 80%8.0
- Was worth it to implement across the company. Our needs are completely met by the product.
- Eliminates time wasted on other products with a less friendly UI.
Azure SQL - your solution for Agility and Scalability
- 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.
- Automatic software patching
- 70%7.0
- Database scalability
- 90%9.0
- Automated backups
- 70%7.0
- Database security provisions
- 80%8.0
- Monitoring and metrics
- 80%8.0
- Automatic host deployment
- 80%8.0
- We don't need a dedicated SQL dba because so many of the database maintenance operations are managed. A huge positive not only in budget but time constraints.
- The ability to scale quickly is the biggest positive as our data needs change constantly.
- Easy to migrate from legacy tools and systems, saving us on the need for redevelopment.
Azure SQL Database - Good Now, Getting Even Better
- 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).
- Automatic software patching
- 100%10.0
- Database scalability
- 100%10.0
- Automated backups
- 100%10.0
- Database security provisions
- 80%8.0
- Monitoring and metrics
- 50%5.0
- Automatic host deployment
- 90%9.0
- This boils down to the use of OPEX as oppose to CAPEX which is perceived as an advantage over the old model of doing business.
- The many barriers to scaling a solution fade away. It typically becomes a quick pitch with facts on the resource overuse or saturation and an up-sizing is approved.
- The extra development would be often necessary for unsupported features or a differently implemented security.
Azure "The Best to catch a breath for your self"
- 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).
- Automatic software patching
- 80%8.0
- Database scalability
- 90%9.0
- Automated backups
- 90%9.0
- Database security provisions
- 90%9.0
- Monitoring and metrics
- 90%9.0
- Automatic host deployment
- 90%9.0
- As compared to On Site SQL server AZURE is less hectic and less responsibility to worry for.
- It pretty much easy to follow devOps or Agile for Backlogs as AZURE allows to take care of its own things.
- Database scalability, Patching and Upgrading is the best thing it gives in return
- Migration and management
- Monitoring
- Updation of database and services
- Does not require onsite infrastructure
- Unlike onsite databases, scaling up or scaling down is very easy with Azure SQL Database.
- Moving to Azure SQL Database will free up your DBA to work on the backlog of projects that often never get done because they spend a lot of time maintaining and monitoring onsite SQL.
- Use it via a VM if you need it.
- Applications written for multiple databases.
- Elasticity. A much-abused buzzword, but in SQL Azure's case, it applies.
- Product Features
- Product Usability
- Vendor Reputation
- Analyst Reports
- Third-party Reviews