Microsoft Azure SQL Database

Azure SQL Database supports multi-modal storage of structured, semi-structured, and non-relational data.{{Cite web |last=WilliamDAssafMSFT |title=What is the Azure SQL Database service? - Azure SQL Database |url=https://learn.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview |access-date=2023-04-07 |website=learn.microsoft.com |language=en-us}}

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

Key capabilities include:

• Learning of the host app's data access patterns, adaptive performance tuning, and automatic improvements to reliability and data protection.{{Cite news |last=Rabeler |first=Carl |date=March 3, 2023 |title=Azure SQL Database Learns & Adapts |work=Microsoft Azure |url=https://azure.microsoft.com/en-us/documentation/articles/sql-database-learn-and-adapt/ |access-date=2016-11-03}}
• Scaling on demand.{{Cite web |last=Rabeler |first=Carl |date=March 3, 2023 |title=Azure SQL Database Scales on the fly |url=https://azure.microsoft.com/en-us/documentation/articles/sql-database-scale-on-the-fly/ |website=Microsoft Azure}}
• Management and monitoring of multi-tenant apps with isolation benefits of one-customer-per-database.{{Cite web |last=Rabeler |first=Carl |date=October 13, 2016 |title=Builds Multi-tenant Apps with Azure SQL Database With Isolation and Efficiency |url=https://azure.microsoft.com/en-us/documentation/articles/sql-database-build-multi-tenant-apps/ |website=Microsoft}}
• Integration with open-source tools such as cheetah (Command-line interface utility),{{Cite web |title=wunderlist/cheetah |url=https://github.com/wunderlist/cheetah |access-date=2016-11-03 |website=GitHub}} sql-cli,{{Cite web |title=sql-cli |url=https://www.npmjs.com/package/sql-cli |access-date=2016-11-03 |website=npm}} Visual Studio Code,{{Cite web |last= |title=Use Visual Studio Code to connect and query - Azure SQL Database & SQL Managed Instance |url=https://learn.microsoft.com/en-us/azure/azure-sql/database/connect-query-vscode |access-date=2023-03-29 |website=Microsoft |language=en-us}} and Microsoft tools like Visual Studio,{{Cite web |last= |date=2022-09-27 |title=Add a connection to Azure SQL Database - Visual Studio (Windows) |url=https://learn.microsoft.com/en-us/visualstudio/azure/azure-sql-database-add-connected-service |access-date=2023-03-29 |website=Microsoft |language=en-us}} SQL Server Management Studio,{{Cite web |date=2023-03-03 |title=Use SQL Server Management Studio |url=https://msdn.microsoft.com/library/ms174173.aspx |access-date=2016-11-03 |website=Microsoft}} Azure Management Portal, PowerShell, and REST APIs.
• Data protection{{Cite web |last=Rabeler |first=Carl |date=March 3, 2023 |title=Azure SQL Database Secures and Protects |url=https://azure.microsoft.com/en-us/documentation/articles/sql-database-helps-secures-and-protects/ |website=Microsoft}} with encryption, authentication,{{Cite web |last=Slater |first=Phil |title=Maximizing Security and Flexibility: Azure SQL Server Authentication Methods |url=https://www.heliumit.uk/post/azure-sql-server-authentication-methods |access-date=2023-09-05 |website=heliumit.uk |language=en-us}} 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.

• 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

Azure SQL Database is built on the foundation of the SQL server database and therefore, kept in sync with the latest version 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{{Cite web |last=croblesm |title=Resolving T-SQL differences-migration - Azure SQL Database |url=https://learn.microsoft.com/en-us/azure/azure-sql/database/transact-sql-tsql-differences-sql-server |access-date=2023-04-07 |website=learn.microsoft.com |language=en-us}} available in the traditional SQL server. However, the rest of the features are the same with incompatibilities spelled out by Microsoft.{{Cite web |last=Byham |first=Rick |date=2022-12-16 |title=Azure SQL Database Transact-SQL differences |url=https://azure.microsoft.com/en-us/documentation/articles/sql-database-transact-sql-information/ |website=Microsoft Azure}} Azure SQL Database is also similar to Microsoft's SQL Managed instance offering, with some differences.{{Cite web |last=danimir |title=Compare the database engine features of SQL Database and SQL Managed Instance - Azure SQL Database & SQL Managed Instance |url=https://learn.microsoft.com/en-us/azure/azure-sql/database/features-comparison |access-date=2023-04-07 |website=learn.microsoft.com |language=en-us}}

• 2009 – Service announced{{Cite web |date=March 10, 2009 |title=SQL Data Services announces plans to accelerate core relational database features |url=https://azure.microsoft.com/en-us/blog/sql-data-services-announces-plans-to-accelerate-core-relational-database-features/ |access-date=2016-11-03 |website=Microsoft Azure}}
• 2010 – Service went live{{Cite web |date=January 4, 2011 |title=SQL Azure - The Year in Review |url=https://azure.microsoft.com/en-us/blog/sql-azure-the-year-in-review/ |access-date=2016-11-03 |website=Microsoft Azure}}
• 2014 – New version announced and rebranded from Windows Azure to Microsoft Azure{{Cite web |last=Kelly |first=Eron |date=November 5, 2014 |title=Preview for greater SQL Server compatibility coming soon to Azure SQL Database |url=https://azure.microsoft.com/en-us/blog/preview-for-greater-sql-server-compatibility-coming-soon-to-azure-sql-database/ |access-date=2016-11-03 |website=Microsoft Azure}}
• 2015 – Major Architectural Revision
• 2016 – Elastic Pools Introduced{{Cite web |last=Wissner |first=Tiffany |date=May 11, 2016 |title=Azure continues to be the best place for Software as a Service |url=https://azure.microsoft.com/en-us/blog/with-newly-available-services-azure-continues-to-be-the-best-place-for-software-as-a-service-developers/ |access-date=2016-11-03 |website=Microsoft Azure}}
• 2017 - Azure SQL Database Managed Instance launched
• 2019 - Introduced Azure SQL Database Hyperscale, Serverless, and Instance Pools{{Cite web |last=markdefalco |title=History of Azure SQL (2 of 61) |url=https://learn.microsoft.com/en-us/shows/azure-sql-for-beginners/history-of-azure-sql-2-of-61 |access-date=2023-04-07 |website=learn.microsoft.com |language=en-us}}

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

• Microsoft Azure
• Oracle Cloud Platform
• SQL Server
• Amazon Relational Database Service
• Relational Database
• Cloud computing
• Software as a service

{{Reflist}}

• {{Official website|https://azure.microsoft.com/en-us/products/azure-sql/database/}}
• [https://www.dumpscompany.com/AZ-500-exam-dumps Microsoft Azure Security Technologies]
• [https://docs.microsoft.com/en-us/azure/sql-database/sql-database-paas-index What is Azure SQL Database?]

{{Cloud computing}}

{{Microsoft Azure Services Platform}}

{{Microsoft development tools}}

Azure SQL Database