Category : Az.Sql

Module Name:

Az.Sql

Module Description:

Microsoft Azure PowerShell – SQL service cmdlets for Azure Resource Manager in Windows PowerShell and PowerShell Core.

For more information on SQL, please visit the following: https://docs.microsoft.com/azure/sql-database/

Newest Module Version:

2.1.2

Previous Module Version:

2.1.0

Releasenotes:

* Fix vulnerability assessment set baseline cmdlets functionality to work on master db for azure database and limit it on managed instance system databases.
* Fix an error when creating SQL instance failover group

Framework Version:

4.7.2

Author:

Microsoft Corporation

Commands

Add-AzSqlDatabaseToFailoverGroup
Add-AzSqlElasticJobStep
Add-AzSqlElasticJobTarget
Add-AzSqlInstanceKeyVaultKey
Add-AzSqlManagedInstanceTransparentDataEncryptionCertificate
Add-AzSqlServerKeyVaultKey
Add-AzSqlServerTransparentDataEncryptionCertificate
Clear-AzSqlDatabaseAdvancedThreatProtectionSetting
Clear-AzSqlDatabaseVulnerabilityAssessmentRuleBaseline
Clear-AzSqlDatabaseVulnerabilityAssessmentSetting
Clear-AzSqlInstanceDatabaseVulnerabilityAssessmentRuleBaseline
Clear-AzSqlInstanceDatabaseVulnerabilityAssessmentSetting
Clear-AzSqlInstanceVulnerabilityAssessmentSetting
Clear-AzSqlServerAdvancedThreatProtectionSetting
Clear-AzSqlServerVulnerabilityAssessmentSetting
Convert-AzSqlDatabaseVulnerabilityAssessmentScan
Convert-AzSqlInstanceDatabaseVulnerabilityAssessmentScan
Disable-AzSqlDatabaseSensitivityRecommendation
Disable-AzSqlInstanceAdvancedDataSecurity
Disable-AzSqlInstanceDatabaseSensitivityRecommendation
Disable-AzSqlServerAdvancedDataSecurity
Disable-AzSqlServerAdvancedThreatProtection
Enable-AzSqlDatabaseSensitivityRecommendation
Enable-AzSqlInstanceAdvancedDataSecurity
Enable-AzSqlInstanceDatabaseSensitivityRecommendation
Enable-AzSqlServerAdvancedDataSecurity
Enable-AzSqlServerAdvancedThreatProtection
Get-AzSqlCapability
Get-AzSqlDatabase
Get-AzSqlDatabaseActivity
Get-AzSqlDatabaseAdvancedThreatProtectionSetting
Get-AzSqlDatabaseAdvisor
Get-AzSqlDatabaseAudit
Get-AzSqlDatabaseBackupLongTermRetentionPolicy
Get-AzSqlDatabaseBackupShortTermRetentionPolicy
Get-AzSqlDatabaseDataMaskingPolicy
Get-AzSqlDatabaseDataMaskingRule
Get-AzSqlDatabaseExpanded
Get-AzSqlDatabaseFailoverGroup
Get-AzSqlDatabaseGeoBackup
Get-AzSqlDatabaseGeoBackupPolicy
Get-AzSqlDatabaseImportExportStatus
Get-AzSqlDatabaseIndexRecommendation
Get-AzSqlDatabaseInstanceFailoverGroup
Get-AzSqlDatabaseLongTermRetentionBackup
Get-AzSqlDatabaseLongTermRetentionPolicy
Get-AzSqlDatabaseRecommendedAction
Get-AzSqlDatabaseReplicationLink
Get-AzSqlDatabaseRestorePoint
Get-AzSqlDatabaseSensitivityClassification
Get-AzSqlDatabaseSensitivityRecommendation
Get-AzSqlDatabaseServerAuditingPolicy
Get-AzSqlDatabaseThreatDetectionSetting
Get-AzSqlDatabaseTransparentDataEncryption
Get-AzSqlDatabaseTransparentDataEncryptionActivity
Get-AzSqlDatabaseUpgradeHint
Get-AzSqlDatabaseVulnerabilityAssessmentRuleBaseline
Get-AzSqlDatabaseVulnerabilityAssessmentScanRecord
Get-AzSqlDatabaseVulnerabilityAssessmentSetting
Get-AzSqlDeletedDatabaseBackup
Get-AzSqlDeletedInstanceDatabaseBackup
Get-AzSqlElasticJob
Get-AzSqlElasticJobAgent
Get-AzSqlElasticJobCredential
Get-AzSqlElasticJobExecution
Get-AzSqlElasticJobStep
Get-AzSqlElasticJobStepExecution
Get-AzSqlElasticJobTargetExecution
Get-AzSqlElasticJobTargetGroup
Get-AzSqlElasticPool
Get-AzSqlElasticPoolActivity
Get-AzSqlElasticPoolAdvisor
Get-AzSqlElasticPoolDatabase
Get-AzSqlElasticPoolRecommendation
Get-AzSqlElasticPoolRecommendedAction
Get-AzSqlInstance
Get-AzSqlInstanceActiveDirectoryAdministrator
Get-AzSqlInstanceAdvancedDataSecurityPolicy
Get-AzSqlInstanceDatabase
Get-AzSqlInstanceDatabaseBackupShortTermRetentionPolicy
Get-AzSqlInstanceDatabaseGeoBackup
Get-AzSqlInstanceDatabaseSensitivityClassification
Get-AzSqlInstanceDatabaseSensitivityRecommendation
Get-AzSqlInstanceDatabaseVulnerabilityAssessmentRuleBaseline
Get-AzSqlInstanceDatabaseVulnerabilityAssessmentScanRecord
Get-AzSqlInstanceDatabaseVulnerabilityAssessmentSetting
Get-AzSqlInstanceKeyVaultKey
Get-AzSqlInstancePool
Get-AzSqlInstancePoolUsage
Get-AzSqlInstanceTDEProtector
Get-AzSqlInstanceTransparentDataEncryptionProtector
Get-AzSqlInstanceVulnerabilityAssessmentSetting
Get-AzSqlServer
Get-AzSqlServerActiveDirectoryAdministrator
Get-AzSqlServerAdvancedDataSecurityPolicy
Get-AzSqlServerAdvancedThreatProtectionSetting
Get-AzSqlServerAdvisor
Get-AzSqlServerAudit
Get-AzSqlServerCommunicationLink
Get-AzSqlServerDisasterRecoveryConfiguration
Get-AzSqlServerDisasterRecoveryConfigurationActivity
Get-AzSqlServerDnsAlias
Get-AzSqlServerFirewallRule
Get-AzSqlServerKeyVaultKey
Get-AzSqlServerRecommendedAction
Get-AzSqlServerServiceObjective
Get-AzSqlServerThreatDetectionSetting
Get-AzSqlServerTransparentDataEncryptionProtector
Get-AzSqlServerUpgradeHint
Get-AzSqlServerVirtualNetworkRule
Get-AzSqlServerVulnerabilityAssessmentSetting
Get-AzSqlSyncAgent
Get-AzSqlSyncAgentLinkedDatabase
Get-AzSqlSyncGroup
Get-AzSqlSyncGroupLog
Get-AzSqlSyncMember
Get-AzSqlSyncSchema
Get-AzSqlVirtualCluster
Invoke-AzSqlDatabaseFailover
Invoke-AzSqlElasticPoolFailover
New-AzSqlDatabase
New-AzSqlDatabaseCopy
New-AzSqlDatabaseDataMaskingRule
New-AzSqlDatabaseExport
New-AzSqlDatabaseFailoverGroup
New-AzSqlDatabaseImport
New-AzSqlDatabaseInstanceFailoverGroup
New-AzSqlDatabaseRestorePoint
New-AzSqlDatabaseSecondary
New-AzSqlElasticJob
New-AzSqlElasticJobAgent
New-AzSqlElasticJobCredential
New-AzSqlElasticJobTargetGroup
New-AzSqlElasticPool
New-AzSqlInstance
New-AzSqlInstanceDatabase
New-AzSqlInstancePool
New-AzSqlServer
New-AzSqlServerCommunicationLink
New-AzSqlServerDisasterRecoveryConfiguration
New-AzSqlServerDnsAlias
New-AzSqlServerFirewallRule
New-AzSqlServerVirtualNetworkRule
New-AzSqlSyncAgent
New-AzSqlSyncAgentKey
New-AzSqlSyncGroup
New-AzSqlSyncMember
Remove-AzSqlDatabase
Remove-AzSqlDatabaseAudit
Remove-AzSqlDatabaseDataMaskingRule
Remove-AzSqlDatabaseFailoverGroup
Remove-AzSqlDatabaseFromFailoverGroup
Remove-AzSqlDatabaseInstanceFailoverGroup
Remove-AzSqlDatabaseLongTermRetentionBackup
Remove-AzSqlDatabaseRestorePoint
Remove-AzSqlDatabaseSecondary
Remove-AzSqlDatabaseSensitivityClassification
Remove-AzSqlDatabaseServerAuditing
Remove-AzSqlDatabaseThreatDetectionSetting
Remove-AzSqlElasticJob
Remove-AzSqlElasticJobAgent
Remove-AzSqlElasticJobCredential
Remove-AzSqlElasticJobStep
Remove-AzSqlElasticJobTarget
Remove-AzSqlElasticJobTargetGroup
Remove-AzSqlElasticPool
Remove-AzSqlInstance
Remove-AzSqlInstanceActiveDirectoryAdministrator
Remove-AzSqlInstanceDatabase
Remove-AzSqlInstanceDatabaseSensitivityClassification
Remove-AzSqlInstanceKeyVaultKey
Remove-AzSqlInstancePool
Remove-AzSqlServer
Remove-AzSqlServerActiveDirectoryAdministrator
Remove-AzSqlServerAudit
Remove-AzSqlServerCommunicationLink
Remove-AzSqlServerDisasterRecoveryConfiguration
Remove-AzSqlServerDnsAlias
Remove-AzSqlServerFirewallRule
Remove-AzSqlServerKeyVaultKey
Remove-AzSqlServerThreatDetectionSetting
Remove-AzSqlServerVirtualNetworkRule
Remove-AzSqlSyncAgent
Remove-AzSqlSyncGroup
Remove-AzSqlSyncMember
Remove-AzSqlVirtualCluster
Restore-AzSqlDatabase
Restore-AzSqlInstanceDatabase
Resume-AzSqlDatabase
Set-AzSqlDatabase
Set-AzSqlDatabaseAdvisorAutoExecuteStatus
Set-AzSqlDatabaseAudit
Set-AzSqlDatabaseBackupLongTermRetentionPolicy
Set-AzSqlDatabaseBackupShortTermRetentionPolicy
Set-AzSqlDatabaseDataMaskingPolicy
Set-AzSqlDatabaseDataMaskingRule
Set-AzSqlDatabaseFailoverGroup
Set-AzSqlDatabaseGeoBackupPolicy
Set-AzSqlDatabaseInstanceFailoverGroup
Set-AzSqlDatabaseLongTermRetentionPolicy
Set-AzSqlDatabaseRecommendedActionState
Set-AzSqlDatabaseSecondary
Set-AzSqlDatabaseSensitivityClassification
Set-AzSqlDatabaseServerAuditingPolicy
Set-AzSqlDatabaseThreatDetectionSetting
Set-AzSqlDatabaseTransparentDataEncryption
Set-AzSqlDatabaseVulnerabilityAssessmentRuleBaseline
Set-AzSqlElasticJob
Set-AzSqlElasticJobAgent
Set-AzSqlElasticJobCredential
Set-AzSqlElasticJobStep
Set-AzSqlElasticPool
Set-AzSqlElasticPoolAdvisorAutoExecuteStatus
Set-AzSqlElasticPoolRecommendedActionState
Set-AzSqlInstance
Set-AzSqlInstanceActiveDirectoryAdministrator
Set-AzSqlInstanceDatabaseBackupShortTermRetentionPolicy
Set-AzSqlInstanceDatabaseSensitivityClassification
Set-AzSqlInstanceDatabaseVulnerabilityAssessmentRuleBaseline
Set-AzSqlInstancePool
Set-AzSqlInstanceTDEProtector
Set-AzSqlInstanceTransparentDataEncryptionProtector
Set-AzSqlServer
Set-AzSqlServerActiveDirectoryAdministrator
Set-AzSqlServerAdvisorAutoExecuteStatus
Set-AzSqlServerAudit
Set-AzSqlServerDisasterRecoveryConfiguration
Set-AzSqlServerDnsAlias
Set-AzSqlServerFirewallRule
Set-AzSqlServerRecommendedActionState
Set-AzSqlServerThreatDetectionSetting
Set-AzSqlServerTransparentDataEncryptionProtector
Set-AzSqlServerVirtualNetworkRule
Start-AzSqlDatabaseExecuteIndexRecommendation
Start-AzSqlDatabaseVulnerabilityAssessmentScan
Start-AzSqlElasticJob
Start-AzSqlInstanceDatabaseVulnerabilityAssessmentScan
Start-AzSqlSyncGroupSync
Stop-AzSqlDatabaseActivity
Stop-AzSqlDatabaseExecuteIndexRecommendation
Stop-AzSqlElasticJob
Stop-AzSqlElasticPoolActivity
Stop-AzSqlSyncGroupSync
Suspend-AzSqlDatabase
Switch-AzSqlDatabaseFailoverGroup
Switch-AzSqlDatabaseInstanceFailoverGroup
Update-AzSqlDatabaseAdvancedThreatProtectionSetting
Update-AzSqlDatabaseVulnerabilityAssessmentSetting
Update-AzSqlInstanceDatabaseVulnerabilityAssessmentSetting
Update-AzSqlInstanceVulnerabilityAssessmentSetting
Update-AzSqlServerAdvancedThreatProtectionSetting
Update-AzSqlServerVulnerabilityAssessmentSetting
Update-AzSqlSyncGroup
Update-AzSqlSyncMember
Update-AzSqlSyncSchema
Use-AzSqlDatabaseServerAuditingPolicy