SqlServerDsc

13.1.0.0

Module with DSC Resources for deployment and configuration of Microsoft SQL Server.

Minimum PowerShell version

5.0

There is a newer prerelease version of this module available.
See the version list below for details.

Installation Options

Copy and Paste the following command to install this package using PowerShellGet More Info

Install-Module -Name SqlServerDsc -RequiredVersion 13.1.0.0

Copy and Paste the following command to install this package using Microsoft.PowerShell.PSResourceGet More Info

Install-PSResource -Name SqlServerDsc -Version 13.1.0.0

You can deploy this package directly to Azure Automation. Note that deploying packages with dependencies will deploy all the dependencies to Azure Automation. Learn More

Manually download the .nupkg file to your system's default download location. Note that the file won't be unpacked, and won't include any dependencies. Learn More

Owners

Copyright

(c) 2018 Microsoft Corporation. All rights reserved.

Package Details

Author(s)

  • Microsoft Corporation

Tags

DesiredStateConfiguration DSC DSCResourceKit DSCResource

DSCResources

MSFT_SqlAG MSFT_SqlAGDatabase MSFT_SqlAgentAlert MSFT_SqlAgentFailsafe MSFT_SqlAgentOperator MSFT_SqlAGListener MSFT_SqlAGReplica MSFT_SqlAlias MSFT_SqlAlwaysOnService MSFT_SqlDatabase MSFT_SqlDatabaseDefaultLocation MSFT_SqlDatabaseOwner MSFT_SqlDatabasePermission MSFT_SqlDatabaseRecoveryModel MSFT_SqlDatabaseRole MSFT_SqlDatabaseUser MSFT_SqlRS MSFT_SqlRSSetup MSFT_SqlScript MSFT_SqlScriptQuery MSFT_SqlServerConfiguration MSFT_SqlServerDatabaseMail MSFT_SqlServerEndpoint MSFT_SqlServerEndpointPermission MSFT_SqlServerEndpointState MSFT_SqlServerLogin MSFT_SqlServerMaxDop MSFT_SqlServerMemory MSFT_SqlServerNetwork MSFT_SqlServerPermission MSFT_SqlServerReplication MSFT_SqlServerRole MSFT_SqlServerSecureConnection MSFT_SqlServiceAccount MSFT_SqlSetup MSFT_SqlWaitForAG MSFT_SqlWindowsFirewall

Dependencies

This module has no dependencies.

Release Notes

- 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)).

FileList

Version History

Version Downloads Last updated
16.6.0-previ... 89 3/3/2024
16.6.0-previ... 45 1/20/2024
16.6.0-previ... 5 1/19/2024
16.5.1-previ... 67 12/15/2023
16.5.1-previ... 90 11/19/2023
16.5.1-previ... 46 11/2/2023
16.5.0 136,383 10/5/2023
16.5.0-previ... 11 10/1/2023
16.5.0-previ... 6 9/29/2023
16.5.0-previ... 46 9/1/2023
16.5.0-previ... 6 8/26/2023
16.4.1-previ... 5 8/25/2023
16.4.0 111,242 8/22/2023
16.4.0-previ... 4 8/20/2023
16.4.0-previ... 4 8/20/2023
16.4.0-previ... 5 8/19/2023
16.4.0-previ... 75 5/18/2023
16.4.0-previ... 19 5/10/2023
16.4.0-previ... 5 5/9/2023
16.4.0-previ... 6 5/8/2023
16.3.1 459,383 5/6/2023
16.3.1-previ... 4 5/6/2023
16.3.1-previ... 8 5/4/2023
16.3.0 42,103 4/26/2023
16.3.0-previ... 6 4/26/2023
16.3.0-previ... 5 4/25/2023
16.3.0-previ... 5 4/24/2023
16.3.0-previ... 5 4/23/2023
16.3.0-previ... 20 4/18/2023
16.3.0-previ... 4 4/16/2023
16.2.1-previ... 6 4/12/2023
16.2.0 74,991 4/10/2023
16.2.0-previ... 4 4/10/2023
16.2.0-previ... 4 4/8/2023
16.2.0-previ... 4 4/8/2023
16.2.0-previ... 9 4/6/2023
16.2.0-previ... 9 4/1/2023
16.2.0-previ... 10 3/28/2023
16.2.0-previ... 9 3/26/2023
16.2.0-previ... 4 3/25/2023
16.2.0-previ... 169 3/19/2023
16.2.0-previ... 26 3/7/2023
16.2.0-previ... 9 3/4/2023
16.1.0 175,465 2/28/2023
16.1.0-previ... 5 2/28/2023
16.1.0-previ... 8 2/25/2023
16.1.0-previ... 5 2/24/2023
16.1.0-previ... 47 2/13/2023
16.1.0-previ... 27 2/12/2023
16.1.0-previ... 24 2/5/2023
16.1.0-previ... 10 2/1/2023
16.1.0-previ... 28 1/25/2023
16.1.0-previ... 7 1/24/2023
16.1.0-previ... 4 1/24/2023
16.1.0-previ... 11 1/22/2023
16.1.0-previ... 345 1/4/2023
16.1.0-previ... 5 1/3/2023
16.1.0-previ... 14 12/26/2022
16.1.0-previ... 49 12/19/2022
16.1.0-previ... 12 12/17/2022
16.1.0-previ... 114 12/11/2022
16.1.0-previ... 12 12/4/2022
16.1.0-previ... 35 11/26/2022
16.1.0-previ... 10 11/24/2022
16.0.1-previ... 30 11/11/2022
16.0.0 826,625 9/9/2022
16.0.0-previ... 29 8/21/2022
16.0.0-previ... 23 8/13/2022
16.0.0-previ... 14 8/13/2022
16.0.0-previ... 25 8/1/2022
16.0.0-previ... 80 6/14/2022
16.0.0-previ... 24 6/8/2022
16.0.0-previ... 17 6/6/2022
16.0.0-previ... 14 6/6/2022
16.0.0-previ... 88 4/26/2022
16.0.0-previ... 44 3/28/2022
16.0.0-previ... 65 2/12/2022
15.2.0 2,683,626 9/1/2021
15.2.0-previ... 15 9/1/2021
15.2.0-previ... 44 7/23/2021
15.2.0-previ... 75 6/6/2021
15.2.0-previ... 65 4/18/2021
15.2.0-previ... 85 3/12/2021
15.1.1 1,379,457 2/12/2021
15.1.1-previ... 17 2/12/2021
15.1.0 62,284 2/2/2021
15.1.0-previ... 24 2/1/2021
15.1.0-previ... 19 1/31/2021
15.0.2-previ... 18 1/30/2021
15.0.2-previ... 24 1/24/2021
15.0.2-previ... 62 1/21/2021
15.0.2-previ... 61 1/12/2021
15.0.1 143,033 1/9/2021
15.0.1-previ... 58 1/9/2021
15.0.1-previ... 63 1/6/2021
15.0.1-previ... 59 1/6/2021
15.0.1-previ... 68 12/27/2020
15.0.1-previ... 59 12/26/2020
15.0.1-previ... 62 12/23/2020
15.0.1-previ... 70 12/14/2020
15.0.1-previ... 61 12/13/2020
15.0.1-previ... 59 12/12/2020
15.0.1-previ... 60 12/10/2020
15.0.0 213,999 12/6/2020
15.0.0-previ... 60 12/6/2020
15.0.0-previ... 65 11/25/2020
15.0.0-previ... 57 11/22/2020
15.0.0-previ... 61 11/21/2020
14.3.0-previ... 98 10/5/2020
14.3.0-previ... 54 10/3/2020
14.3.0-previ... 60 10/2/2020
14.2.2-previ... 104 8/19/2020
14.2.2-previ... 60 8/16/2020
14.2.1 639,716 8/14/2020
14.2.1-previ... 59 8/13/2020
14.2.1-previ... 60 8/11/2020
14.2.1-previ... 56 8/11/2020
14.2.1-previ... 71 7/31/2020
14.2.1-previ... 59 7/28/2020
14.2.0 72,567 7/23/2020
14.2.0-previ... 62 7/23/2020
14.2.0-previ... 64 7/19/2020
14.2.0-previ... 73 7/13/2020
14.2.0-previ... 64 7/10/2020
14.2.0-previ... 61 7/9/2020
14.1.1-previ... 63 7/9/2020
14.1.0 217,388 7/6/2020
14.1.0-previ... 368 7/5/2020
14.1.0-previ... 60 7/4/2020
14.1.0-previ... 61 7/4/2020
14.1.0-previ... 63 7/3/2020
14.1.0-previ... 65 7/1/2020
14.0.1-previ... 71 6/28/2020
14.0.1-previ... 60 6/26/2020
14.0.0 10,834 6/12/2020
14.0.0-previ... 61 6/12/2020
14.0.0-previ... 67 6/11/2020
14.0.0-previ... 69 6/10/2020
14.0.0-previ... 68 6/10/2020
14.0.0-previ... 102 5/28/2020
14.0.0-previ... 77 5/25/2020
14.0.0-previ... 67 5/25/2020
14.0.0-previ... 79 5/19/2020
14.0.0-previ... 75 5/19/2020
14.0.0-previ... 81 5/17/2020
14.0.0-previ... 70 5/17/2020
14.0.0-previ... 68 5/16/2020
14.0.0-previ... 69 5/14/2020
14.0.0-previ... 71 5/13/2020
14.0.0-previ... 79 5/12/2020
14.0.0-previ... 69 5/12/2020
14.0.0-previ... 69 5/12/2020
14.0.0-previ... 82 5/8/2020
14.0.0-previ... 68 5/6/2020
14.0.0-previ... 72 5/5/2020
14.0.0-previ... 70 5/4/2020
14.0.0-previ... 69 5/3/2020
14.0.0-previ... 68 5/3/2020
14.0.0-previ... 83 4/27/2020
14.0.0-previ... 78 4/26/2020
13.5.0 28,263 4/12/2020
13.5.0-previ... 75 4/11/2020
13.5.0-previ... 77 4/11/2020
13.4.1-previ... 104 3/31/2020
13.4.0 122,342 3/18/2020
13.4.0-previ... 70 3/18/2020
13.3.1-previ... 116 1/18/2020
13.3.0 480,200 1/17/2020
13.3.0-previ... 73 1/17/2020
13.3.0-previ... 78 1/12/2020
13.3.0-previ... 72 1/8/2020
13.3.0-previ... 75 1/7/2020
13.3.0-previ... 72 1/3/2020
13.3.0-previ... 73 1/2/2020
13.3.0-previ... 74 1/2/2020
13.2.0.0 860,586 9/19/2019
13.1.0.0 (current version) 34,990 8/8/2019
13.0.0.0 26,018 6/26/2019
12.5.0.0 17,355 5/15/2019
12.4.0.0 21,699 4/3/2019
12.3.0.0 40,221 2/20/2019
12.2.0.0 8,926 1/10/2019
12.1.0.0 23,219 10/25/2018
12.0.0.0 21,421 9/5/2018
11.4.0.0 16,150 7/25/2018
11.3.0.0 7,377 6/13/2018
11.2.0.0 5,037 5/2/2018
11.1.0.0 6,197 3/22/2018
11.0.0.0 12,854 2/8/2018
10.0.0.0 3,648 12/14/2017
Show less