The Get-AzSqlServer cmdlet retrieves information about Azure SQL Servers.
Get-AzSqlServer <ServerName> -ResourceGroupName <ResourceGroupName>
This cmdlet retrieves information about a specified Azure SQL Server. It requires the server name and the resource group name to identify the server.
Get-AzSqlServer -ServerName "my-sql-server" -ResourceGroupName "my-resource-group"
This example retrieves information about a SQL Server named "my-sql-server" located in the resource group named "my-resource-group".
-ServerName (required) The name of the Azure SQL Server.
                -ResourceGroupName (required) The name of the resource group that contains the Azure SQL Server.
                Name
ServerFaultUrl
ServiceFabricInfo
ServicePrincipal
The cmdlet returns a set of properties about the SQL Server. The properties returned can vary depending on the configuration of the server and the available modules.