Bigdata
Now Reading
Azure SQL Database
0
Review

Azure SQL Database

Overview
Synopsis

Azure SQL Database is the intelligent, fully managed relational cloud database service that provides the broadest SQL Server engine compatibility, so users can migrate SQL Server databases without changing apps.

Category

Database as a Service SQL Data Model

Features

• Automatic index management: Identifies indexes that should be added in the database, and indexes that should be removed
• Threat detection detects anomalous activities indicating unusual and potentially harmful attempts to access or exploit your database
• Auditing can help users maintain regulatory compliance, understand database activity, and gain insight into discrepancies and anomalies
• Transparent data encryption
• Active Directory integration and multi-factor authentication
• Active geo-replication: Enables global read scale and removes bottlenecks on the primary that are due to read workloads

License

• Open source

Pricing

Subscription

Free Trial

Available

Users Size

Small (<50 employees), Medium (50 to 1000 employees), Enterprise (>1001 employees)

Company

Azure SQL Database

What is best?

• Automatic index management: Identifies indexes that should be added in the database, and indexes that should be removed
• Threat detection detects anomalous activities indicating unusual and potentially harmful attempts to access or exploit your database
• Auditing can help users maintain regulatory compliance, understand database activity, and gain insight into discrepancies and anomalies

What are the benefits?

• Backup: Automatically performs full, differential, and transaction log backups
• Point-in-time restores: Supports recovery to any point in time within the automatic backup retention period
• Failover groups: Enables creation of globally distributed SaaS applications with minimal administration overhead
• Automatic plan correction: Identifies problematic plans and fixes SQL plan performance problems

PAT Rating™
Editor Rating
Aggregated User Rating
Rate Here
Ease of use
7.6
Features & Functionality
7.6
8.2
Advanced Features
7.6
8.6
Integration
7.6
8.0
Performance
7.6
8.4
Customer Support
7.6
Implementation
Renew & Recommend
Bottom Line

SQL Database is a general-purpose relational database managed service in Microsoft Azure that supports structures such as relational data, JSON, spatial, and XML.

7.6
Editor Rating
8.3
Aggregated User Rating
1 rating
You have rated this

Azure SQL Database is the intelligent, fully managed relational cloud database service that provides the broadest SQL Server engine compatibility, so users can migrate SQL Server databases without changing apps. Take advantage of built-in intelligence that learns app patterns and adapts to maximize performance, reliability, and data protection. Importing and migrating bulk data from on premises or other cloud providers to SQL Database has never been easier. Use the power of Azure to transform unstructured and semi-structured flat files, or migrate an entire database schema directly into SQL Database to produce consumable data products for analytics, reporting, or intelligent applications. Taking advantage of SQL Database end points for transaction replication allows applications to function seamlessly both on-premises and in Azure. Easily replicate data among multiple SQL Databases to enable isolation of mission-critical workloads from longer running analytics queries. By using Azure Data Sync and transactional replication, developers will be able to modernize applications in a tiered approach from on-premises to hybrid, and move fully to the cloud. Using Microsoft products or various open-source products running on the Azure platform, high velocity streaming data can be easily consumed, rationalized, and stored in SQL Database. These new data streams will help drive additional intelligence for applications, analytical insight, and operational reporting. From serverless deployments and new data streams to the migration of existing data assets, simplifying the entire data estate is easy using the integrated services across Azure. Bring new data sources together with existing data in a seamless experience that provides customers with new insights and value. The Azure platform fully manages every Azure SQL Database and guarantees no data loss and high percentage of data availability.

Filter reviews
User Ratings





User Company size



User role





User industry





Ease of use
Features & Functionality
Advanced Features
Integration
Performance
Customer Support
Implementation
Renew & Recommend

What's your reaction?
Love It
0%
Very Good
0%
INTERESTED
0%
COOL
0%
NOT BAD
0%
WHAT !
0%
HATE IT
0%