SqlAudit: Fix documentation (dsccommunity#1782)

SqlServerDsc: Make class-based resources derive from `SqlResourceBase` (

dsccommunity#1780)

SqlAudit: New resources (dsccommunity#1499)

- SqlServerDsc
  - Add new resource SqlServerAudit.
  - The following classes were added to the module:
    - `SqlResourceBase` - class that can be inherited by class-based resource and
      provides default DSC properties and method for get a `[Server]`-object.
  - The following public functions were added to the module (see comment-based
    help for more information):
    - `Invoke-SqlDscQuery`
    - `Get-SqlDscAudit`
    - `New-SqlDscAudit`
    - `Set-SqlDscAudit`
    - `Remove-SqlDscAudit`
    - `Enable-SqlDscAudit`
    - `Disable-SqlDscAudit`
- `Get-DscProperty`
  - Added parameter `ExcludeName` to exclude property names from being returned.
- SqlPermission
  - Fix comment-based help.
- `ConvertTo-Reason`
  - Fix to handle `$null` values on Windows PowerShell.
  - If the property name contain the word 'Path' the value will be parsed to
    replace backslash or slashes at the end of the string, e.g. `'/mypath/'`
    will become `'/mypath'`.
- `ResourceBase`
  - Now handles `Ensure` correctly from derived `GetCurrentState()`. But
    requires that the `GetCurrentState()` only return key property if object
    is present, and does not return key property if object is absent.
    Optionally the resource's derived `GetCurrentState()` can handle `Ensure`
    itself.

BREAKING CHANGE: SqlPermission: Refactored resource (class-based reso…

…urce) (dsccommunity#1778)

- SqlServerDsc
  - The following classes were added to the module:
    - `ServerPermission` - complex type for the DSC resource SqlPermission.
  - The following public functions were added to the module (see comment-based
    help for more information):
    - `Test-SqlDscIsLogin`
    - `ConvertFrom-SqlDscServerPermission`
    - `ConvertTo-SqlDscServerPermission`
    - `Get-SqlDscServerPermission`
    - `Set-SqlDscServerPermission`
  - SMO stubs (used in the unit tests)
    - Was updated to remove a bug related to the type `ServerPermissionInfo`
      when used with the type `ServerPermissionSet`. The stubs suggested that
      the property `PermissionType` (of type `ServerPermissionSet`)
      in `ServerPermissionInfo` should have been a array `ServerPermissionSet[]`.
      This conflicted with real SMO as it does not pass an array, but instead
      a single `ServerPermissionSet`. The stubs was modified to mimic the
      real SMO. At the same time some old mock code in the SMO stubs was removed
      as it was no longer in use.
- SqlPermission
  - BREAKING CHANGE: The resource has been refactored. The parameters
    `Permissions` has been replaced by parameters `Permission`,
    `PermissionToInclude`, and `PermissionToExclude`. These permissions
    parameters are now an instance of the type `ServerPermission`.
    The type `ServerPermission` contains two properties; `State` and
    `Permission`. This closes the issue [issue dsccommunity#1761](dsccommunity#1761),
    it also fixes the issues [issue dsccommunity#1773](dsccommunity#1773),
    [issue dsccommunity#1704](dsccommunity#1704),
    and [issue dsccommunity#752](dsccommunity#752).
  - The resource was refactored into a class-based resource.
- SqlDatabasePermission
  - Fixed comment-based help and cleaned up comments.
  - Fix localized string that referenced 'user' instead of 'principal',
    and correct localized string ID for each string.
- `Set-SqlDscDatabasePermission`
  - Minor code cleanup.

Add more analyzer rules (dsccommunity#1757)

SqlSetup: SourcePath should be a mandatory parameter (dsccommunity#1756)

- The `SourcePath` parameter is now mandatory for all `*-TargetResource` (issue dsccommunity#1755).

BREAKING CHANGE: SqlServerDsc: Support Pester 5 (dsccommunity#1550)

SqlDatabaseRole: Execute Set-TargetResource when database IsUpdateabl…

…e is $true (dsccommunity#1751)

SqlAgDatabase: Fixes Issue dsccommunity#1743 (dsccommunity#1744)

- Changes to SqlAGDatabase
   - Added StatementTimeout optional parameter with default value of 600 seconds (10 mins) to SqlAGDatabase to fix Issue#1743
     Users will be able to specify the backup and restore timeout with it.

BREAKING CHANGE: SqlLogin: Parameters no longer enforce default values (

dsccommunity#1696)

- SqlLogin
  - BREAKING CHANGE: `LoginMustChangePassword`, `LoginPasswordExpirationEnabled` and `LoginPasswordPolicyEnforced`
    parameters no longer enforce default values (issue dsccommunity#1669).