Installing SQL database in Azure

From Azure portal Click SQL Databases-new SQL Database-click on Server-Create new server-enter server name and credentials

 

Select Pricing Tier

Select tier

 

 

After database is created go to Connection String to see string for connecting to database

 

Connecting to the database

in DB settings click Query editor (preview)-Login

 

Enter credentials

 

Enter some T-SQL query and click Run

 

Firewall settings

On SQL database click Overview-Set server firewall

Add client IP-rule for allowing connection from Your local machine will be allowed to the SQL database

Configuring Geo-Replication

Active geo-replication enables configuring up to four readable secondary databases in the same or different data center locations (regions). Secondary databases are available for querying and for failover if there is a data center outage or the inability to connect to the primary database.On database settings click Geo-Replication, with blue check mark is selected current database region, click on any green circle where you want to create read-only database copy

 

Next windows will appear

 

SQLServer security settings

On SQL server settings click Advanced Threat Protection-Enable Advanced Threat Protection-click On-save

Click on storage details to configure Retentions

 

Click Threat Detection Type to select what you want to audit

 

Masking data

If you want to hide some database column, on database settings click Dynamic Data Masking

 

Creating Elastic Pool

It’s technique where you can place multiple Azure databases in to a pool where they all share resources. The pool is configured to over a maximum and minimum amount of computing resources. Microsoft has defined these available resources as a Database Throughput Unit, or DTU. In the case of elastic pools, they are defined as an Elastic Database Throughput Unit, or eDTU. DTUs and eDTUs are calculated essentially the same and are determined through a calculation of measured disk reads, disk writes, processor time and transaction log flushes.

Again, click on the SQL database

 

From overview click New Pool

 

 

 

Adding database to Pool

 

Once pools is created,click Configure

Click Database

 

select database

 

 

 

 

 

 

 

 

Advertisement