v16.3.0

[v16.3.0]

Remove

• SqlServerDsc.Common
  • Removed the function Invoke-Query. It is replaced by the command
    Invoke-SqlDscQuery (issue #1902).

Added

• New public commands:
  • Disconnect-SqlDscDatabaseEngine - Disconnects from a SQL Server instance
    that was previously connected to using Connect-SqlDscDatabaseEngine.
  • Test-SqlDscIsSupportedFeature - Evaluates if a feature is supported by a specific
    Microsoft SQL Server major version. This command must be extended with
    a full list of when features were added and removed in each major
    version to fully work.
• New private commands:
  • ConvertTo-RedactedText - Used to redact sensitive information from
    text that then can be used in console output like verbose messages.
  • Get-FileVersionInformation - Returns the version information
    for a file.
  • Assert-Feature - Throws an exception if a feature is not supported
    for a specific Microsoft SQL Server major version.
• SqlServerDsc.Common
  • Connect-SQL.
    • Add new parameter Encrypt.
• Connect-SqlDscDatabaseEngine
  • Add new parameter Encrypt.
• Invoke-SqlDscQuery
  • Add new parameter Encrypt.

Changed

• Now able to use DbaTools as a preferred module
  (with some restrictions).
• Gitversion no longer evaluates bumping major version using the word "major".
• Update private commands:
  • Assert-SetupActionProperties was changed to throw
    an exception when a feature is not supported (calls Assert-Feature).
    The private command is indirectly used by the setup action commands.
  • Invoke-SetupAction was changed to expand environment variables that
    is passed as the media path.
• SqlSetup
  • Update to support checking non-supported features using the command
    SqlDscIsSupportedFeature (issue #1872).
• Update SqlServerDsc.Common Module:
  • Connect-SQL - Function will now wait for the SMO Status property to be
    'Online' or throw an exception if time exceeds the statement timeout.
• SqlRS
  • Now uses the command Invoke-SqlDscQuery instead of Invoke-SqlCmd
    (issue #1917).
  • The parameter Encrypt has changed so that Mandatory or Strict
    will turn on encryption when connecting to the database instance.
• SqlDatabaseMail
  • Update integration tests to verify multiple instances of SqlDatabaseMail
    in the same configuration (issue #1871).
  • Changed comparison logic to use Compare-DscParameterState (issue #1871).
  • Return the correct profile name and mail server name from the current
    state (issue #1871).
• Invoke-SqlDscQuery
  • Now shows the correct instance name when called using a server object
    (issue #1918).
  • Correctly outputs query in verbose message when parameter RedactText
    is not passed.
• Import-SqlDscPreferredModule
  • Better handle preferred module and re-uses logic in Get-SqlDscPreferredModule.