Category : AzureRM.Sql

Module Name:

AzureRM.Sql

Module Description:

Microsoft Azure PowerShell – Sql service cmdlets for Azure Resource Manager

Newest Module Version:

4.12.1

Previous Module Version:

Releasenotes:

* Added new cmdlets for CRUD operations on Azure Sql Database Managed Instance and Azure Sql Managed Database
– Get-AzureRmSqlInstance
– New-AzureRmSqlInstance
– Set-AzureRmSqlInstance
– Remove-AzureRmSqlInstance
– Get-AzureRmSqlInstanceDatabase
– New-AzureRmSqlInstanceDatabase
– Restore-AzureRmSqlInstanceDatabase
– Remove-AzureRmSqlInstanceDatabase
* Enabled Extended Auditing Policy management on a server or a database.
– New parameter (PredicateExpression) was added to enable filtering of audit logs.
– Cmdlets were modified to use SQL clients instead of Legacy clients.
– Set-AzureRmSqlServerAuditing.
– Get-AzureRmSqlServerAuditing.
– Set-AzureRmSqlDatabaseAuditing.
– Get-AzureRmSqlDatabaseAuditing.
* Fixed issue with using Update-AzureRmSqlDatabaseVulnerabilityAssessmentSettings with storage account name parameter set

Framework Version:

4.5.2

Author:

Microsoft Corporation

Commands

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