How To Work With Microsoft Azure Cloud SQL Service

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.