English
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Microsoft Azure SQL Database

Microsoft Azure SQL Database System Properties

Please select another system to compare it with Microsoft Azure SQL Database.

Our visitors often compare Microsoft Azure SQL Database with Microsoft SQL Server, Amazon Redshift and MySQL.

Editorial information provided by DB-Engines
NameMicrosoft Azure SQL Database formerly SQL Azure
DescriptionDatabase as a Service offering with high compatibility to Microsoft SQL Server
Database modelRelational DBMS
DB-Engines Ranking measures the popularity of database management systems
Trend Chart
Score20.62
Rank#28  Overall
#16  Relational DBMS
Websiteazure.microsoft.com/­en-us/­services/­sql-database
Technical documentationazure.microsoft.com/­en-us/­documentation/­services/­sql-database
DeveloperMicrosoft
Current releaseV12
License Commercial or Open Sourcecommercial
Cloud-based Only available as a cloud serviceyes
Implementation languageC++
Server operating systemshosted
Data schemeyes
Typing predefined data types such as float or dateyes
XML support Some form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.yes
Secondary indexesyes
SQL Support of (almost full) SQL standard (DML, DDL and DCL statements)yes
APIs and other access methodsJDBC
ODBC
ADO.NET
Supported programming languages.Net
Java
JavaScript (Node.js)
PHP
Python
Ruby
Server-side scripts Stored proceduresTransact SQL
Triggersyes
Replication methods Methods for redundantly storing data on multiple nodesyes, with always 3 replicas available
MapReduce Offers an API for user-defined Map/Reduce methodsno
Consistency concepts Methods to ensure consistency in a distributed systemImmediate Consistency
Foreign keys Referential integrityyes
Transaction concepts Support to ensure data integrity after non-atomic manipulations of dataACID
Concurrency Support for concurrent manipulation of datayes
Durability Support for making data persistentyes
User concepts Access controlfine grained access rights according to SQL-standard

More information provided by the system vendor

We invite representatives of system vendors to contact us for updating and extending the system information,
and for displaying vendor-provided information such as key customers, competitive advantages and market metrics.

3rd party products and services

We invite representatives of 3rd party vendors to contact us for presenting information about their offerings here.

More resources
Microsoft Azure SQL Database formerly SQL Azure
DB-Engines blog posts

The popularity of cloud-based DBMSs has increased tenfold in four years
7 February 2017, Matthias Gelbmann

Increased popularity for consuming DBMS services out of the cloud
2 October 2015, Paul Andlinger

show all

Recent citations in the news

Microsoft adds new service tier to Azure SQL Database, increases storage limits on existing databases
14 March 2017, GeekWire

Integrating DACPAC deployments of Azure SQL Database with Visual Studio Team Services
9 March 2017, Database Journal

Microsoft announces Premium RS, 4TB storage options for Azure SQL Database
10 March 2017, MSPoweruser

Get faster Azure T-SQL queries using the new database query editor
9 March 2017, TechTarget

Microsoft Adds New 'Premium RS' Cloud Database Option
12 March 2017, eWeek

provided by Google News




Share this page

Featured Products

Datastax delivers Apache Cassandra as part of a database platform purpose built for IOT, Web and Mobile Apps. Download now.

An in-memory computing platform for fast data processing in real time with high availability and scalability. Free XAP Download Here.

SQL + JSON + NoSQL.
Power, flexibility & scale.
All open source.
Get started now.

Get your step-by-step guide comparing RDBMS to graph databases, including data models, query languages, and deployment strategies.

Present your product here