Azure SQL Database

View Current Viewing Revision #6 from 04/30/2019 3:54 a.m.

Microsoft Azure SQL Database is a managed cloud database-as-a-service based. It shares the SQL Server 2016 codebase. It is compatible with SQL Server 2014 and 2016 and supports most of the features available in SQL Server 2016.

History

Microsoft Azure SQL Database in 2009 was announced as a child of Microsoft SQL Server that is optimized and built for deployment on cloud environments. The cloud service went live in 2010.

Data Model

Relational

Indexes

B+Tree Hash Table

Refer to (Microsoft SQL Server). Along with the indexes provided from the SQL Server codebase, Azure SQL Database produces recommendations for ADD/DROP INDEX in order to optimize its plans. It does this by monitoring the performance of queries across all SQL Database instances on the Azure cloud. It performance statistics of queries across all databases to develop models to estimate performance gains on a non-existent index for a certain query in a database instance. These estimates are used to create recommendations for adding and dropping indexes and the application can choose to automatically have these recommendations applied.

Revision #6 | Updated 04/30/2019 3:54 a.m.

View Current Viewing Revision #6 from 04/30/2019 3:54 a.m.

Website

http://www.windowsazure.com/en-us/services/sql-database/

Developer

Microsoft

Country of Origin

Start Year

2009

Former Name

SQL Azure, SQL Server Data Services, SQL Services, Windows Azure SQL Database