SqlServerDsc: Fix pipeline script

[johlju]

Pull Request (PR) description

• SqlServerDsc
  • Update pipeline script that is used to resolve dependencies.

This Pull Request (PR) fixes the following issues

None.

Task list

• [x] Added an entry to the change log under the Unreleased section of the file CHANGELOG.md. Entry should say what was changed and how that affects users (if applicable), and reference the issue being resolved (if applicable).
• [ ] Resource documentation updated in the resource's README.md.
• [ ] Resource parameter descriptions updated in schema.mof.
• [ ] Comment-based help updated, including parameter descriptions.
• [ ] Localization strings updated.
• [ ] Examples updated.
• [ ] Unit tests updated. See DSC Community Testing Guidelines.
• [ ] Integration tests updated (where possible). See DSC Community Testing Guidelines.
• [x] Code changes adheres to DSC Community Style Guidelines.

---

This change is 

[johlju]

This change need to be merged in Sampler before merging here. I will send in a PR to Sampler.

[codecov[bot]]

Codecov Report

Merging #1875 (93b48d9) into main (67aa742) will not change coverage. The diff coverage is n/a.

@@         Coverage Diff          @@
##           main   #1875   +/-   ##
====================================
  Coverage    92%     92%           
====================================
  Files        85      85           
  Lines      7640    7640           
====================================
  Hits       7038    7038           
  Misses      602     602           

Flag	Coverage Δ
unit	92% <ø> (ø)

[johlju]

The steps to install on a clean Windows 11 (release 22H2 Feb 2023).

# 1. Install "App Installer" (winget) from Microsoft Store
# 2. Install Git, from (Windows) PowerShell
winget install Git.Git
Set-ExecutionPolicy -ExecutionPolicy RemoteSigned -Scope CurrentUser
# Restart PowerShell session, then run
mkdir c:/source
cd c:/source
git clone https://github.com/dsccommunity/SqlServerDsc
cd ./SqlServerDsc
# Will install NuGet provider.
# If RequiredModules.psd1 contains prerelease - session need to be restarted. Gives error "Find-Module : A parameter cannot be found that matches parameter name 'AllowPrereleaseVersions'"
$InformationPreference = 'Continue'
.\build.ps1 -ResolveDependency -Tasks noop
``