Automating installation of SSMS with DSC

Over the past few months I’ve had a couple of customers ask me, “Now that SQL 2016 doesn’t include SSMS how am I supposed to automate the installation?”.  Typically my response is you shouldn’t be installing it on your servers as its just an additional item that will require patching.  However there are times its…

2

Introducing LabInaBox

Do you have a need to spin up a sandbox lab environment quickly to test DSC configurations, updates or really anything?  In writing DSC configurations over the last year I have found the need to do this often.  To simplify things I put together a few configurations and scripts to assist going forward.  The solution can…

0

Introducing DSC Data Driven Deployment

Working with customers over the past year, many have asked: How can we manage SQL Server configurations at scale in a large enterprise?  PowerShell DSC provides a configuration framework out of the box, however, there isn’t a way to quickly build SQL deployment templates and provision in a DevOps fashion without using a third party product. A colleague and I took on the…

0

SQL DSC Encrypted Configuration

Following up on my last post about new changes coming to xSQLServer. Today I want to talk about two additional Example scripts which have been provided with the new updates. The first script is DSCSqlBuild.ps1. This new script adds a couple of items SQLPush_SingleServer.ps1 doesn’t have. DSCSQLBuild.ps1 like DSCClusterSQLBuild.ps1 adds a timer to the configuration…

0

SQL DSC AlwaysOn Support

New updates are coming to xSQLServer, they should be available shortly after this post, and will provide support for AlwaysOn Availability groups. Along with the updates are three new example scripts. The three scripts are the following: DSCSQLBuild.ps1, DSCClusterSQLBuild.ps1, and DSCSQLBuildEncrypted.ps1. This blog post will talk specifically about DSCClusterSQLBuild.ps1. This example shows how to leverage…

7

Desired State Configuration(DSC) for SQL Server

  Many people are not familiar with DSC yet so lets first start with what is DSC and why we as DBA’s should care.  DSC is a management framework in PowerShell.  DSC allows us to deploy and manage configuration data. Some examples of practical applications would be the following: Enabling/Disabling server roles and features Managing…

4

AlwaysOn Availability Group Automation Part 2

  Last post I talked about the function NewCustomAg which allows you to create availability groups. After running it, you will have an availability group created with one or no databases. Most likely you will want to add several databases to each availability group.  One option would be to utilize the GUI wizard, however, if…

0

AlwaysOn Availability Group Automation Part 1

AlwaysOn Availability Group Automation Part 1   Do you have a need to create multiple availability groups?  Do you wish there was an easy way script and deploy them consistently? PowerShell to the rescue!  PowerShell is the DBA’s best friend in that there are many tasks which can be simplified and automated, saving the DBA precious time…

1