Azure Interfaces

• To interact with azure we have 3 major interfaces
  • Using Browser: Azure Portal
  • From Command Line:
    • Azure CLI
    • Azure Powershell
  • From Code:
    • Azure SDK

Azure SQL (Contd)

• Azure SQL Concepts/Features
  

Azure SQL Single Database

• Create a resource group
  
• Create an Azure SQL Database
  • Size: Basic
  • With Sample Database
    
    
    
    
    
    
    
    
    
    
• Wait for the database to be created
• Open the database and set server firewall rule
  
• To allow all refer below
  
• To allow your client ip
  
• Open Query Editor
  
  
• Max size of data in
  • Azure SQL Databases is 4 TB
  • Azure SQL Managed instances is 16 TB
  • Azure SQL HyperScale is 100 TB

Failover in Databases

• For Failover to happen, we need to create a failover group at server level.
• Then we can configure write policy
• When primary database fails making secondary database to accept the connections is considered as failover.

Backup Types

• Point in Time Restore
• Full backup
• incremental backup