Skip to content

v5.0.0

Compare
Choose a tag to compare
@johlju johlju released this 25 Dec 09:04
  • Improvements how tests are initiated in AppVeyor
    • Removed previous workaround (issue #201) from unit tests.
    • Changes in appveyor.yml so that SQL modules are removed before common test is
      run.
    • Now the deploy step are no longer failing when merging code into Dev. Neither
      is the deploy step failing if a contributor had AppVeyor connected to the fork
      of xSQLServer and pushing code to the fork.
  • Changes to README.md
    • Changed the contributing section to help new contributors.
    • Added links for each resource so it is easier to navigate to the parameter list
      for each resource.
    • Moved the list of resources in alphabetical order.
    • Moved each resource parameter list into alphabetical order.
    • Removed old text mentioning System Center.
    • Now the correct product name is written in the installation section, and a typo
      was also fixed.
    • Fixed a typo in the Requirements section.
    • Added link to Examples folder in the Examples section.
    • Change the layout of the README.md to closer match the one of PSDscResources
    • Added more detailed text explaining what operating systems WMF5.0 can be installed
      on.
    • Verified all resource schema files with the README.md and fixed some errors
      (descriptions was not verified).
    • Added security requirements section for resource xSQLServerEndpoint and
      xSQLAOGroupEnsure.
  • Changes to xSQLServerSetup
    • The resource no longer uses Win32_Product WMI class when evaluating if
      SQL Server Management Studio is installed. See article
      kb974524 for more information.
    • Now it uses CIM cmdlets to get information from WMI classes.
    • Resolved all of the PSScriptAnalyzer warnings that was triggered in the common
      tests.
    • Improvement for service accounts to enable support for Managed Service Accounts
      as well as other nt authority accounts
    • Changes to the helper function Copy-ItemWithRoboCopy
      • Robocopy is now started using Start-Process and the error handling has been
        improved.
      • Robocopy now removes files at the destination path if they no longer exists
        at the source.
      • Robocopy copies using unbuffered I/O when available (recommended for large
        files).
    • Added a more descriptive text for the parameter SourceCredential to further
      explain how the parameter work.
    • BREAKING CHANGE: Removed parameter SourceFolder.
    • BREAKING CHANGE: Removed default value "$PSScriptRoot...." from parameter
      SourcePath.
    • Old code, that no longer filled any function, has been replaced.
      • Function ResolvePath has been replaced with
        [Environment]::ExpandEnvironmentVariables($SourcePath) so that environment
        variables still can be used in Source Path.
      • Function NetUse has been replaced with New-SmbMapping and
        Remove-SmbMapping.
    • Renamed function GetSQLVersion to Get-SqlMajorVersion.
    • BREAKING CHANGE: Renamed parameter PID to ProductKey to avoid collision with
      automatic variable $PID
  • Changes to xSQLServerScript
    • All credential parameters now also has the type
      [System.Management.Automation.Credential()] to better work with PowerShell 4.0.
    • It is now possible to configure two instances on the same node, with the same
      script.
    • Added to the description text for the parameter Credential describing how
      to authenticate using Windows Authentication.
    • Added examples to show how to authenticate using either SQL or Windows
      authentication.
    • A recent issue showed that there is a known problem running this resource
      using PowerShell 4.0. For more information, see issue #273
  • Changes to xSQLServerFirewall
    • BREAKING CHANGE: Removed parameter SourceFolder.
    • BREAKING CHANGE: Removed default value "$PSScriptRoot...." from parameter
      SourcePath.
    • Old code, that no longer filled any function, has been replaced.
      • Function ResolvePath has been replaced with
        [Environment]::ExpandEnvironmentVariables($SourcePath) so that environment
        variables still can be used in Source Path.
    • Adding new optional parameter SourceCredential that can be used to authenticate
      against SourcePath.
    • Solved PSSA rules errors in the code.
    • Get-TargetResource no longer return $true when no products was installed.
  • Changes to the unit test for resource
    • xSQLServerSetup
      • Added test coverage for helper function Copy-ItemWithRoboCopy
  • Changes to xSQLServerLogin
    • Removed ShouldProcess statements
    • Added the ability to enforce password policies on SQL logins
  • Added common test (xSQLServerCommon.Tests) for xSQLServer module
    • Now all markdown files will be style checked when tests are running in AppVeyor
      after sending in a pull request.
    • Now all Examples will be tested by compiling to a .mof
      file after sending in a pull request.
  • Changes to xSQLServerDatabaseOwner
    • The example 'SetDatabaseOwner' can now compile, it wrongly had a DependsOn
      in the example.
  • Changes to SQLServerRole
    • The examples 'AddServerRole' and 'RemoveServerRole' can now compile, it wrongly
      had a DependsOn in the example.
  • Changes to CONTRIBUTING.md
    • Added section 'Tests for examples files'
    • Added section 'Tests for style check of Markdown files'
    • Added section 'Documentation with Markdown'
    • Added texts to section 'Tests'
  • Changes to xSQLServerHelper
    • added functions
      • Get-SqlDatabaseRecoveryModel
      • Set-SqlDatabaseRecoveryModel
  • Examples
    • xSQLServerDatabaseRecoveryModel
      • 1-SetDatabaseRecoveryModel.ps1
    • xSQLServerDatabasePermission
      • 1-GrantDatabasePermissions.ps1
      • 2-RevokeDatabasePermissions.ps1
      • 3-DenyDatabasePermissions.ps1
    • xSQLServerFirewall
      • 1-CreateInboundFirewallRules
      • 2-RemoveInboundFirewallRules
  • Added tests for resources
    • xSQLServerDatabaseRecoveryModel
    • xSQLServerDatabasePermissions
    • xSQLServerFirewall
  • Changes to xSQLServerDatabaseRecoveryModel
    • BREAKING CHANGE: Renamed xSQLDatabaseRecoveryModel to
      xSQLServerDatabaseRecoveryModel to align with naming convention.
    • BREAKING CHANGE: The mandatory parameters now include SQLServer, and
      SQLInstanceName.
  • Changes to xSQLServerDatabasePermission
    • BREAKING CHANGE: Renamed xSQLServerDatabasePermissions to
      xSQLServerDatabasePermission to align with naming convention.
    • BREAKING CHANGE: The mandatory parameters now include PermissionState,
      SQLServer, and SQLInstanceName.
  • Added support for clustered installations to xSQLServerSetup
    • Migrated relevant code from xSQLServerFailoverClusterSetup
    • Removed Get-WmiObject usage
    • Clustered storage mapping now supports asymmetric cluster storage
    • Added support for multi-subnet clusters
    • Added localized error messages for cluster object mapping
    • Updated README.md to reflect new parameters
  • Updated description for xSQLServerFailoverClusterSetup to indicate it is deprecated.
  • xPDT helper module
    • Function GetxPDTVariable was removed since it no longer was used by any resources.
    • File xPDT.xml was removed since it was not used by any resources, and did not
      provide any value to the module.
  • Changes xSQLServerHelper module
    • Removed the globally defined $VerbosePreference = 'Continue' from xSQLServerHelper.
    • Fixed a typo in a variable name in the function New-ListenerADObject.
    • Now Restart-SqlService will correctly show the services it restarts. Also
      fixed PSSA warnings.