# Microsoft Azure SQL Database

> Mediated Wiki article. Canonical URL: https://mediated.wiki/source/Microsoft_Azure_SQL_Database
> Markdown URL: https://mediated.wiki/source/Microsoft_Azure_SQL_Database.md
> Source: https://en.wikipedia.org/wiki/Microsoft_Azure_SQL_Database
> Source revision: 1319654326
> License: Creative Commons Attribution-ShareAlike 4.0 International (https://creativecommons.org/licenses/by-sa/4.0/)

Managed cloud database

Azure SQL Developer Microsoft Release 2010; 16 years ago (2010) Available in English Type Managed cloud database Website https://azure.microsoft.com/en-us/products/azure-sql/

**Microsoft Azure SQL Database** (also described as **SQL Server on Azure** or **Azure SQL**; formerly known as **SQL Azure**, **SQL Server Data Services**, **SQL Services**, and **Windows Azure SQL Database**) is a managed [cloud database](/source/Cloud_database) ([PaaS](/source/Platform_as_a_Service)) cloud-based Microsoft SQL Servers, provided as part of [Microsoft Azure](/source/Microsoft_Azure) services. The service handles database management functions for cloud based [Microsoft SQL Servers](/source/Microsoft_SQL_Server) including upgrading, patching, backups, and monitoring without user involvement.[1]

## Overview

Azure SQL Database supports multi-modal storage of [structured](/source/Structured_data), [semi-structured](/source/Semi-structured_data), and [non-relational data](/source/Non-relational_database).[2]

Azure SQL Database includes built-in intelligence that learns app patterns and adapts them to maximize performance, reliability, and [data protection](/source/Information_privacy).

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 interface](/source/Command-line_interface) utility),[6] sql-cli,[7] [Visual Studio Code](/source/Visual_Studio_Code),[8] and Microsoft tools like [Visual Studio](/source/Visual_Studio),[9] [SQL Server Management Studio](/source/SQL_Server_Management_Studio),[10] [Azure Management Portal](/source/Azure_Management_Portal), [PowerShell](/source/PowerShell), and [REST](/source/Representational_state_transfer) APIs.

- Data protection[11] with [encryption](/source/Encryption), 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

- 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](/source/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

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

- [Microsoft Azure](/source/Microsoft_Azure)

- [Oracle Cloud Platform](/source/Oracle_Cloud#Platform_as_a_Service_.28PaaS.29)

- [SQL Server](/source/Microsoft_SQL_Server)

- [Amazon Relational Database Service](/source/Amazon_Relational_Database_Service)

- [Relational Database](/source/Relational_database)

- [Cloud computing](/source/Cloud_computing)

- [Software as a service](/source/Software_as_a_service)

## References

1. **[^](#cite_ref-1)** WilliamDAssafMSFT. ["What is the Azure SQL Database service? - Azure SQL Database"](https://learn.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview). *learn.microsoft.com*. Retrieved 2023-04-07.

1. ^ [***a***](#cite_ref-:0_2-0) [***b***](#cite_ref-:0_2-1) WilliamDAssafMSFT. ["What is the Azure SQL Database service? - Azure SQL Database"](https://learn.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview). *learn.microsoft.com*. Retrieved 2023-04-07.

1. **[^](#cite_ref-3)** Rabeler, Carl (March 3, 2023). ["Azure SQL Database Learns & Adapts"](https://azure.microsoft.com/en-us/documentation/articles/sql-database-learn-and-adapt/). *[Microsoft Azure](/source/Microsoft_Azure)*. Retrieved 2016-11-03.

1. **[^](#cite_ref-4)** Rabeler, Carl (March 3, 2023). ["Azure SQL Database Scales on the fly"](https://azure.microsoft.com/en-us/documentation/articles/sql-database-scale-on-the-fly/). *[Microsoft Azure](/source/Microsoft_Azure)*.

1. **[^](#cite_ref-5)** Rabeler, Carl (October 13, 2016). ["Builds Multi-tenant Apps with Azure SQL Database With Isolation and Efficiency"](https://azure.microsoft.com/en-us/documentation/articles/sql-database-build-multi-tenant-apps/). *[Microsoft](/source/Microsoft)*.

1. **[^](#cite_ref-6)** ["wunderlist/cheetah"](https://github.com/wunderlist/cheetah). *[GitHub](/source/GitHub)*. Retrieved 2016-11-03.

1. **[^](#cite_ref-7)** ["sql-cli"](https://www.npmjs.com/package/sql-cli). *[npm](/source/Npm_(software))*. Retrieved 2016-11-03.

1. **[^](#cite_ref-8)** ["Use Visual Studio Code to connect and query - Azure SQL Database & SQL Managed Instance"](https://learn.microsoft.com/en-us/azure/azure-sql/database/connect-query-vscode). *[Microsoft](/source/Microsoft)*. Retrieved 2023-03-29.

1. **[^](#cite_ref-9)** ["Add a connection to Azure SQL Database - Visual Studio (Windows)"](https://learn.microsoft.com/en-us/visualstudio/azure/azure-sql-database-add-connected-service). *[Microsoft](/source/Microsoft)*. 2022-09-27. Retrieved 2023-03-29.

1. **[^](#cite_ref-10)** ["Use SQL Server Management Studio"](https://msdn.microsoft.com/library/ms174173.aspx). *[Microsoft](/source/Microsoft)*. 2023-03-03. Retrieved 2016-11-03.

1. **[^](#cite_ref-11)** Rabeler, Carl (March 3, 2023). ["Azure SQL Database Secures and Protects"](https://azure.microsoft.com/en-us/documentation/articles/sql-database-helps-secures-and-protects/). *[Microsoft](/source/Microsoft)*.

1. **[^](#cite_ref-12)** Slater, Phil. ["Maximizing Security and Flexibility: Azure SQL Server Authentication Methods"](https://www.heliumit.uk/post/azure-sql-server-authentication-methods). *heliumit.uk*. Retrieved 2023-09-05.

1. **[^](#cite_ref-13)** croblesm. ["Resolving T-SQL differences-migration - Azure SQL Database"](https://learn.microsoft.com/en-us/azure/azure-sql/database/transact-sql-tsql-differences-sql-server). *learn.microsoft.com*. Retrieved 2023-04-07.

1. **[^](#cite_ref-14)** Byham, Rick (2022-12-16). ["Azure SQL Database Transact-SQL differences"](https://azure.microsoft.com/en-us/documentation/articles/sql-database-transact-sql-information/). *[Microsoft Azure](/source/Microsoft_Azure)*.

1. **[^](#cite_ref-15)** danimir. ["Compare the database engine features of SQL Database and SQL Managed Instance - Azure SQL Database & SQL Managed Instance"](https://learn.microsoft.com/en-us/azure/azure-sql/database/features-comparison). *learn.microsoft.com*. Retrieved 2023-04-07.

1. **[^](#cite_ref-16)** ["SQL Data Services announces plans to accelerate core relational database features"](https://azure.microsoft.com/en-us/blog/sql-data-services-announces-plans-to-accelerate-core-relational-database-features/). *[Microsoft Azure](/source/Microsoft_Azure)*. March 10, 2009. Retrieved 2016-11-03.

1. **[^](#cite_ref-17)** ["SQL Azure - The Year in Review"](https://azure.microsoft.com/en-us/blog/sql-azure-the-year-in-review/). *[Microsoft Azure](/source/Microsoft_Azure)*. January 4, 2011. Retrieved 2016-11-03.

1. **[^](#cite_ref-18)** Kelly, Eron (November 5, 2014). ["Preview for greater SQL Server compatibility coming soon to Azure SQL Database"](https://azure.microsoft.com/en-us/blog/preview-for-greater-sql-server-compatibility-coming-soon-to-azure-sql-database/). *[Microsoft Azure](/source/Microsoft_Azure)*. Retrieved 2016-11-03.

1. **[^](#cite_ref-19)** Wissner, Tiffany (May 11, 2016). ["Azure continues to be the best place for Software as a Service"](https://azure.microsoft.com/en-us/blog/with-newly-available-services-azure-continues-to-be-the-best-place-for-software-as-a-service-developers/). *[Microsoft Azure](/source/Microsoft_Azure)*. Retrieved 2016-11-03.

1. **[^](#cite_ref-20)** markdefalco. ["History of Azure SQL (2 of 61)"](https://learn.microsoft.com/en-us/shows/azure-sql-for-beginners/history-of-azure-sql-2-of-61). *learn.microsoft.com*. Retrieved 2023-04-07.

## External links

- [Official website](https://azure.microsoft.com/en-us/products/azure-sql/database/)

- [Microsoft Azure Security Technologies](https://www.dumpscompany.com/AZ-500-exam-dumps)

- [What is Azure SQL Database?](https://docs.microsoft.com/en-us/azure/sql-database/sql-database-paas-index)

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 Lark Microsoft Office 365 OneDrive Nextcloud OpenDesk Oracle Cloud Owncloud Proton Drive Rackspace Salesforce Seafile PlateSpin Workday Zoho Platforms Alibaba Cloud Amazon Web Services AppScale Box CloudBolt Cloud Foundry Cocaine (PaaS) 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.com SAP Business Technology 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 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 Entra Connect Azure Dev Tools for Teaching Service Management Automation Windows Azure Caching

v t e Microsoft development tools Development environments Visual Studio Code Express Team System Profiler Tools for Applications Tools for Office Others Blend Expression Web FxCop GW-BASIC MACRO-80 Macro Assembler MSBuild Pascal QuickBASIC QBasic QuickC Robotics Developer Studio Roslyn SharePoint Designer FrontPage Small Basic WebMatrix Windows App SDK Windows App Studio Windows SDK CLR Profiler ILAsm Native Image Generator WinDiff XAMLPad Languages Dynamics AX BASIC Visual Basic legacy VB.NET VBA VBScript Bosque Visual C++ C++/CX C++/CLI Managed C++ C++/WinRT C# C/AL Dafny Dexterity F# F* Visual FoxPro Java J++ J# JavaScript TypeScript JScript IronPython IronRuby Lean P Power Fx PowerShell Project Verona Q# Small Basic VPL XAML APIs and frameworks Native Windows API Silverlight XNA DirectX Managed DirectX UWP Xbox Development Kit Windows Installer WinUI .NET ASP.NET Core AJAX Dynamic Data MVC Razor Web Forms ADO.NET Entity Framework MAUI CardSpace Communication Foundation Identity Foundation LINQ Presentation Foundation Workflow Foundation Device drivers WDK WDF KMDF UMDF Windows HLK WDM Database SQL Server Express Compact Management Studio MSDE SQL services Analysis Reporting Integration Notification Other Visual FoxPro Microsoft Access Access Database Engine Extensible Storage Engine Source control Visual SourceSafe Team Foundation Version Control Testing and debugging CodeView OneFuzz Playwright Script Debugger WinDbg xUnit.net Delivery Active Setup ClickOnce npm NuGet vcpkg Web Platform Installer Windows Installer WiX Windows Package Manager Microsoft Store Category

---
Adapted from the Wikipedia article [Microsoft Azure SQL Database](https://en.wikipedia.org/wiki/Microsoft_Azure_SQL_Database) by Wikipedia contributors ([contributor history](https://en.wikipedia.org/wiki/Microsoft_Azure_SQL_Database?action=history)). Available under [Creative Commons Attribution-ShareAlike 4.0 International](https://creativecommons.org/licenses/by-sa/4.0/). Changes may have been made.