SqlServerDsc

10.0.0.0

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

Minimum PowerShell version

5.0

Installation Options

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

Install-Module -Name SqlServerDsc -RequiredVersion 10.0.0.0

You can deploy this package directly to Azure Automation. Note that deploying packages with dependencies will deloy 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

Author(s)

Microsoft Corporation

Copyright

(c) 2017 Microsoft Corporation. All rights reserved.

Owners

Tags

DesiredStateConfiguration DSC DSCResourceKit DSCResource

DSCResources

SqlAG SqlAGDatabase SqlAGListener SqlAGReplica SqlAlias SqlAlwaysOnService SqlDatabase SqlDatabaseDefaultLocation SqlDatabaseOwner SqlDatabasePermission SqlDatabaseRecoveryModel SqlDatabaseRole SqlRS SqlRSSecureConnectionLevel SqlScript SqlServerConfiguration SqlServerEndpoint SqlServerEndpointPermission SqlServerEndpointState SqlServerLogin SqlServerMaxDop SqlServerMemory SqlServerNetwork SqlServerPermission SqlServerReplication SqlServerRole SqlServiceAccount SqlSetup SqlWaitForAG SqlWindowsFirewall

Dependencies

This module has no dependencies.

Release Notes

- BREAKING CHANGE: Resource module has been renamed to SqlServerDsc
 ([issue 916](https://github.com/PowerShell/SqlServerDsc/issues/916)).
- BREAKING CHANGE: Significant rename to reduce length of resource names
 - See [issue 851](https://github.com/PowerShell/SqlServerDsc/issues/851) for a
   complete table mapping rename changes.
 - Impact to all resources.
- Changes to CONTRIBUTING.md
 - Added details to the naming convention used in SqlServerDsc.
- Changes to SqlServerDsc
 - The examples in the root of the Examples folder are obsolete. A note was
   added to the comment-based help in each example stating it is obsolete.
   This is a temporary measure until they are replaced
   ([issue 904](https://github.com/PowerShell/SqlServerDsc/issues/904)).
 - Added new common test (regression test) for validating the long path
   issue for compiling resources in Azure Automation.
 - Fix resources in alphabetical order in README.md ([issue 908](https://github.com/PowerShell/SqlServerDsc/issues/908)).
- Changes to SqlAG
 - BREAKING CHANGE: Parameters SQLServer and SQLInstanceName has been renamed
   to ServerName and InstanceName respectively
   ([issue 308](https://github.com/PowerShell/SqlServerDsc/issues/308)).
 - BREAKING CHANGE: The read-only property SQLServerNetName was removed in favor
   of EndpointHostName ([issue 924](https://github.com/PowerShell/SqlServerDsc/issues/924)).
   Get-TargetResource will now return the value of property [NetName](https://technet.microsoft.com/en-us/library/microsoft.sqlserver.management.smo.server.netname(v=sql.105).aspx)
   for the property EndpointHostName.
- Changes to SqlAGDatabase
 - BREAKING CHANGE: Parameters SQLServer and SQLInstanceName has been renamed
   to ServerName and InstanceName respectively
   ([issue 308](https://github.com/PowerShell/SqlServerDsc/issues/308)).
 - Changed the Get-MatchingDatabaseNames function to be case insensitive when
   matching database names ([issue 912](https://github.com/PowerShell/SqlServerDsc/issues/912)).
- Changes to SqlAGListener
 - BREAKING CHANGE: Parameter NodeName has been renamed to ServerName
   ([issue 308](https://github.com/PowerShell/SqlServerDsc/issues/308)).
- Changes to SqlAGReplica
 - BREAKING CHANGE: Parameters SQLServer and SQLInstanceName has been renamed
   to ServerName and InstanceName respectively
   ([issue 308](https://github.com/PowerShell/SqlServerDsc/issues/308)).
 - BREAKING CHANGE: Parameters PrimaryReplicaSQLServer and PrimaryReplicaSQLInstanceName
   has been renamed to PrimaryReplicaServerName and PrimaryReplicaInstanceName
   respectively ([issue 922](https://github.com/PowerShell/SqlServerDsc/issues/922)).
 - BREAKING CHANGE: The read-only property SQLServerNetName was removed in favor
   of EndpointHostName ([issue 924](https://github.com/PowerShell/SqlServerDsc/issues/924)).
   Get-TargetResource will now return the value of property [NetName](https://technet.microsoft.com/en-us/library/microsoft.sqlserver.management.smo.server.netname(v=sql.105).aspx)
   for the property EndpointHostName.
- Changes to SqlAlwaysOnService
 - BREAKING CHANGE: Parameters SQLServer and SQLInstanceName has been renamed
   to ServerName and InstanceName respectively
   ([issue 308](https://github.com/PowerShell/SqlServerDsc/issues/308)).
- Changes to SqlDatabase
 - BREAKING CHANGE: Parameters SQLServer and SQLInstanceName has been renamed
   to ServerName and InstanceName respectively
   ([issue 308](https://github.com/PowerShell/SqlServerDsc/issues/308)).
- Changes SqlDatabaseDefaultLocation
 - BREAKING CHANGE: Parameters SQLServer and SQLInstanceName has been renamed
   to ServerName and InstanceName respectively
   ([issue 308](https://github.com/PowerShell/SqlServerDsc/issues/308)).
- Changes to SqlDatabaseOwner
 - BREAKING CHANGE: Parameters SQLServer and SQLInstanceName has been renamed
   to ServerName and InstanceName respectively
   ([issue 308](https://github.com/PowerShell/SqlServerDsc/issues/308)).
- Changes to SqlDatabasePermission
 - BREAKING CHANGE: Parameters SQLServer and SQLInstanceName has been renamed
   to ServerName and InstanceName respectively
   ([issue 308](https://github.com/PowerShell/SqlServerDsc/issues/308)).
- Changes to SqlDatabaseRecoveryModel
 - BREAKING CHANGE: Parameters SQLServer and SQLInstanceName has been renamed
   to ServerName and InstanceName respectively
   ([issue 308](https://github.com/PowerShell/SqlServerDsc/issues/308)).
- Changes to SqlDatabaseRole
 - BREAKING CHANGE: Parameters SQLServer and SQLInstanceName has been renamed
   to ServerName and InstanceName respectively
   ([issue 308](https://github.com/PowerShell/SqlServerDsc/issues/308)).
- Changes to SqlRS
 - BREAKING CHANGE: Parameters RSSQLServer and RSSQLInstanceName has been renamed
   to DatabaseServerName and DatabaseInstanceName respectively
   ([issue 923](https://github.com/PowerShell/SqlServerDsc/issues/923)).
- Changes to SqlServerConfiguration
 - BREAKING CHANGE: Parameters SQLServer and SQLInstanceName has been renamed
   to ServerName and InstanceName respectively
   ([issue 308](https://github.com/PowerShell/SqlServerDsc/issues/308)).
- Changes to SqlServerEndpoint
 - BREAKING CHANGE: Parameters SQLServer and SQLInstanceName has been renamed
   to ServerName and InstanceName respectively
   ([issue 308](https://github.com/PowerShell/SqlServerDsc/issues/308)).
- Changes to SqlServerEndpointPermission
 - BREAKING CHANGE: Parameter NodeName has been renamed to ServerName
   ([issue 308](https://github.com/PowerShell/SqlServerDsc/issues/308)).
 - Now the examples files have a shorter name so that resources will not fail
   to compile in Azure Automation ([issue 934](https://github.com/PowerShell/SqlServerDsc/issues/934)).
- Changes to SqlServerEndpointState
 - BREAKING CHANGE: Parameter NodeName has been renamed to ServerName
   ([issue 308](https://github.com/PowerShell/SqlServerDsc/issues/308)).
- Changes to SqlServerLogin
 - BREAKING CHANGE: Parameters SQLServer and SQLInstanceName has been renamed
   to ServerName and InstanceName respectively
   ([issue 308](https://github.com/PowerShell/SqlServerDsc/issues/308)).
- Changes to SqlServerMaxDop
 - BREAKING CHANGE: Parameters SQLServer and SQLInstanceName has been renamed
   to ServerName and InstanceName respectively
   ([issue 308](https://github.com/PowerShell/SqlServerDsc/issues/308)).
- Changes to SqlServerMemory
 - BREAKING CHANGE: Parameters SQLServer and SQLInstanceName has been renamed
   to ServerName and InstanceName respectively
   ([issue 308](https://github.com/PowerShell/SqlServerDsc/issues/308)).
- Changes to SqlServerNetwork
 - BREAKING CHANGE: Parameters SQLServer has been renamed to ServerName
   ([issue 308](https://github.com/PowerShell/SqlServerDsc/issues/308)).
- Changes to SqlServerPermission
 - BREAKING CHANGE: Parameter NodeName has been renamed to ServerName
   ([issue 308](https://github.com/PowerShell/SqlServerDsc/issues/308)).
- Changes to SqlServerRole
 - BREAKING CHANGE: Parameters SQLServer and SQLInstanceName has been renamed
   to ServerName and InstanceName respectively
   ([issue 308](https://github.com/PowerShell/SqlServerDsc/issues/308)).
- Changes to SqlServerServiceAccount
 - BREAKING CHANGE: Parameters SQLServer and SQLInstanceName has been renamed
   to ServerName and InstanceName respectively
   ([issue 308](https://github.com/PowerShell/SqlServerDsc/issues/308)).

Version History

Version Downloads Last updated
12.1.0.0 7,275 10/25/2018
12.0.0.0 8,718 9/5/2018
11.4.0.0 13,657 7/25/2018
11.3.0.0 5,916 6/13/2018
11.2.0.0 3,252 5/2/2018
11.1.0.0 3,356 3/22/2018
11.0.0.0 7,793 2/8/2018
10.0.0.0 (current version) 2,926 12/14/2017
Show less