#    
## Create an Azure SQL Server
1. Install the latest version 
 of PowerShell. 

  * PowerShell `7.0.6 LTS`, PowerShell `7.1.3`, or `higher` is recommended by Microsoft.
  * We can check the PowerShell version with the following command.
```
$PSVersionTable.PSVersion
```

We can use the below terminal to run the PowerShell commands.

>**Note:** It takes a minute to start and install necessary things when we connect to the terminal for the first time. We'll have to wait till it initializes PowerShell.


2. Set the Execution Policy. In a  Windows-based system, it is necessary to set. In UNIX-based systems, it may not work, nor is it required.
```
Set-ExecutionPolicy -ExecutionPolicy RemoteSigned -Scope CurrentUser
```

We can check the execution policy with the following command.
```
Get-ExecutionPolicy -List
```

3. Install the `Az` module.
```
Install-Module -Name Az -Scope CurrentUser -Repository PSGallery -Force
```

4. Login into your account with the following command.

It will provide a link that can be opened in the browser, where we enter the code that has been provided.
```
Connect-AzAccount -UseDeviceAuthentication
```
After successfully logging in, it will print our `Account`, `SubscriptionName`, `TenantId`, and `Environment`.

We've set up everything that's needed to create an Azure SQL Server using PowerShell.

5. Create an Azure SQL server using the following command.

```
New-AzSqlServer -ResourceGroupName "demoRG" -Location "Central US" -ServerName "demosvr" -ServerVersion "12.0" -SqlAdministratorCredentials (Get-Credential)
```

In the above command, we see the following: 
* Cmdlet `New-AzSqlServer` creates an Azure SQL server.
* `demoRG` is the resource group name where our SQL server resource will reside. `demoRG` must be created before executing this command.
* SQL server will be created at the location `Central US`.
* Provide the server name as  `demosvr`.
* Provide the SQL Server version.
* Once the command is executed, `(Get-Credential` asks for credentials.


It will take some time to create a SQL server and print the details when it is created.

How to create an Azure SQL server using PowerShell

Install PowerShell, set Execution Policy, install Az module, authenticate, then use `New-AzSqlServer` to create an Azure SQL server.