How to Work with Microsoft Azure Cloud SQL Service
Tags: webdev, javascript, programming, devops
Published: 2023-03-30 15:36:56

## 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](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/evi44nlwzgha06h7vflh.png)

## Select the Basic Setting Option
Select the Subscription you want to use for creating Azure SQL Instance 

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/jh6l5ybpzqn58ci4r88y.png)


![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/9zmmy5y4t2l3io5x618w.png)
## Create the New SQL Server 
Select the create new SQL Server Option.

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/5xc6rniv633w3y1wuzw5.png)
Give the name to the server 

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/h45sblpwomgu8dun8sb9.png)
## Select the Authentication Type
Create the Username and Password for Azure SQL Server Instance and click Ok


![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/35e7r4mxe511hoxpkqtf.png)

## Select the Compute and Storage 

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/fg5nl6l4v2zvstgdhiq8.png)


![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/zqlpndr7kiehjr1qdsfa.png)

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](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/byece4pca1f2l8721dvh.png)
Now Hit the Apply Button 

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/rv0msfoelxq2v6sjs3zh.png)
## Backup storage redundancy
Now Select the Backup Redundancy Option

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/lmrage9chsbsc4nkbdyx.png)
## 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](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/ngv40lika5oz7uuoxl8r.png)
## 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](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/wcekj5b7q1kmfhvir2ub.png)
## 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](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/q9pc44p2tctieoix2otq.png)
## 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](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/xde6xq90ix85j0btzerg.png)

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


![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/5uxyhsy6ldc1bt5y8hs8.png)
## 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](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/omefv1d0xgenml3kgs6x.png)
## 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.