Friday, April 16, 2021

Azure SQL

 Azure SQL Database is a relational database-as-a-service (DBaaS) hosted in Azure that falls into the industry category of Platform-as-a-Service (PaaS).

  • Best for modern cloud applications that want to use the latest stable SQL Server features and have time constraints in development and marketing.
  • A fully managed SQL Server database engine, based on the latest stable Enterprise Edition of SQL Server. SQL Database has two deployment options built on standardized hardware and software that is owned, hosted, and maintained by Microsoft.

With SQL Server, you can use built-in features and functionality that requires extensive configuration (either on-premises or in an Azure virtual machine). When using SQL Database, you pay-as-you-go with options to scale up or out for greater power with no interruption. SQL Database has some additional features that are not available in SQL Server, such as built-in high availability, intelligence, and management.

Azure SQL Database offers the following deployment options:

  • As a single database with its own set of resources managed via a logical SQL server. A single database is similar to a contained database in SQL Server. This option is optimized for modern application development of new cloud-born applications. Hyperscale and serverless options are available.
  • An elastic pool, which is a collection of databases with a shared set of resources managed via a logical SQL server. Single databases can be moved into and out of an elastic pool. This option is optimized for modern application development of new cloud-born applications using the multi-tenant SaaS application pattern. Elastic pools provide a cost-effective solution for managing the performance of multiple databases that have variable usage patterns.


Related Posts:

  • Azure Logic Apps What is Azure Logic Apps?Azure Logic Apps is a cloud-based platform for creating and running automated workflows that integrate your apps, data,… Read More
  • IaaS vs PaaS vs SaaS SaaS, PaaS, and IaaS are simply three ways to describe how you can use the cloud for your business.IaaS: cloud-based services, pay-as-you-go for servi… Read More
  • Azure Active Directory What is Azure Active Directory?Azure Active Directory (Azure AD) is Microsoft’s cloud-based identity and access management service, which helps … Read More
  • Azure Functions Vs Logic AppsAn Azure function is a code triggered by an event whereas an Azure Logic app is a workflow triggered by an event.Azure Logic App can define a workflow… Read More
  • Azure Functions vs Web JobsAzure Web Job is a piece of code runs in the Azure App services. It is a Cloud Service used to run background tasks. Azure Functions are built on the … Read More

0 comments:

Post a Comment