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
