Top Qs
Timeline
Chat
Perspective

Microsoft Azure SQL Database

Managed cloud database From Wikipedia, the free encyclopedia

Microsoft Azure SQL Database
Remove ads

Microsoft Azure SQL Database (formerly known as SQL Azure, SQL Server Data Services, SQL Services, and Windows Azure SQL Database) is a managed cloud database (PaaS) cloud-based Microsoft SQL Servers, provided as part of Microsoft Azure services. The service handles database management functions for cloud based Microsoft SQL Servers including upgrading, patching, backups, and monitoring without user involvement.[1]

Quick Facts Developer(s), Initial release ...
Remove ads

Overview

Azure SQL Database supports multi-modal storage of structured, semi-structured, and non-relational data.[2]

Azure SQL Database includes built-in intelligence that learns app patterns and adapts them to maximize performance, reliability, and data protection.

Key capabilities include:

Remove ads
  • Relational data storage for cloud-based applications and websites
  • Business and consumer web and mobile apps
  • Manage databases for multi-tenant apps (software-as-a-service)
  • Quickly create dev and test databases to speed up development cycles
  • Scale production business services quickly and at a known cost
  • Containerize data in the cloud for isolation and security
  • Reduce database administration overhead through increased automation
Remove ads

Design

Azure SQL Database is built on the foundation of the SQL server database and therefore, kept in sync with the latest version[2] of it by using the common code base. Since the cloud version of the database technology strives to decouple it from the underlying computing infrastructure, it doesn't support some of the context specific T-SQL features[13] available in the traditional SQL server. However, the rest of the features are the same with incompatibilities spelled out by Microsoft.[14] Azure SQL Database is also similar to Microsoft's SQL Managed instance offering, with some differences.[15]

Timeline

  • 2009 – Service announced[16]
  • 2010 – Service went live[17]
  • 2014 – New version announced and rebranded from Windows Azure to Microsoft Azure[18]
  • 2015 – Major Architectural Revision
  • 2016 – Elastic Pools Introduced[19]
  • 2017 - Azure SQL Database Managed Instance launched
  • 2019 - Introduced Azure SQL Database Hyperscale, Serverless, and Instance Pools[20]

Deployment Models

Azure SQL Database is offered in two deployment models, as a Standalone database or an Elastic database pool (with shared storage and compute resources).

See also

References

Loading content...
Loading content...
Loading related searches...

Wikiwand - on

Seamless Wikipedia browsing. On steroids.

Remove ads