Database Services in Azure
-
Typical activities involved in creating a Database
- Create an physical/virtual machine
- Install the Database Software
- Import the Data (Optional)
-
Activities on the Created Database
- Back up of the database
- Replications of the database
- Performance Tuning
- User Management
- Applications/user accessing the data for CRUD
-
Possibilities in Azure are
- Create an Azure VM and perform all of the above activities (Un-managed)
- Azure Gives Managed Databases where
- Creating a Database is managed by Azure
- Backups & Replications will be done Azure you have to configure when and where
- For Microsoft SQL Performance Tuning can be automated
- Azure Supports integrated Azure AD Authentication to Databases
-
In the Relational Databases, Azure supports Managed options for
- Microsoft SQL Server
- mySQL
- PostgreSql
Azure SQL
-
Is family of managed SQL Server database engine in Azure Cloud
-
Let’s create one Azure SQL Database
-
Navigate to Home => All Services => Select Databases
-
Navigate to Home => All Services => Marketplace and search for oracle
-
Azure SQL is offered using
- Azure SQL Database
- Azure SQL Managed Instance
- SQL Server on Azure VMs
Azure SQL Database
- Database as a service offering from Azure.
- This also offers serverless compute.
- This is Platform as a Service offering of Microsoft SQL Server
- The following deployment options are provided
- A single database
- An elastic pool