Introduction
A managed cloud database offered as part of Microsoft Azure is the Microsoft Azure SQL Database. A cloud database is a database that is accessible as a service and is run on a cloud computing platform. The scalability, backup, and high availability of the database are managed by managed database services.
Select the Azure SQL Database
Open the azure SQL portal and select the SQL Database Option
Select the Basic Setting Option
Select the Subscription you want to use for creating Azure SQL Instance
Create the New SQL Server
Select the create new SQL Server Option.
Give the name to the server.
Select the Authentication Type
Create the Username and Password for Azure SQL Server Instance and click Ok.
Select the Compute and Storage
We will use this Instance for testing purposes, so we will select the Basic Option.
Now you can see that in the given picture
Now Hit the Apply Button
Backup storage redundancy
Now Select the Backup Redundancy Option
Now Select the Networking Option
Configure network access and connectivity for your server. The configuration selected below will apply to the selected server 'azure-SQL-server-demo' and all databases it manages.
Select the Security Option
Protect your data using Microsoft Defender for SQL, a unified security package including vulnerability assessment and advanced threat protection for your server.
Select the Additional Setting Option
Customize additional configuration parameters, including collation & sample data.
Data source
Start with a blank database, restore from a backup, or select sample data to populate your new database.
Database collation
Database collation defines the rules that sort and compare data and cannot be changed after database creation. The default database collation is SQL_Latin1_General_CP1_CI_AS.
Maintenance window
Select a preferred maintenance window from the drop-down. Please note, during a maintenance event, Azure SQL Database is fully available and accessible. Still, some maintenance updates require a failover as Azure takes SQL DB instances offline for a brief time to apply the maintenance updates. If the database is part of the elastic pool, the maintenance configuration of the elastic pool will be applied.
Select the Tag Option
Tags are name/value pairs that enable you to categorize and view consolidated billing by applying the same tag to multiple resources and resource groups.
Review and Create the Option
Review All your Settings and Hit the Review and Create Options.
Deployment Done
Now we can Use Our Azure Cloud Database and SQL Server Instance with Any Back End Technology that Supports Azure SQL.
Conclusion
A managed cloud database offered as part of Microsoft Azure is the Microsoft Azure SQL Database. A cloud database is a database that is accessible as a service and is run on a cloud computing platform. The scalability, backup, and high availability of the database are managed by managed database services.
Join the conversation! Your thoughts help the community grow.