Microsoft Azure SQL Database

Last updated
Azure SQL Database
Developer(s) Microsoft
Initial release2010;14 years ago (2010)
Available inEnglish
Type Managed cloud database
Website azure.microsoft.com/en-us/products/azure-sql/database/

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]

Contents

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:

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, 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

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

Related Research Articles

<span class="mw-page-title-main">IBM Db2</span> Relational model database server

Db2 is a family of data management products, including database servers, developed by IBM. It initially supported the relational model, but was extended to support object–relational features and non-relational structures like JSON and XML. The brand name was originally styled as DB2 until 2017, when it changed to its present form.

Oracle Database is a proprietary multi-model database management system produced and marketed by Oracle Corporation.

Microsoft BizTalk Server is an inter-organizational middleware system (IOMS) that automates business processes through the use of adapters which are tailored to communicate with different software systems used in an enterprise. Created by Microsoft, it provides enterprise application integration, business process automation, business-to-business communication, message broker and business activity monitoring.

Microsoft SQL Server Express is a version of Microsoft's SQL Server relational database management system that is free to download, distribute and use. It comprises a database specifically targeted for embedded and smaller-scale applications. The product traces its roots to the Microsoft Database Engine (MSDE) product, which was shipped with SQL Server 2000. The "Express" branding has been used since the release of SQL Server 2005.

Database administration is the function of managing and maintaining database management systems (DBMS) software. Mainstream DBMS software such as Oracle, IBM Db2 and Microsoft SQL Server need ongoing management. As such, corporations that use DBMS software often hire specialized information technology personnel called database administrators or DBAs.

Entity Framework (EF) is an open source object–relational mapping (ORM) framework for ADO.NET. It was originally shipped as an integral part of .NET Framework, however starting with Entity Framework version 6.0 it has been delivered separately from the .NET Framework.

Microsoft SQL Server Compact is a discontinued relational database produced by Microsoft for applications that run on mobile devices and desktops. Prior to the introduction of the desktop platform, it was known as SQL Server for Windows CE and SQL Server Mobile Edition.

Azure DevOps Server, formerly known as Team Foundation Server (TFS) and Visual Studio Team System (VSTS), is a Microsoft product that provides version control, reporting, requirements management, project management, automated builds, testing and release management capabilities. It covers the entire application lifecycle and enables DevOps capabilities. Azure DevOps can be used as a back-end to numerous integrated development environments (IDEs) but is tailored for Microsoft Visual Studio and Eclipse on all platforms.

<span class="mw-page-title-main">Visual Studio</span> Code editor and IDE

Visual Studio is an integrated development environment (IDE) developed by Microsoft. It is used to develop computer programs including websites, web apps, web services and mobile apps. Visual Studio uses Microsoft software development platforms including Windows API, Windows Forms, Windows Presentation Foundation (WPF), Windows Store and Microsoft Silverlight. It can produce both native code and managed code.

Microsoft SQL Server is a proprietary relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which may run either on the same computer or on another computer across a network. Microsoft markets at least a dozen different editions of Microsoft SQL Server, aimed at different audiences and for workloads ranging from small single-machine applications to large Internet-facing applications with many concurrent users.

Microsoft Azure Dev Tools for Teaching or simply Azure Dev Tools for Teaching is a Microsoft program to provide students with Microsoft software design, Microsoft developer tools, Cloud Computing Access and learning resources. The program is available for university/college and K-12 students Azure for Student and Azure Dev Tools for teaching are available in more than 140 countries.

<span class="mw-page-title-main">WaveMaker</span> Low-code programming platform

WaveMaker is a Java-based low-code development platform designed for building software applications and platforms. The company, WaveMaker Inc., is based in Mountain View, California. The platform is intended to assist enterprises in speeding up their application development and IT modernization initiatives through low-code capabilities. Additionally, for independent software vendors (ISVs), WaveMaker serves as a customizable low-code component that seamlessly integrates into their products.

Microsoft Azure, often referred to as Azure, is a cloud computing platform developed by Microsoft. It offers access, management, and the development of applications and services through global data centers. It also provides a range of capabilities, including software as a service (SaaS), platform as a service (PaaS), and infrastructure as a service (IaaS). Microsoft Azure supports many programming languages, tools, and frameworks, including Microsoft-specific and third-party software and systems.

Amazon Relational Database Service is a distributed relational database service by Amazon Web Services (AWS). It is a web service running "in the cloud" designed to simplify the setup, operation, and scaling of a relational database for use in applications. Administration processes like patching the database software, backing up databases and enabling point-in-time recovery are managed automatically. Scaling storage and compute resources can be performed by a single API call to the AWS control plane on-demand. AWS does not offer an SSH connection to the underlying virtual machine as part of the managed service.

A cloud database is a database that typically runs on a cloud computing platform and access to the database is provided as-a-service. There are two common deployment models: users can run databases on the cloud independently, using a virtual machine image, or they can purchase access to a database service, maintained by a cloud database provider. Of the databases available on the cloud, some are SQL-based and some use a NoSQL data model.

Azure Cosmos DB is a globally distributed, multi-model database service offered by Microsoft. It is designed to provide high availability, scalability, and low-latency access to data for modern applications. Unlike traditional relational databases, Cosmos DB is a NoSQL and vector database, which means it can handle unstructured, semi-structured, structured, and vector data types.

Microsoft Power BI is an interactive data visualization software product developed by Microsoft with a primary focus on business intelligence. It is part of the Microsoft Power Platform. Power BI is a collection of software services, apps, and connectors that work together to turn various sources of data into static and interactive data visualizations. Data may be input by reading directly from a database, webpage, PDF, or structured files such as spreadsheets, CSV, XML, JSON, XLSX, and SharePoint.

The history of Microsoft SQL Server begins with the first Microsoft SQL Server database product – SQL Server v1.0, a 16-bit relational database for the OS/2 operating system, released in 1989.

Azure Data Explorer is a fully-managed big data analytics cloud platform and data-exploration service, developed by Microsoft, that ingests structured, semi-structured and unstructured data. The service then stores this data and answers analytic ad hoc queries on it with seconds of latency. It is a full text indexing and retrieval database, including time series analysis capabilities and regular expression evaluation and text parsing.

<span class="mw-page-title-main">Microsoft Power Platform</span> Family of business software products

Microsoft Power Platform is a line of business intelligence, app development, and app connectivity software applications. Microsoft developed the Power Fx low-code programming language for expressing logic across the Power Platform. It also provides integrations with GitHub and Microsoft Teams among other apps.

References

  1. WilliamDAssafMSFT. "What is the Azure SQL Database service? - Azure SQL Database". learn.microsoft.com. Retrieved 2023-04-07.
  2. 1 2 WilliamDAssafMSFT. "What is the Azure SQL Database service? - Azure SQL Database". learn.microsoft.com. Retrieved 2023-04-07.
  3. Rabeler, Carl (March 3, 2023). "Azure SQL Database Learns & Adapts". Microsoft Azure . Retrieved 2016-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 . Retrieved 2016-11-03.
  7. "sql-cli". npm . Retrieved 2016-11-03.
  8. "Use Visual Studio Code to connect and query - Azure SQL Database & SQL Managed Instance". Microsoft . Retrieved 2023-03-29.
  9. "Add a connection to Azure SQL Database - Visual Studio (Windows)". Microsoft . 2022-09-27. Retrieved 2023-03-29.
  10. "Use SQL Server Management Studio". Microsoft . 2023-03-03. Retrieved 2016-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. Retrieved 2023-09-05.
  13. croblesm. "Resolving T-SQL differences-migration - Azure SQL Database". learn.microsoft.com. Retrieved 2023-04-07.
  14. Byham, Rick (2022-12-16). "Azure SQL Database Transact-SQL differences". Microsoft Azure .
  15. danimir. "Compare the database engine features of SQL Database and SQL Managed Instance - Azure SQL Database & SQL Managed Instance". learn.microsoft.com. Retrieved 2023-04-07.
  16. "SQL Data Services announces plans to accelerate core relational database features". Microsoft Azure . March 10, 2009. Retrieved 2016-11-03.
  17. "SQL Azure - The Year in Review". Microsoft Azure . January 4, 2011. Retrieved 2016-11-03.
  18. Kelly, Eron (November 5, 2014). "Preview for greater SQL Server compatibility coming soon to Azure SQL Database". Microsoft Azure . Retrieved 2016-11-03.
  19. Wissner, Tiffany (May 11, 2016). "Azure continues to be the best place for Software as a Service". Microsoft Azure . Retrieved 2016-11-03.
  20. markdefalco. "History of Azure SQL (2 of 61)". learn.microsoft.com. Retrieved 2023-04-07.