AzureRM.Sql

2.4.0

Microsoft Azure PowerShell - Sql service cmdlets for Azure Resource Manager

Minimum PowerShell version

3.0

There is a newer prerelease version of this module available.
See the version list below for details.

Installation Options

Copy and Paste the following command to install this package using PowerShellGet More Info

Install-Module -Name AzureRM.Sql -RequiredVersion 2.4.0

You can deploy this package directly to Azure Automation. Note that deploying packages with dependencies will deploy all the dependencies to Azure Automation. Learn More

Manually download the .nupkg file to your system's default download location. Note that the file won't be unpacked, and won't include any dependencies. Learn More

Author(s)

Microsoft Corporation

Copyright

Microsoft Corporation. All rights reserved.

Package Details

Owners

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-AzureRmSqlDeletedDatabaseBackup Get-AzureRmSqlDatabaseGeoBackup Get-AzureRmSqlDatabaseBackupLongTermRetentionPolicy Get-AzureRmSqlServerBackupLongTermRetentionVault Restore-AzureRmSqlDatabase Set-AzureRmSqlDatabaseBackupLongTermRetentionPolicy Set-AzureRmSqlServerBackupLongTermRetentionVault Get-AzureRmSqlDatabaseRestorePoints Get-AzureRmSqlDatabaseAuditingPolicy Get-AzureRmSqlServerAuditingPolicy Remove-AzureRmSqlDatabaseAuditing Remove-AzureRmSqlServerAuditing Set-AzureRmSqlDatabaseAuditingPolicy Set-AzureRmSqlServerAuditingPolicy 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

Dependencies

Release Notes

* Added storage properties to cmdlets for Azure SQL threat detection policy management at database and server level
   - StorageAccountName
   - RetentionInDays
* Removed the unsupported param "AuditAction" from Set-AzureSqlDatabaseServerAuditingPolicy
* Added new param "AuditAction" to Set-AzureSqlDatabaseAuditingPolicy
* Fix for showing on GET and persisting Tags on SET (if not given) for Database, Server and Elastic Pool
   - If Tags is used in command it will save tags, if not it will not wipe out tags on resource.
* Fix for showing on GET and persisting Tags on SET (if not given) for Database, Server and Elastic Pool
   - If Tags is used in command it will save tags, if not it will not wipe out tags on resource.
* Changes for "New-AzureRmSqlDatabase", "Set-AzureRmSqlDatabase" and "Get-AzureRmSqlDatabase" cmdlets
   - Adding a new parameter called "ReadScale" for the 3 cmdlets above.
   - The "ReadScale" parameter has 2 possibl values: "Enabled" or "Disabled" to indicate whether the ReadScale option is turned on for the database.
* Functionality of ReadScale Feature.
   - ReadScale is a new feature in SQL Database, which allows the user to enabled/disable routing read-only requests to Geo-secondary Premium databases.
   - This feature allows the customer to scale up/down their read-only workload flexibly, and unlocked more DTUs for the premium database.
   - To configure ReadScale, user simply specify "ReadScale" paramter with "Enabled/Disabled" at database creation with New-AzureRmSqlDatabase cmdlet,

FileList

Version History

Version Downloads Last updated
4.12.2 10,571,774 3/23/2021
4.12.1 6,674,879 11/21/2018
4.11.6-preview 505 11/7/2018
4.11.5 222,086 10/9/2018
4.11.4-preview 176 9/24/2018
4.11.3 402,125 8/29/2018
4.11.1 142,099 8/14/2018
4.11.0 66,789 7/31/2018
4.10.0 91,483 7/3/2018
4.9.0 59,016 7/3/2018
4.8.1-preview 916 6/13/2018
4.8.0-preview 82 6/12/2018
4.7.0-preview 118 6/8/2018
4.6.1 114,316 6/19/2018
4.6.0 78,838 6/5/2018
4.5.0 58,354 5/22/2018
4.5.0-preview 251 5/9/2018
4.4.1 62,910 5/7/2018
4.4.0 446,226 4/10/2018
4.3.1 59,306 3/27/2018
4.3.0 50,801 3/13/2018
4.2.0 195,338 1/31/2018
4.1.1 130,582 12/9/2017
4.0.1 60,164 11/10/2017
4.0.0 37,418 11/8/2017
3.4.1 229,424 10/12/2017
3.4.0 142,500 9/25/2017
3.3.1 83,570 8/16/2017
3.2.1 41,573 7/18/2017
3.2.0 6,340 7/11/2017
3.1.0 42,168 6/8/2017
3.0.1 20,807 5/24/2017
3.0.0 19,553 5/10/2017
2.8.0 51,004 4/5/2017
2.7.0 27,303 3/9/2017
2.6.0 14,884 2/22/2017
2.5.0 28,155 1/18/2017
2.4.0 (current version) 17,312 12/14/2016
2.3.0 27,408 11/2/2016
2.2.0 13,315 9/28/2016
2.1.0 65,661 9/8/2016
2.0.1 7,995 8/10/2016
2.0.0 549 8/8/2016
1.0.11 25,959 7/12/2016
1.0.10 3,452 6/27/2016
1.0.9 6,023 6/1/2016
1.0.8 9,713 5/4/2016
1.0.7 3,661 4/19/2016
1.0.6 5,266 3/30/2016
1.0.5 4,412 3/4/2016
1.0.4.4 15,547 7/8/2017
1.0.4.3 22,490 3/14/2017
1.0.4.2 8,546 1/4/2017
1.0.4.1 122,144 9/8/2016
1.0.4 4,787 2/3/2016
1.0.3 2,856 1/13/2016
1.0.2 1,623 12/16/2015
1.0.1 2,856 11/9/2015
1.0.0 279 11/6/2015
0.10.0 1,813 10/9/2015
Show less