Az.Sql

Author(s)

• Microsoft Corporation

Tags

Azure ResourceManager ARM Sql Database

Cmdlets

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

PSEditions

Core Desktop

Dependencies

• • Az.Accounts (>= 2.12.0)

Release Notes

* Fixed identity assignment in 'Set-AzSqlDatabase' cmdlet
* Added new parameters to 'New-AzSqlDatabase', 'Get-AzSqlDatabase', 'Set-AzSqlDatabase', 'New-AzSqlDatabaseCopy', 'New-AzSqlDatabaseSecondary' cmdlets
  - AssignIdentity
  - EncryptionProtector
  - UserAssignedIdentityId
  - KeyList
  - KeysToRemove
  - FederatedClientId
* Added 'ExpandKeyList' and 'KeysFilter' parameters to 'Get-AzSqlDatabaseGeoBackup' and 'Get-SqlDeletedDatabaseBackup'
* Added new cmdlets for Per DB CMK
  - 'Revalidate-AzSqlDatabaseTransparentDataEncryptionProtector'
  - 'Revert-AzSqlDatabaseTransparentDataEncryptionProtector'
  - 'Revalidate-AzSqlServerTransparentDataEncryptionProtector'
  - 'Revalidate-AzSqlInstanceTransparentDataEncryptionProtector'
* Added an optional parameter 'SecondaryType' to:
   'Set-AzSqlDatabaseInstanceFailoverGroup'
   'New-AzSqlDatabaseInstanceFailoverGroup'