SqlServer Interface

Package:

com.microsoft.azure.management.sql

Maven Artifact:

com.microsoft.azure:azure-mgmt-sql:1.41.4

Implements

GroupableResource<com.microsoft.azure.management.sql.implementation.SqlServerManager,com.microsoft.azure.management.sql.implementation.ServerInner> Refreshable<SqlServer> Updatable<Update>

public interface SqlServer
extends GroupableResource<com.microsoft.azure.management.sql.implementation.SqlServerManager,com.microsoft.azure.management.sql.implementation.ServerInner>, Refreshable<SqlServer>, Updatable<Update>

An immutable client-side representation of an Azure SQL Server.

Method Summary

Modifier and Type	Method and Description
abstract java.lang.String	administratorLogin()
abstract SqlDatabaseActionsDefinition	databases()
abstract SqlServerDnsAliasActionsDefinition	dnsAliases()
abstract SqlElasticPoolActionsDefinition	elasticPools()
abstract SqlFirewallRule	enableAccessFromAzureServices() Sets the Azure services default access to this server to true.
abstract SqlEncryptionProtectorActionsDefinition	encryptionProtectors()
abstract SqlFailoverGroupActionsDefinition	failoverGroups()
abstract SqlFirewallRuleActionsDefinition	firewallRules()
abstract java.lang.String	fullyQualifiedDomainName()
abstract SqlActiveDirectoryAdministrator	getActiveDirectoryAdministrator() Gets the Active Directory administrator for this server.
abstract SqlServerAutomaticTuning	getServerAutomaticTuning() Gets a SQL server automatic tuning state and options.
abstract ServiceObjective	getServiceObjective(String serviceObjectiveName) Gets the information on a particular Sql Server Service Objective.
abstract boolean	isManagedServiceIdentityEnabled()
abstract java.lang.String	kind()
abstract java.util.Map<java.lang.String,RecommendedElasticPool>	listRecommendedElasticPools() Returns all the recommended elastic pools for the server.
abstract java.util.List<SqlRestorableDroppedDatabase>	listRestorableDroppedDatabases()
abstract rx.Observable<SqlRestorableDroppedDatabase>	listRestorableDroppedDatabasesAsync()
abstract java.util.List<ServiceObjective>	listServiceObjectives()
abstract java.util.List<ServerMetric>	listUsageMetrics()
abstract java.util.List<ServerMetric>	listUsages()
abstract IdentityType	managedServiceIdentityType()
abstract void	removeAccessFromAzureServices() Sets the Azure services default access to this server to false.
abstract void	removeActiveDirectoryAdministrator() Removes the Active Directory administrator from this server.
abstract SqlServerKeyActionsDefinition	serverKeys()
abstract SqlServerSecurityAlertPolicyActionsDefinition	serverSecurityAlertPolicies()
abstract SqlActiveDirectoryAdministrator	setActiveDirectoryAdministrator(String userLogin, String id) Sets an Active Directory administrator to this server.
abstract java.lang.String	state()
abstract java.lang.String	systemAssignedManagedServiceIdentityPrincipalId()
abstract java.lang.String	systemAssignedManagedServiceIdentityTenantId()
abstract java.lang.String	version()
abstract SqlVirtualNetworkRuleActionsDefinition	virtualNetworkRules()

Method Details

administratorLogin

public abstract String administratorLogin()

Returns:

the administrator login user name for the SQL Server

databases

public abstract SqlDatabaseOperations.SqlDatabaseActionsDefinition databases()

Returns:

entry point to manage Databases for this SQL server

dnsAliases

public abstract SqlServerDnsAliasOperations.SqlServerDnsAliasActionsDefinition dnsAliases()

Returns:

the entry point to manage SQL Server DNS aliases for this server

elasticPools

public abstract SqlElasticPoolOperations.SqlElasticPoolActionsDefinition elasticPools()

Returns:

the entry point to manage the SQL Elastic Pools for this server

enableAccessFromAzureServices

public abstract SqlFirewallRule enableAccessFromAzureServices()

Sets the Azure services default access to this server to true.

A firewall rule named "AllowAllWindowsAzureIps" with the start IP "0.0.0.0" will be added to the SQL server if one does not exist.

Returns:

the SQL Firewall rule

encryptionProtectors

public abstract SqlEncryptionProtectorOperations.SqlEncryptionProtectorActionsDefinition encryptionProtectors()

Returns:

the entry point to manage SQL Encryption Protector for this server

failoverGroups

public abstract SqlFailoverGroupOperations.SqlFailoverGroupActionsDefinition failoverGroups()

Returns:

the entry point to manage SQL Failover Group for this server

firewallRules

public abstract SqlFirewallRuleOperations.SqlFirewallRuleActionsDefinition firewallRules()

Returns:

the entry point to manage SQL Firewall rules for this server

fullyQualifiedDomainName

public abstract String fullyQualifiedDomainName()

Returns:

fully qualified name of the SQL Server

getActiveDirectoryAdministrator

public abstract SqlActiveDirectoryAdministrator getActiveDirectoryAdministrator()

Gets the Active Directory administrator for this server.

Returns:

a representation of a SQL Server Active Directory administrator object (null if one is not set)

getServerAutomaticTuning

public abstract SqlServerAutomaticTuning getServerAutomaticTuning()

Gets a SQL server automatic tuning state and options.

Returns:

the SQL server automatic tuning state and options

getServiceObjective

public abstract ServiceObjective getServiceObjective(String serviceObjectiveName)

Gets the information on a particular Sql Server Service Objective.

Parameters:

serviceObjectiveName - name of the service objective to be fetched

Returns:

information of the service objective

isManagedServiceIdentityEnabled

public abstract boolean isManagedServiceIdentityEnabled()

Returns:

true if Managed Service Identity is enabled for the SQL server

kind

public abstract String kind()

Returns:

the SQL Server "kind"

listRecommendedElasticPools

public abstract Map listRecommendedElasticPools()

Returns all the recommended elastic pools for the server.

Returns:

list of recommended elastic pools for the server

listRestorableDroppedDatabases

public abstract List listRestorableDroppedDatabases()

Returns:

the list of all restorable dropped databases

listRestorableDroppedDatabasesAsync

public abstract Observable listRestorableDroppedDatabasesAsync()

Returns:

the list of all restorable dropped databases

listServiceObjectives

public abstract List listServiceObjectives()

Returns:

the list of information on all service objectives

listUsageMetrics

public abstract List listUsageMetrics()

Returns:

returns the list of usage metrics for an Azure SQL Server

listUsages

public abstract List listUsages()

Returns:

returns the list of usages (ServerMetric) of Azure SQL Server

managedServiceIdentityType

public abstract IdentityType managedServiceIdentityType()

Returns:

the type of Managed Service Identity used for the SQL server.

removeAccessFromAzureServices

public abstract void removeAccessFromAzureServices()

Sets the Azure services default access to this server to false.

The firewall rule named "AllowAllWindowsAzureIps" will be removed from the SQL server.

removeActiveDirectoryAdministrator

public abstract void removeActiveDirectoryAdministrator()

Removes the Active Directory administrator from this server.

serverKeys

public abstract SqlServerKeyOperations.SqlServerKeyActionsDefinition serverKeys()

Returns:

the entry point to manage SQL Server Keys for this server

serverSecurityAlertPolicies

public abstract SqlServerSecurityAlertPolicyOperations.SqlServerSecurityAlertPolicyActionsDefinition serverSecurityAlertPolicies()

Returns:

the entry point to manage SQL Server Security Alert Policy for this server

setActiveDirectoryAdministrator

public abstract SqlActiveDirectoryAdministrator setActiveDirectoryAdministrator(String userLogin, String id)

Sets an Active Directory administrator to this server.

Azure Active Directory authentication allows you to centrally manage identity and access to your Azure SQL Database V12.

Parameters:

userLogin - the user or group login; it can be the name or the email address

id - the user or group unique ID

Returns:

a representation of a SQL Server Active Directory administrator object

state

public abstract String state()

Returns:

the state of the server.

systemAssignedManagedServiceIdentityPrincipalId

public abstract String systemAssignedManagedServiceIdentityPrincipalId()

Returns:

the System Assigned (Local) Managed Service Identity specific Active Directory service principal ID assigned to the SQL server.

systemAssignedManagedServiceIdentityTenantId

public abstract String systemAssignedManagedServiceIdentityTenantId()

Returns:

the System Assigned (Local) Managed Service Identity specific Active Directory tenant ID assigned to the SQL server.

version

public abstract String version()

Returns:

the SQL Server version

virtualNetworkRules

public abstract SqlVirtualNetworkRuleOperations.SqlVirtualNetworkRuleActionsDefinition virtualNetworkRules()

Returns:

the entry point to manage SQL Virtual Network Rule for this server