Creating SQL Database

This section provides step-by-step instructions on how to create an Azure SQL database.

Azure SQL Database is a comprehensive platform as a service (PaaS) database engine that takes care of various database management functions, including upgrading, patching, backups, and monitoring, without requiring user intervention. It operates on the latest stable version of the SQL Server database engine and patched OS, ensuring 99.99% availability at all times.

To create an Azure SQL database

1. Sign in to the Azure Portal.
2. In the Search box, search for SQL database. The SQL databases pane appears.
3. Under SQL databases, click Create.

The Create SQL database pane appears.

Basics

You can use the Basics pane to create SQL database with your preferred configurations.

To configure basics

1. Under Project details, do the following:
   1. In the Subscription list, choose the required subscription.
   2. In the Resource group list, choose the required resource group.
   3. If you do not have one, click Create new, enter the name, and click OK.
2. Under Database details, do the following:
   1. In the Database name box, type database name.
   2. In the Server list, click Create new.

The Create SQL Database server pane appears.

1. Under Server details, in the Server name box, type a server name.
2. In the Location list, choose the default location.
3. Under Authentication, for Authentication method option, choose the required authentication.
4. Click OK.
5. The Create SQL Database – Basics pane appears.
6. Under Backup storage redundancy, click the required option.
7. Click Next : Networking >.

The Networking pane appears.

Networking

You can use the Networking pane to configure network connection and connection policy.

To configure Networking

1. Under Network connectivity, click the required connectivity method.
2. Under Connection policy, click required policy.
3. Under Encrypted connections, in the Minimum TLS version list, choose the required TLS version.
4. Click Next : Security >.

The Security pane appears.

Security

You can use the Security pane to configure the following:

To configure Security

1. Choose the required options in the Security
   1. Microsoft Defender for SQL: Whether to enable Microsoft defender for SQL.
   2. Ledger: Allows you to configure ledger.
   3. Identity: Allows you to configure identities.
   4. Transparent data encryption: Allows you to configure transparent data encryption.
2. Click Next : Additional settings.

The Additional settings pane appears.

Additional settings

You can use the Additional settings pane to configure parameters including database collation and maintenance window.

To configure additional settings

1. Choose the required options or continue with the default values.
2. Click Next : Tags>.

The Tags pane appears.

Tags

To create tags

1. In the Name box, enter a name for the tag.
2. In the Value box, enter a value.
3. Choose the number of resources from the Resource.
4. Click Next : Review + create >.

The Review + create pane appears.

Review + create

Review all the SQL database configuration details and create.

1. Review the details of the SQL database configuration and then click Create.

The newly created SQL database appears in the SQL databases pane.