v14.0.0-preview0003

[v14.0.0-preview0003]

Added

• SqlSetup
  • A read only property IsClustered was added that can be used to determine
    if the instance is clustered.

Changed

• SqlServerDsc
  • Changed all resource prefixes from MSFT_ to DSC_ (issue #1496).
  • All resources are now using the common module DscResource.Common.
• SqlAlwaysOnService
  • BREAKING CHANGE: The parameter ServerName is now non-mandatory and
    defaults to $env:COMPUTERNAME (issue #319).
  • Normalize parameter descriptive text for default values.
• SqlDatabase
  • BREAKING CHANGE: The parameter ServerName is now non-mandatory and
    defaults to $env:COMPUTERNAME (issue #319).
  • Normalize parameter descriptive text for default values.
• SqlDatabaseDefaultLocation
  • BREAKING CHANGE: The parameter ServerName is now non-mandatory and
    defaults to $env:COMPUTERNAME (issue #319).
  • Normalize parameter descriptive text for default values.
• SqlDatabaseOwner
  • BREAKING CHANGE: Database changed to DatabaseName for consistency with
    other modules (issue #1484).
• SqlDatabasePermission
  • BREAKING CHANGE: The parameter ServerName is now non-mandatory and
    defaults to $env:COMPUTERNAME (issue #319).
  • Normalize parameter descriptive text for default values.
  • BREAKING CHANGE: Database changed to DatabaseName for consistency with
    other modules (issue #1484).
• SqlDatabaseRecoveryModel
  • BREAKING CHANGE: The parameter ServerName is now non-mandatory and
    defaults to $env:COMPUTERNAME (issue #319).
  • Normalize parameter descriptive text for default values.
• SqlDatabaseRole
  • BREAKING CHANGE: The parameter ServerName is now non-mandatory and
    defaults to $env:COMPUTERNAME (issue #319).
  • Normalize parameter descriptive text for default values.
  • BREAKING CHANGE: Database changed to DatabaseName for consistency with
    other modules (issue #1484).
• SqlDatabaseUser
  • BREAKING CHANGE: The parameter ServerName is now non-mandatory and
    defaults to $env:COMPUTERNAME (issue #319).
  • Normalize parameter descriptive text for default values.
• SqlServerConfiguration
  • BREAKING CHANGE: The parameter ServerName is now non-mandatory and
    defaults to $env:COMPUTERNAME (issue #319).
  • Normalize parameter descriptive text for default values.
• SqlServerDatabaseMail
  • Normalize parameter descriptive text for default values.
• SqlServerEndpoint
  • Normalize parameter descriptive text for default values.
• SqlServerEndpointPermission
  • BREAKING CHANGE: The parameter ServerName is now non-mandatory and
    defaults to $env:COMPUTERNAME (issue #319).
  • Normalize parameter descriptive text for default values.
• SqlServerLogin
  • BREAKING CHANGE: The parameter ServerName is now non-mandatory and
    defaults to $env:COMPUTERNAME (issue #319).
  • Normalize parameter descriptive text for default values.
• SqlServerRole
  • BREAKING CHANGE: The parameter ServerName is now non-mandatory and
    defaults to $env:COMPUTERNAME (issue #319).
  • Normalize parameter descriptive text for default values.
• SqlServiceAccount
  • BREAKING CHANGE: The parameter ServerName is now non-mandatory and
    defaults to $env:COMPUTERNAME (issue #319).
  • Normalize parameter descriptive text for default values.

Fixed

• SqlServerDsc
  • The regular expression for minor-version-bump-message in the file
    GitVersion.yml was changed to only raise minor version when the
    commit message contain the word add, adds, minor, feature,
    or features.
  • Now code coverage is reported to Codecov.
  • Updated to support DscResource.Common v0.7.1.
• SqlSetup
  • The property SqlTempdbLogFileGrowth and SqlTempdbFileGrowth now returns
    the correct values. Previously the value of the growth was wrongly
    divided by 1KB even if the value was in percent. Now the value for growth
    is the sum of the average of MB and average of the percentage.
  • The function Get-TargetResource was changed so that the property
    SQLTempDBDir will now return the database tempdb's property
    PrimaryFilePath.
  • BREAKING CHANGE: Logic that was under feature flag DetectionSharedFeatures
    was made the default and old logic that was used to detect shared features
    was removed (issue #1290).
    This was implemented because the previous implementation did not work
    fully with SQL Server 2017.
  • Much of the code was refactored into units (functions) to be easier to test.
    Due to the size of the code the unit tests ran for an abnormal long time,
    after this refactoring the unit tests runs much quicker.
• README.md
  • Changed to point to CONTRIBUTING.md on master branch to avoid "404 Page not found"
    (issue #1508).
• SqlAlias
  • BREAKING CHANGE: The parameter ServerName is now non-mandatory to
    prevent ping-pong behavior (issue #1502).
    The ServerName is not returned as an empty string when the protocol is
    Named Pipes.
• SqlRs
  • Fix typo in the schema parameter SuppressRestart description
    and in the parameter description in the README.md.
• SqlSetup
  • Update integration tests to correctly detect sysadmins because of changes
    to the build worker.
• SqlAgentAlert
  • The parameter ServerName now throws when passing an empty string or
    null value (part of issue #319).
• SqlAgentFailsafe
  • The parameter ServerName now throws when passing an empty string or
    null value (part of issue #319).
• SqlAgentOperator
  • The parameter ServerName now throws when passing an empty string or
    null value (part of issue #319).
• SqlServerDatabaseMail
  • The parameter ServerName now throws when passing an empty string or
    null value (part of issue #319).
• SqlServerEndpoint
  • The parameter ServerName now throws when passing an empty string or
    null value (part of issue #319).
• SqlServerEndpointState
  • The parameter ServerName now throws when passing an empty string or
    null value (part of issue #319).
• SqlServerPermission
  • The parameter ServerName now throws when passing an empty string or
    null value (part of issue #319).