Skip to content

v13.1.0
Compare
Choose a tag to compare
@johlju johlju released this 25 Dec 09:18
v13.1.0
596ff25
This commit was created on GitHub.com and signed with GitHub’s verified signature. The key has expired.
GPG key ID: 4AEE18F83AFDEB23
Expired
Learn about vigilant mode.
  • Changes to SqlServerDsc
    • New DSC resource SqlAgentFailsafe
    • New DSC resource SqlDatabaseUser (issue #846).
      • Adds ability to create database users with more fine-grained control,
        e.g. re-mapping of orphaned logins or a different login. Supports
        creating a user with or without login name, and database users mapped
        to a certificate or asymmetric key.
    • Changes to helper function Invoke-Query
      • Fixes issues in issue #1355.
      • Works together with Connect-SQL now.
      • Parameters now match that of Connect-SQL (issue #1392).
      • Can now pass in credentials.
      • Can now pass in 'Microsoft.SqlServer.Management.Smo.Server' object.
      • Can also pipe in 'Microsoft.SqlServer.Management.Smo.Server' object.
      • Can pipe Connect-SQL | Invoke-Query.
      • Added default values to Invoke-Query.
      • Now it will output verbose messages of the query that is run, so it
        not as quiet of what it is doing when a user asks for verbose output
        (issue #1404).
      • It is possible to redact text in the verbose output by providing
        strings in the new parameter RedactText.
    • Minor style fixes in unit tests.
    • Changes to helper function Connect-SQL
      • When impersonating WindowsUser credential use the NetworkCredential UserName.
      • Added additional verbose logging.
      • Connect-SQL now uses parameter sets to more intuitive evaluate that
        the correct parameters are used in different scenarios
        (issue #1403).
    • Changes to helper function Connect-SQLAnalysis
      • Parameters now match that of Connect-SQL (issue #1392).
    • Changes to helper function Restart-SqlService
      • Parameters now match that of Connect-SQL (issue #1392).
    • Changes to helper function Restart-ReportingServicesService
      • Parameters now match that of Connect-SQL (issue #1392).
    • Changes to helper function Split-FullSqlInstanceName
      • Parameters and function name changed to use correct casing.
    • Changes to helper function Get-SqlInstanceMajorVersion
      • Parameters now match that of Connect-SQL (issue #1392).
    • Changes to helper function Test-LoginEffectivePermissions
      • Parameters now match that of Connect-SQL (issue #1392).
    • Changes to helper function Test-AvailabilityReplicaSeedingModeAutomatic
      • Parameters now match that of Connect-SQL (issue #1392).
  • Changes to SqlServerSecureConnection
    • Forced $Thumbprint to lowercase to fix issue #1350.
    • Add parameter SuppressRestart with default value false.
      This allows users to suppress restarts after changes have been made.
      Changes will not take effect until the service has been restarted.
  • Changes to SqlSetup
  • Changes to SqlDatabase
    • Get-TargetResource now correctly return $null for the collation property
      when the database does not exist (issue #1395).
    • No longer enforces the collation property if the Collation parameter
      is not part of the configuration (issue #1396).
    • Updated resource description in README.md
    • Fix examples to use PsDscRunAsCredential (issue #760).
    • Added integration tests (issue #739).
    • Updated unit tests to the latest template (issue #1068).
Assets 2
Loading