SqlServerDsc.psd1
@{ # Version number of this module. moduleVersion = '13.1.0.0' # ID used to uniquely identify this module GUID = '693ee082-ed36-45a7-b490-88b07c86b42f' # Author of this module Author = 'Microsoft Corporation' # Company or vendor of this module CompanyName = 'Microsoft Corporation' # Copyright statement for this module Copyright = '(c) 2018 Microsoft Corporation. All rights reserved.' # Description of the functionality provided by this module Description = 'Module with DSC Resources for deployment and configuration of Microsoft SQL Server.' # Minimum version of the Windows PowerShell engine required by this module PowerShellVersion = '5.0' # Minimum version of the common language runtime (CLR) required by this module CLRVersion = '4.0' # Functions to export from this module FunctionsToExport = '*' # Cmdlets to export from this module CmdletsToExport = '*' RequiredAssemblies = @() # Private data to pass to the module specified in RootModule/ModuleToProcess. This may also contain a PSData hashtable with additional module metadata used by PowerShell. PrivateData = @{ PSData = @{ # Tags applied to this module. These help with module discovery in online galleries. Tags = @('DesiredStateConfiguration', 'DSC', 'DSCResourceKit', 'DSCResource') # A URL to the license for this module. LicenseUri = 'https://github.com/PowerShell/SqlServerDsc/blob/master/LICENSE' # A URL to the main website for this project. ProjectUri = 'https://github.com/PowerShell/SqlServerDsc' # A URL to an icon representing this module. # IconUri = '' # ReleaseNotes of this module ReleaseNotes = '- Changes to SqlServerDsc - New DSC resource SqlAgentFailsafe - New DSC resource SqlDatabaseUser ([issue 846](https://github.com/PowerShell/SqlServerDsc/issues/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](https://github.com/PowerShell/SqlServerDsc/issues/1355). - Works together with Connect-SQL now. - Parameters now match that of Connect-SQL ([issue 1392](https://github.com/PowerShell/SqlServerDsc/issues/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](https://github.com/PowerShell/SqlServerDsc/issues/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](https://github.com/PowerShell/SqlServerDsc/issues/1403)). - Changes to helper function Connect-SQLAnalysis - Parameters now match that of Connect-SQL ([issue 1392](https://github.com/PowerShell/SqlServerDsc/issues/1392)). - Changes to helper function Restart-SqlService - Parameters now match that of Connect-SQL ([issue 1392](https://github.com/PowerShell/SqlServerDsc/issues/1392)). - Changes to helper function Restart-ReportingServicesService - Parameters now match that of Connect-SQL ([issue 1392](https://github.com/PowerShell/SqlServerDsc/issues/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](https://github.com/PowerShell/SqlServerDsc/issues/1392)). - Changes to helper function Test-LoginEffectivePermissions - Parameters now match that of Connect-SQL ([issue 1392](https://github.com/PowerShell/SqlServerDsc/issues/1392)). - Changes to helper function Test-AvailabilityReplicaSeedingModeAutomatic - Parameters now match that of Connect-SQL ([issue 1392](https://github.com/PowerShell/SqlServerDsc/issues/1392)). - Changes to SqlServerSecureConnection - Forced $Thumbprint to lowercase to fix [issue 1350](https://github.com/PowerShell/SqlServerDsc/issues/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 - Correct minor style violation [issue 1387](https://github.com/PowerShell/SqlServerDsc/issues/1387). - Changes to SqlDatabase - Get-TargetResource now correctly return `$null` for the collation property when the database does not exist ([issue 1395](https://github.com/PowerShell/SqlServerDsc/issues/1395)). - No longer enforces the collation property if the Collation parameter is not part of the configuration ([issue 1396](https://github.com/PowerShell/SqlServerDsc/issues/1396)). - Updated resource description in README.md - Fix examples to use `PsDscRunAsCredential` ([issue 760](https://github.com/PowerShell/SqlServerDsc/issues/760)). - Added integration tests ([issue 739](https://github.com/PowerShell/SqlServerDsc/issues/739)). - Updated unit tests to the latest template ([issue 1068](https://github.com/PowerShell/SqlServerDsc/issues/1068)). ' } # End of PSData hashtable } # End of PrivateData hashtable } |