v13.0.0

• Changes to SqlServerDsc
  • Added SqlAgentAlert resource.
  • Opt-in to the common test 'Common Test - Validation Localization'.
  • Opt-in to the common test 'Common Test - Flagged Script Analyzer Rules'
    (issue #1101).
  • Removed the helper function New-TerminatingError, New-WarningMessage
    and New-VerboseMessage in favor of the the new
    localization helper functions.
  • Combine DscResource.LocalizationHelper and DscResource.Common into
    SqlServerDsc.Common (issue #1357).
  • Update Assert-TestEnvironment.ps1 to not error if strict mode is enabled
    and there are no missing dependencies (issue #1368).
• Changes to SqlServerDsc.Common
  • Added StatementTimeout to function 'Connect-SQL' with default 600 seconds (10mins).
  • Added StatementTimeout to function 'Invoke-Query' with default 600 seconds (10mins)
    (issue #1358).
  • Changes to helper function Connect-SQL
    • The function now make it more clear that when using the parameter
      SetupCredential is impersonates that user, and by default it does
      not impersonates a user but uses the credential that the resource
      is run as (for example the built-in credential parameter
      PsDscRunAsCredential). @kungfu71186
    • Added parameter alias -DatabaseCredential for the parameter
      -SetupCredential. @kungfu71186
• Changes to SqlAG
  • Added en-US localization.
• Changes to SqlAGReplica
  • Added en-US localization.
  • Improved verbose message output when creating availability group replica,
    removing a availability group replica, and joining the availability
    group replica to the availability group.
• Changes to SqlAlwaysOnService
  • Now outputs the correct verbose message when restarting the service.
• Changes to SqlServerMemory
  • Now outputs the correct verbose messages when calculating the dynamic
    memory, and when limiting maximum memory.
• Changes to SqlServerRole
  • Now outputs the correct verbose message when the members of a role is
    not in desired state.
• Changes to SqlAgentOperator
  • Fix minor issue that when unable to connect to an instance. Instead
    of showing a message saying that connect failed another unrelated
    error message could have been shown, because of an error in the code.
  • Fix typo in test it block.
• Changes to SqlDatabaseRole
  • BREAKING CHANGE: Refactored to enable creation/deletion of the database role
    itself as well as management of the role members. Note that the resource no
    longer adds database users. (issue #845,
    issue #847,
    issue #1252,
    issue #1339).
    Paul Shamus @pshamus
• Changes to SqlSetup
  • Add an Action type of 'Upgrade'. This will ask setup to do a version
    upgrade where possible (issue #1368).
  • Fix an error when testing for DQS installation (issue #1368).
  • Changed the logic of how default value of FailoverClusterGroupName is
    set since that was preventing the resource to be able to be debugged
    (issue #448).
  • Added RSInstallMode parameter (issue #1163).
• Changes to SqlWindowsFirewall
  • Where a version upgrade has changed paths for a database engine, the
    existing firewall rule for that instance will be updated rather than
    another one created (issue #1368).
    Other firewall rules can be fixed to work in the same way later.
• Changes to SqlAGDatabase
  • Added new parameter 'ReplaceExisting' with default false.
    This allows forced restores when a database already exists on secondary.
  • Added StatementTimeout to Invoke-Query to fix Issue#1358
  • Fix issue where calling Get would return an error because the database
    name list may have been returned as a string instead of as a string array
    (issue #1368).