Microsoft Azure SQL Database
![]() | |
![]() | |
Developer(s) | Microsoft |
---|---|
Initial release | 2010 |
Available in | English |
Type | Managedcloud database |
Website | azure |
Microsoft Azure SQL Database(formerly known asSQL Azure,SQL Server Data Services,SQL Services,andWindows Azure SQL Database) is a managedcloud database(PaaS) cloud-based Microsoft SQL Servers, provided as part ofMicrosoft Azureservices. The service handles database management functions for cloud basedMicrosoft SQL Serversincluding upgrading, patching, backups, and monitoring without user involvement.[1]
Overview
[edit]Azure SQL Database supports multi-modal storage ofstructured,semi-structured,andnon-relational data.[2]
Azure SQL Database includes built-in intelligence that learns app patterns and adapts them to maximize performance, reliability, anddata protection.
Key capabilities include:
- Learning of the host app's data access patterns, adaptive performance tuning, and automatic improvements to reliability and data protection.[3]
- Scaling on demand.[4]
- Management and monitoring of multi-tenant apps with isolation benefits of one-customer-per-database.[5]
- Integration with open-source tools such as cheetah (Command-line interfaceutility),[6]sql-cli,[7]Visual Studio Code,[8]and Microsoft tools likeVisual Studio,[9]SQL Server Management Studio,[10]Azure Management Portal,PowerShell,andRESTAPIs.
- Data protection[11]withencryption,authentication,[12]limiting user access to the subset of the data, continuous monitoring and auditing to help detect potential threats and provide a record of critical events in case of a breach.
Popular use cases
[edit]- 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
Design
[edit]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
[edit]- 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
[edit]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
[edit]- Microsoft Azure
- Oracle Cloud Platform
- SQL Server
- Amazon Relational Database Service
- Relational Database
- Cloud computing
- Software as a service
References
[edit]- ^WilliamDAssafMSFT."What is the Azure SQL Database service? - Azure SQL Database".learn.microsoft.Retrieved2023-04-07.
- ^abWilliamDAssafMSFT."What is the Azure SQL Database service? - Azure SQL Database".learn.microsoft.Retrieved2023-04-07.
- ^Rabeler, Carl (March 3, 2023)."Azure SQL Database Learns & Adapts".Microsoft Azure.Retrieved2016-11-03.
- ^Rabeler, Carl (March 3, 2023)."Azure SQL Database Scales on the fly".Microsoft Azure.
- ^Rabeler, Carl (October 13, 2016)."Builds Multi-tenant Apps with Azure SQL Database With Isolation and Efficiency".Microsoft.
- ^"wunderlist/cheetah".GitHub.Retrieved2016-11-03.
- ^"sql-cli".npm.Retrieved2016-11-03.
- ^"Use Visual Studio Code to connect and query - Azure SQL Database & SQL Managed Instance".Microsoft.Retrieved2023-03-29.
- ^"Add a connection to Azure SQL Database - Visual Studio (Windows)".Microsoft.2022-09-27.Retrieved2023-03-29.
- ^"Use SQL Server Management Studio".Microsoft.2023-03-03.Retrieved2016-11-03.
- ^Rabeler, Carl (March 3, 2023)."Azure SQL Database Secures and Protects".Microsoft.
- ^Slater, Phil."Maximizing Security and Flexibility: Azure SQL Server Authentication Methods".heliumit.uk.Retrieved2023-09-05.
- ^croblesm."Resolving T-SQL differences-migration - Azure SQL Database".learn.microsoft.Retrieved2023-04-07.
- ^Byham, Rick (2022-12-16)."Azure SQL Database Transact-SQL differences".Microsoft Azure.
- ^danimir."Compare the database engine features of SQL Database and SQL Managed Instance - Azure SQL Database & SQL Managed Instance".learn.microsoft.Retrieved2023-04-07.
- ^"SQL Data Services announces plans to accelerate core relational database features".Microsoft Azure.March 10, 2009.Retrieved2016-11-03.
- ^"SQL Azure - The Year in Review".Microsoft Azure.January 4, 2011.Retrieved2016-11-03.
- ^Kelly, Eron (November 5, 2014)."Preview for greater SQL Server compatibility coming soon to Azure SQL Database".Microsoft Azure.Retrieved2016-11-03.
- ^Wissner, Tiffany (May 11, 2016)."Azure continues to be the best place for Software as a Service".Microsoft Azure.Retrieved2016-11-03.
- ^markdefalco."History of Azure SQL (2 of 61)".learn.microsoft.Retrieved2023-04-07.