PR from parent

PR from parent

PR from parent branch

PR from parent

pr from parent

PR from parent

pr from parent

pr from parent

PR from parent

PR from parent

PR from parent

PR

PR from parent

PR from parent

PR from parent

PR from parent

-------------
1) ARM cmdlets for SQLVM extension added ( followed DSC's ARM cmdlet pattern )
2) supports configuring auto patching in ARM mode
3) supports configuring auto backup in ARM mode
4) Get sqlvm extension status in ARM mode
5) remove sqlvm extension in ARM mode


Pending Open issues:
------------------
- MAML file generation & help documentation
- adding new functional tests
- follow up with Azure team to check why Extenstion statusus were always returning null in Get-* cmdlet

Testing:
------
Environment: SQLVM created via new Azure portal using ARM

Powershell script used:
-----------------------
Switch-AzureMode -Name AzureResourceManager

$subscriptionName = "__Subscription__"
$vmName = "__vm_name__"
$resourceGroupName = "__resourcegroupName__"


Add-azureaccount
select-azuresubscription -SubscriptionName $subscriptionName

# Get Azure VM created using ARM
$vm = get-azurevm -ResourceGroupName $resourceGroupName -Name $vmName

###########
#Set auto patching
###########
$aps = New-AzureVMSqlServerAutoPatchingConfig -Enable -DayOfWeek "EveryDay" -MaintenanceWindowStartingHour 20 -MaintenanceWindowDuration 120 -PatchCategory "Important"
$vm | Set-AzureVMSqlServerExtension -AutoPatchingSettings $aps  -ResourceGroupName $resourceGroupName -VMName $vmName -Version "1.2" -Verbose

###########
#Set auto backup
###########
$storageUrl = "https://__account__.blob.core.windows.net/"
$storageAccountKey = "__KEY__"
$storageAccountKeySecure = convertto-securestring $storageAccountKey -asplaintext -force

$abs = New-AzureVMSqlServerAutoBackupConfig -Enable -RetentionPeriod 22 -StorageUri $storageUrl -StorageKey $storageAccountKeySecure
$vm = get-azurevm -ResourceGroupName $resourceGroupName -Name $vmName
$vm | Set-AzureVMSqlServerExtension -AutoBackupSettings $abs  -ResourceGroupName $resourceGroupName -VMName $vmName -Version "1.2" -Verbose

###########
#get extension status
###########
Get-AzureVMSqlServerExtension -ResourceGroupName $resourceGroupName -VMName $vmName -Name $vmName

###########
#remove extension
###########
Remove-AzureVMSqlServerExtension -ResourceGroupName $resourceGroupName -VMName $vmName -Name $vmName

Task# 5468533 - SQL IaaS Extension PowerShell Resource Management support

…Azure-dev

Conflicts:
	src/ResourceManager/Compute/Commands.Compute/Common/ConstantStringTypes.cs

PR from parent

…red in JSON serializer

- no special handling is needed in Get-AzureVMSqlServerExtension to mask secrets

Conflicts:
	ChangeLog.md

… cmdlets.

- Replacing this file with recent version  from
    https://github.com/Azure/azure-powershell/blob/dev/setup/azurecmdfiles.wxi

… back to read AutoBackup and AutoPatching settings