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

Dependencies

• • AzureRM.Profile (>= 5.3.4)

Release Notes

* Adding Server Advanced Threat Protection support with the following cmdlets:
- Enable-AzureRmSqlServerAdvancedThreatProtection; Disable-AzureRmSqlServerAdvancedThreatProtection; Get-AzureRmSqlServerAdvancedThreatProtectionPolicy
* Adding Vulnerability Assessment support with the following cmdlets:
- Update-AzureRmSqlDatabaseVulnerabilityAssessmentSettings; Get-AzureRmSqlDatabaseVulnerabilityAssessmentSettings; Clear-AzureRmSqlDatabaseVulnerabilityAssessmentSettings
- Set-AzureRmSqlDatabaseVulnerabilityAssessmentRuleBaseline; Get-AzureRmSqlDatabaseVulnerabilityAssessmentRuleBaseline; Clear-AzureRmSqlDatabaseVulnerabilityAssessmentRuleBaseline
- Convert-AzureRmSqlDatabaseVulnerabilityAssessmentScan; Get-AzureRmSqlDatabaseVulnerabilityAssessmentScanRecord; Start-AzureRmSqlDatabaseVulnerabilityAssessmentScan
* Fixed example in Remove-AzureRmSqlServerFirewallRule
* Fix datetime handling incorrectly for non-us base culture in Get-AzureSqlSyncGroupLog
* Updated all help files to include full parameter types and correct input/output types.