API version change log for deployment of Microsoft.SqlVirtualMachine/sqlVirtualMachines

This article describes the properties that changed in each API version for Microsoft.SqlVirtualMachine/sqlVirtualMachines. It only covers properties that are available during deployments.

2022-08-01-preview

Added:

• properties.serverConfigurationsManagementSettings.azureAdAuthenticationSettings
• properties.serverConfigurationsManagementSettings.azureAdAuthenticationSettings.clientId

Updated:

• properties.wsfcDomainCredentials.apiVersion - Added values: '2022-08-01-preview' - Removed values: '2022-07-01-preview'

2022-07-01-preview

Added:

• properties.enableAutomaticUpgrade
• properties.leastPrivilegeMode

Updated:

• properties.wsfcDomainCredentials.apiVersion - Added values: '2022-07-01-preview' - Removed values: '2022-02-01'

2022-02-01

Updated:

• properties.wsfcDomainCredentials.apiVersion - Added values: '2022-02-01' - Removed values: '2022-02-01-preview'

2022-02-01-preview

Added:

• properties.serverConfigurationsManagementSettings.sqlInstanceSettings.isIfiEnabled
• properties.serverConfigurationsManagementSettings.sqlInstanceSettings.isLpimEnabled
• properties.storageConfigurationSettings.sqlTempDbSettings.persistFolder
• properties.storageConfigurationSettings.sqlTempDbSettings.persistFolderPath
• properties.wsfcStaticIp

Updated:

• properties.wsfcDomainCredentials.apiVersion - Added values: '2022-02-01-preview' - Removed values: '2021-11-01-preview'

2021-11-01-preview

Added:

• properties.assessmentSettings
• properties.assessmentSettings.enable
• properties.assessmentSettings.runImmediately
• properties.assessmentSettings.schedule
• properties.assessmentSettings.schedule.dayOfWeek
• properties.assessmentSettings.schedule.enable
• properties.assessmentSettings.schedule.monthlyOccurrence
• properties.assessmentSettings.schedule.startTime
• properties.assessmentSettings.schedule.weeklyInterval
• properties.autoBackupSettings.daysOfWeek
• properties.autoBackupSettings.storageContainerName
• properties.serverConfigurationsManagementSettings.sqlInstanceSettings
• properties.serverConfigurationsManagementSettings.sqlInstanceSettings.collation
• properties.serverConfigurationsManagementSettings.sqlInstanceSettings.isOptimizeForAdHocWorkloadsEnabled
• properties.serverConfigurationsManagementSettings.sqlInstanceSettings.maxDop
• properties.serverConfigurationsManagementSettings.sqlInstanceSettings.maxServerMemoryMB
• properties.serverConfigurationsManagementSettings.sqlInstanceSettings.minServerMemoryMB
• properties.storageConfigurationSettings.sqlSystemDbOnDataDisk
• properties.storageConfigurationSettings.sqlTempDbSettings.dataFileCount
• properties.storageConfigurationSettings.sqlTempDbSettings.dataFileSize
• properties.storageConfigurationSettings.sqlTempDbSettings.dataGrowth
• properties.storageConfigurationSettings.sqlTempDbSettings.logFileSize
• properties.storageConfigurationSettings.sqlTempDbSettings.logGrowth

Updated:

• identity.type - Added values: 'None'
• properties.autoPatchingSettings.dayOfWeek - Added values: 'Everyday'
• properties.wsfcDomainCredentials.apiVersion - Added values: '2021-11-01-preview' - Removed values: '2017-03-01-preview'

2017-03-01-preview

Oldest version tracked in change log