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.
- Developer
- Country of Origin
- US
- Start Year
- 2009 [08]
- Former Names
- SQL Azure, SQL Server Data Services, SQL Services, Windows Azure SQL Database
- Project Type
- Commercial
- Written in
- C++
- Derived From
- SQL Server
- Inspired By
- SQL Server
- Compatible With
- SQL Server
- License
- Proprietary
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[04]
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 and has continued to support every version of SQL Server ever since.
Indexes[07]
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.
System Architecture
There are three main types of deployment for this cloud database service.
Citations
8 sources- Cloud Computing Services | Microsoft Azure microsoft.com
- Azure SQL documentation - Azure SQL | Microsoft Learn microsoft.com
- Microsoft Azure SQL Database - Wikipedia wikipedia.org
- https://azure.microsoft.com/en-us/blog/sql-azure-the-year-in-review/ microsoft.com
- Database Checkpoints (SQL Server) - SQL Server | Microsoft Learn microsoft.com
- Azure SQL Database | Microsoft Azure microsoft.com
- Automatic Tuning Overview - Azure SQL & SQL database in Fabric | Microsoft Learn microsoft.com
- https://azure.microsoft.com/en-us/blog/sql-data-services-announces-plans-to-accelerate-core-relational-database-features microsoft.com