Desired State Configuration(DSC) for SQL Server ***Update 2

Following up from my last post I have published the Failover Cluster Instance composite configurations and updated the previous configurations.  Initially lets talk about the updates to the which were pushed. Single Instance, Primary AlwaysOn,  and Secondary AlwaysOn  all had additional optional parameters added enabling all configurable items to be leveraged.  Each of these are…

5

Desired State Configuration(DSC) for SQL Server ***Update

Over the past few months several individuals/customers have asked me for updated examples of the latest xSQLServer Resource.  As of this post, the current version is 8.2.0.0.  Throughout this post I will provide reference to configurations which are actually calling composite resources.  If you haven’t heard of composite resources, then the following reference will explain…

8

Automating Lab Environments with LabInaBox on Prem or in the Cloud.

Today building out repeatable demo/lab environments quickly has become a necessity.  Previous this year I released LabInaBox which provided for a quick way to build out lab environments on a Windows 10 machine using Hyper-V.  As more and more customers are looking at Azure I wanted to provide a similar experience for cloud lab deployment….

0

Utilizing Key Vault to create credentials for automation.

Working with PowerShell I often find myself doing demos which require me to have some form of credentials or other sensitive data.  In the past I’ve used really generic passwords which are easy to work with but always leave a bad taste in your mouth because the passwords are stored in plain text.  Azure has…

0

Automation with Azure? How to securely script login?

Do you have a need to login to azure securely without being prompted?  Often times I am doing demos or writing automation routines which interact with Azure.  Typically you will see one of two things: Get-Credential $PlainPassword = “P@ssw0rd” $SecurePassword = $PlainPassword | ConvertTo-SecureString -AsPlainText -Force The first one is painful because it requires input from the user running the script and the…

0

Creating a SQL container that’s always the Latest build

Want to stay current with the latest SQL server builds so you can test new features?  Or want the ability to have a quick SQL instance up and running as a development environment?  Now with Docker for Windows and Windows 10 there is a quick and easy way to do both.  In this blog post…

0

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…

6

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