Microsoft Azure SQL Database

Azure SQL Database
Developer(s)	Microsoft
Initial release	2010;14 years ago
Available in	English
Type	Managedcloud database
Website	azure.microsoft/en-us/products/azure-sql/database/

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).

References[edit]

^WilliamDAssafMSFT."What is the Azure SQL Database service? - Azure SQL Database".learn.microsoft.Retrieved2023-04-07.
^^a ^bWilliamDAssafMSFT."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.

External links[edit]

[1] WilliamDAssafMSFT."What is the Azure SQL Database service? - Azure SQL Database".learn.microsoft.Retrieved2023-04-07.

[:0-2] WilliamDAssafMSFT."What is the Azure SQL Database service? - Azure SQL Database".learn.microsoft.Retrieved2023-04-07.

[3] Rabeler, Carl (March 3, 2023)."Azure SQL Database Learns & Adapts".Microsoft Azure.Retrieved2016-11-03.

[4] Rabeler, Carl (March 3, 2023)."Azure SQL Database Scales on the fly".Microsoft Azure.

[5] Rabeler, Carl (October 13, 2016)."Builds Multi-tenant Apps with Azure SQL Database With Isolation and Efficiency".Microsoft.

[6] "wunderlist/cheetah".GitHub.Retrieved2016-11-03.

[7] "sql-cli".npm.Retrieved2016-11-03.

[8] "Use Visual Studio Code to connect and query - Azure SQL Database & SQL Managed Instance".Microsoft.Retrieved2023-03-29.

[9] "Add a connection to Azure SQL Database - Visual Studio (Windows)".Microsoft.2022-09-27.Retrieved2023-03-29.

[10] "Use SQL Server Management Studio".Microsoft.2023-03-03.Retrieved2016-11-03.

[11] Rabeler, Carl (March 3, 2023)."Azure SQL Database Secures and Protects".Microsoft.

[12] Slater, Phil."Maximizing Security and Flexibility: Azure SQL Server Authentication Methods".heliumit.uk.Retrieved2023-09-05.

[13] roblesm."Resolving T-SQL differences-migration - Azure SQL Database".learn.microsoft.Retrieved2023-04-07.

[14] Byham, Rick (2022-12-16)."Azure SQL Database Transact-SQL differences".Microsoft Azure.

[15] r."Compare the database engine features of SQL Database and SQL Managed Instance - Azure SQL Database & SQL Managed Instance".learn.microsoft.Retrieved2023-04-07.

[16] "SQL Data Services announces plans to accelerate core relational database features".Microsoft Azure.March 10, 2009.Retrieved2016-11-03.

[17] "SQL Azure - The Year in Review".Microsoft Azure.January 4, 2011.Retrieved2016-11-03.

[18] Kelly, Eron (November 5, 2014)."Preview for greater SQL Server compatibility coming soon to Azure SQL Database".Microsoft Azure.Retrieved2016-11-03.

[19] Wissner, Tiffany (May 11, 2016)."Azure continues to be the best place for Software as a Service".Microsoft Azure.Retrieved2016-11-03.

[20] rkdefalco."History of Azure SQL (2 of 61)".learn.microsoft.Retrieved2023-04-07.

[1]

[2]

[3]

[4]

[5]

[6]

[7]

[8]

[9]

[10]

[11]

[12]

[13]

[14]

[15]

[16]

[17]

[18]

[19]

[20]

v t e Cloud computing
Business models	Content as a service Data as a service Desktop as a service Function as a service Infrastructure as a service Integration platform as a service Backend as a service Network as a service Platform as a service Security as a service Software as a service
Technologies	Cloud database Cloud-native computing Cloud storage Cloud storage gateways Data centers Dew computing Distributed file system for cloud Hardware virtualization Internet Mobile cloud computing Native cloud application Networking Personal cloud Security Serverless computing Structured storage Virtual appliance Web APIs Virtual private cloud
Applications	Box Dropbox Google Workspace Drive HP Cloud(closed) IBM Cloud Microsoft Office 365 OneDrive Nextcloud Oracle Cloud Owncloud Rackspace Salesforce Seafile Workday Zoho
Platforms	Alibaba Cloud Amazon Web Services AppScale Box CloudBolt Cloud Foundry Cocaine (PaaS) Creatio Engine Yard Helion GE Predix Google App Engine GreenQloud Heroku IBM Cloud Inktank Jelastic Microsoft Azure MindSphere Netlify Oracle Cloud OutSystems openQRM OpenShift PythonAnywhere RightScale Scalr Force SAP Cloud Platform Splunk Vercel vCloud Air WaveMaker
Infrastructure	Alibaba Cloud Amazon Web Services Abiquo Enterprise Edition CloudStack Citrix Cloud Deft DigitalOcean EMC Atmos Eucalyptus Fujitsu Google Cloud Platform GreenButton GreenQloud IBM Cloud iland Joyent Linode Lunacloud Microsoft Azure Mirantis Netlify Nimbula Nimbus OpenIO OpenNebula OpenStack Oracle Cloud OrionVM Rackspace Cloud Safe Swiss Cloud Zadara libvirt libguestfs OVirt Virtual Machine Manager Wakame-vdc Vercel Virtual Private Cloud OnDemand
Category Commons

v t e Microsoft Azure
Azure Platform	Microsoft Azure Azure RTOS ThreadX Azure Sphere Azure Virtual Desktop Azure Linux
Compute	Azure Web Apps
Storage	Azure Cognitive Search Azure Cosmos DB Azure Data Explorer Azure Data Lake Azure SQL Database
Messaging	Azure Stream Analytics
Developer Tools	Azure DevOps Server Azure DevOps Services Azure Kinect
Related	Entra ID Azure AD Connect Azure Dev Tools for Teaching Service Management Automation Windows Azure Caching