AzureRM.Sql

Author(s)

• Microsoft Corporation

Tags

Azure ResourceManager ARM Sql Database

Cmdlets

Get-AzureRmSqlDatabaseTransparentDataEncryption Get-AzureRmSqlDatabaseTransparentDataEncryptionActivity Set-AzureRmSqlDatabaseTransparentDataEncryption Get-AzureRmSqlDatabaseUpgradeHint Get-AzureRmSqlServerUpgradeHint Get-AzureRmSqlServerServiceObjective Get-AzureRmSqlServerUpgrade Start-AzureRmSqlServerUpgrade Stop-AzureRmSqlServerUpgrade Get-AzureRmSqlServerActiveDirectoryAdministrator Remove-AzureRmSqlServerActiveDirectoryAdministrator Set-AzureRmSqlServerActiveDirectoryAdministrator Get-AzureRmSqlServer New-AzureRmSqlServer Remove-AzureRmSqlServer Set-AzureRmSqlServer Get-AzureRmSqlServerCommunicationLink New-AzureRmSqlServerCommunicationLink Remove-AzureRmSqlServerCommunicationLink Get-AzureRmSqlDatabaseSecureConnectionPolicy Get-AzureRmSqlDatabaseReplicationLink New-AzureRmSqlDatabaseCopy New-AzureRmSqlDatabaseSecondary Remove-AzureRmSqlDatabaseSecondary Set-AzureRmSqlDatabaseSecondary Get-AzureRmSqlElasticPoolRecommendation Get-AzureRmSqlDatabaseIndexRecommendations Start-AzureRmSqlDatabaseExecuteIndexRecommendation Stop-AzureRmSqlDatabaseExecuteIndexRecommendation Get-AzureRmSqlServerFirewallRule New-AzureRmSqlServerFirewallRule Remove-AzureRmSqlServerFirewallRule Set-AzureRmSqlServerFirewallRule Get-AzureRmSqlElasticPool Get-AzureRmSqlElasticPoolActivity Get-AzureRmSqlElasticPoolDatabase New-AzureRmSqlElasticPool Remove-AzureRmSqlElasticPool Set-AzureRmSqlElasticPool Get-AzureRmSqlServerDisasterRecoveryConfiguration Get-AzureRmSqlServerDisasterRecoveryConfigurationActivity New-AzureRmSqlServerDisasterRecoveryConfiguration Remove-AzureRmSqlServerDisasterRecoveryConfiguration Set-AzureRmSqlServerDisasterRecoveryConfiguration Resume-AzureRmSqlDatabase Suspend-AzureRmSqlDatabase Get-AzureRmSqlDatabaseDataMaskingPolicy Get-AzureRmSqlDatabaseDataMaskingRule New-AzureRmSqlDatabaseDataMaskingRule Remove-AzureRmSqlDatabaseDataMaskingRule Set-AzureRmSqlDatabaseDataMaskingPolicy Set-AzureRmSqlDatabaseDataMaskingRule Get-AzureRmSqlCapability Get-AzureRmSqlServerThreatDetectionPolicy Remove-AzureRmSqlServerThreatDetectionPolicy Set-AzureRmSqlServerThreatDetectionPolicy Get-AzureRmSqlDatabaseThreatDetectionPolicy Set-AzureRmSqlDatabaseThreatDetectionPolicy Remove-AzureRmSqlDatabaseThreatDetectionPolicy Get-AzureRmSqlDatabase Get-AzureRmSqlDatabaseActivity Get-AzureRmSqlDatabaseExpanded New-AzureRmSqlDatabase Remove-AzureRmSqlDatabase Set-AzureRmSqlDatabase Get-AzureRmSqlDatabaseImportExportStatus New-AzureRmSqlDatabaseExport New-AzureRmSqlDatabaseImport Get-AzureRmSqlDatabaseGeoBackupPolicy Set-AzureRmSqlDatabaseGeoBackupPolicy Get-AzureRmSqlDatabaseBackupLongTermRetentionPolicy Set-AzureRmSqlDatabaseBackupLongTermRetentionPolicy Get-AzureRmSqlDatabaseLongTermRetentionBackup Remove-AzureRmSqlDatabaseLongTermRetentionBackup Get-AzureRmSqlDeletedDatabaseBackup Get-AzureRmSqlDatabaseGeoBackup Get-AzureRmSqlServerBackupLongTermRetentionVault Restore-AzureRmSqlDatabase Set-AzureRmSqlServerBackupLongTermRetentionVault Get-AzureRmSqlDatabaseRestorePoints Get-AzureRmSqlDatabaseAuditingPolicy Get-AzureRmSqlServerAuditingPolicy Get-AzureRmSqlDatabaseAuditing Get-AzureRmSqlServerAuditing Remove-AzureRmSqlDatabaseAuditing Remove-AzureRmSqlServerAuditing Set-AzureRmSqlDatabaseAuditingPolicy Set-AzureRmSqlServerAuditingPolicy Set-AzureRmSqlDatabaseAuditing Set-AzureRmSqlServerAuditing Use-AzureRmSqlServerAuditingPolicy Get-AzureRmSqlDatabaseRecommendedAction Get-AzureRmSqlElasticPoolRecommendedAction Get-AzureRmSqlServerRecommendedAction Set-AzureRmSqlDatabaseRecommendedActionState Set-AzureRmSqlElasticPoolRecommendedActionState Set-AzureRmSqlServerRecommendedActionState Get-AzureRmSqlElasticPoolAdvisor Get-AzureRmSqlServerAdvisor Set-AzureRmSqlElasticPoolAdvisorAutoExecuteStatus Set-AzureRmSqlServerAdvisorAutoExecuteStatus Get-AzureRmSqlDatabaseAdvisor Set-AzureRmSqlDatabaseAdvisorAutoExecuteStatus Get-AzureRmSqlServerTransparentDataEncryptionProtector Set-AzureRmSqlServerTransparentDataEncryptionProtector Add-AzureRmSqlServerKeyVaultKey Get-AzureRmSqlServerKeyVaultKey Remove-AzureRmSqlServerKeyVaultKey Get-AzureRmSqlDatabaseFailoverGroup New-AzureRmSqlDatabaseFailoverGroup Add-AzureRmSqlDatabaseToFailoverGroup Remove-AzureRmSqlDatabaseFromFailoverGroup Remove-AzureRmSqlDatabaseFailoverGroup Set-AzureRmSqlDatabaseFailoverGroup Switch-AzureRmSqlDatabaseFailoverGroup New-AzureRmSqlSyncGroup Update-AzureRmSqlSyncGroup Get-AzureRmSqlSyncGroup Get-AzureRmSqlSyncGroupLog Remove-AzureRmSqlSyncGroup Update-AzureRmSqlSyncSchema Get-AzureRmSqlSyncSchema Start-AzureRmSqlSyncGroupSync Stop-AzureRmSqlSyncGroupSync New-AzureRmSqlSyncMember Update-AzureRmSqlSyncMember Get-AzureRmSqlSyncMember Remove-AzureRmSqlSyncMember New-AzureRmSqlSyncAgent Get-AzureRmSqlSyncAgent Remove-AzureRmSqlSyncAgent New-AzureRmSqlSyncAgentKey Get-AzureRmSqlSyncAgentLinkedDatabase New-AzureRmSqlServerVirtualNetworkRule Set-AzureRmSqlServerVirtualNetworkRule Get-AzureRmSqlServerVirtualNetworkRule Remove-AzureRmSqlServerVirtualNetworkRule Stop-AzureRmSqlDatabaseActivity Get-AzureRmSqlServerDnsAlias Remove-AzureRmSqlServerDnsAlias New-AzureRmSqlServerDnsAlias Set-AzureRmSqlServerDnsAlias New-AzureRmSqlDatabaseRestorePoint Remove-AzureRmSqlDatabaseRestorePoint Stop-AzureRmSqlElasticPoolActivity Add-AzureRmSqlServerTransparentDataEncryptionCertificate Add-AzureRmSqlManagedInstanceTransparentDataEncryptionCertificate Enable-AzureRmSqlServerAdvancedThreatProtection Disable-AzureRmSqlServerAdvancedThreatProtection Get-AzureRmSqlServerAdvancedThreatProtectionPolicy Update-AzureRmSqlDatabaseVulnerabilityAssessmentSettings Get-AzureRmSqlDatabaseVulnerabilityAssessmentSettings Clear-AzureRmSqlDatabaseVulnerabilityAssessmentSettings Set-AzureRmSqlDatabaseVulnerabilityAssessmentRuleBaseline Get-AzureRmSqlDatabaseVulnerabilityAssessmentRuleBaseline Clear-AzureRmSqlDatabaseVulnerabilityAssessmentRuleBaseline Convert-AzureRmSqlDatabaseVulnerabilityAssessmentScan Get-AzureRmSqlDatabaseVulnerabilityAssessmentScanRecord Start-AzureRmSqlDatabaseVulnerabilityAssessmentScan Get-AzureRmSqlDatabaseBackupShortTermRetentionPolicy Set-AzureRmSqlDatabaseBackupShortTermRetentionPolicy Get-AzureRmSqlDatabaseInstanceFailoverGroup New-AzureRmSqlDatabaseInstanceFailoverGroup Remove-AzureRmSqlDatabaseInstanceFailoverGroup Set-AzureRmSqlDatabaseInstanceFailoverGroup Switch-AzureRmSqlDatabaseInstanceFailoverGroup Get-AzureRmSqlManagedInstance New-AzureRmSqlManagedInstance Remove-AzureRmSqlManagedInstance Set-AzureRmSqlManagedInstance Update-AzureRmSqlManagedInstance Get-AzureRmSqlManagedDatabase New-AzureRmSqlManagedDatabase Remove-AzureRmSqlManagedDatabase Restore-AzureRmSqlManagedDatabase New-AzureRmSqlElasticJobAgent Remove-AzureRmSqlElasticJobAgent Get-AzureRmSqlElasticJobAgent Set-AzureRmSqlElasticJobAgent New-AzureRmSqlElasticJobCredential Get-AzureRmSqlElasticJobCredential Set-AzureRmSqlElasticJobCredential Remove-AzureRmSqlElasticJobCredential New-AzureRmSqlElasticJobTargetGroup Get-AzureRmSqlElasticJobTargetGroup Remove-AzureRmSqlElasticJobTargetGroup Add-AzureRmSqlElasticJobTarget Remove-AzureRmSqlElasticJobTarget New-AzureRmSqlElasticJob Get-AzureRmSqlElasticJob Set-AzureRmSqlElasticJob Remove-AzureRmSqlElasticJob Add-AzureRmSqlElasticJobStep Get-AzureRmSqlElasticJobStep Remove-AzureRmSqlElasticJobStep Set-AzureRmSqlElasticJobStep Start-AzureRmSqlElasticJob Stop-AzureRmSqlElasticJob Get-AzureRmSqlElasticJobExecution Get-AzureRmSqlElasticJobStepExecution Get-AzureRmSqlElasticJobTargetExecution Add-AzureRmSqlManagedInstanceKeyVaultKey Get-AzureRmSqlManagedInstanceKeyVaultKey Remove-AzureRmSqlManagedInstanceKeyVaultKey Get-AzureRmSqlManagedInstanceTransparentDataEncryptionProtector Set-AzureRmSqlManagedInstanceTransparentDataEncryptionProtector

Dependencies

• • AzureRM.Profile (>= 5.6.0)

Release Notes

* New Cmdlets for Management.Sql to allow customers to add TDE keys and set TDE protector for managed instances
  - Add-AzureRmSqlManagedInstanceKeyVaultKey
  - Get-AzureRmSqlManagedInstanceKeyVaultKey
  - Remove-AzureRmSqlManagedInstanceKeyVaultKey
  - Get-AzureRmSqlManagedInstanceTransparentDataEncryptionProtector
  - Set-AzureRmSqlManagedInstanceTransparentDataEncryptionProtector