DEV Community

Sardar Mudassar Ali Khan
Sardar Mudassar Ali Khan

Posted on • Edited on

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

Image description

Select the Basic Setting Option

Select the Subscription you want to use for creating Azure SQL Instance

Image description

Image description

Create the New SQL Server

Select the create new SQL Server Option.

Image description
Give the name to the server

Image description

Select the Authentication Type

Create the Username and Password for Azure SQL Server Instance and click Ok

Image description

Select the Compute and Storage

Image description

Image description

We will use this Instance for testing Purposes so we will select the Basic Option
Now you can see that in the given picture.

Image description
Now Hit the Apply Button

Image description

Backup storage redundancy

Now Select the Backup Redundancy Option

Image description

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.

Image description

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.

Image description

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 but some of the 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.

Image description

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.

Image description

Review and Create the Option

Review All your Settings and Hit the Review and Create Options.

Image description

Deployment Done

Now we can Use Our Azure Cloud Database and SQL Server Instance with Any Back End Technology that Supports Azure SQL.

Image description

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.

Top comments (0)