Azure sql introduction

Azure sql introduction

• 1.
  What is AzureSQL?
• 2.
  What is AzureSQL
• 3.
  Azure Sql Database • Supportmodern cloud applications on an intelligent, managed database service, that includes serverless compute. • fully managed platform as a service (PaaS) means upgrading, patching, backups, and monitoring without user involvement • process both relational data and non-relational structures • Always running on the latest stable version of the SQL Server database engine
• 4.
  Deployment type AzureSQL Database SINGLE Elastic Pool •Single database represents a fully managed, isolated database. A single database is similar to a contained database in the SQL Server database engine. •Elastic pool is a collection of single databases with a shared set of resources, such as CPU or memory. Single databases can be moved into and out of an elastic pool
• 5.
  Service tiers Azure SQLDatabase offers three service tiers that are designed for different types of applications: • General Purpose/Standard service tier designed for common workloads. It offers budget-oriented balanced compute and storage options. • Business Critical/Premium service tier designed for OLTP applications with high transaction rate and lowest-latency I/O. It offers the highest resilience to failures by using several isolated replicas. • Hyperscale service tier designed for very large OLTP database and the ability to autoscale storage and scale compute fluidly.
• 6.
  Elastic Pool • ElasticPools used to manage unpredictable Usage pattern. • Resources are allocated to a group or Pool of Database rather than a single Database.
• 7.
  Tool to accessAzure Sql Database • Azure Portal • Azure Data Studio • Sql server Management Studio • Sql server Data tool in Visual studio
• 8.
  • https://docs.microsoft.com/ en-us/azure/azure- sql/database/sql-database- paas-overview Reference