Troy Ault's Blog
Desired State Configuration(DSC) for SQL Server ***Update 2
Following up from my last post I have published the Failover Cluster Instance composite...
Author: Troy Ault Date: 10/20/2017
Desired State Configuration(DSC) for SQL Server ***Update
Over the past few months several individuals/customers have asked me for updated examples of the...
Author: Troy Ault Date: 10/09/2017
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...
Author: Troy Ault Date: 08/30/2017
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...
Author: Troy Ault Date: 08/29/2017
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...
Author: Troy Ault Date: 08/21/2017
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...
Author: Troy Ault Date: 05/02/2017
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...
Author: Troy Ault Date: 01/13/2017
Introducing LabInaBox
Do you have a need to spin up a sandbox lab environment quickly to test DSC configurations, updates...
Author: Troy Ault Date: 11/22/2016
Introducing DSC Data Driven Deployment
Working with customers over the past year, many have asked: How can...
Author: Troy Ault Date: 09/09/2016
SQL DSC Encrypted Configuration
Following up on my last post about new changes coming to xSQLServer. Today I want to talk about two...
Author: Troy Ault Date: 04/25/2016
SQL DSC AlwaysOn Support
New updates are coming to xSQLServer, they should be available shortly after this post, and will...
Author: Troy Ault Date: 04/22/2016
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...
Author: Troy Ault Date: 08/31/2015
AlwaysOn Availability Group Automation Part 2
Last post I talked about the function NewCustomAg which allows you to create availability groups....
Author: Troy Ault Date: 06/23/2015
AlwaysOn Availability Group Automation Part 1
AlwaysOn Availability Group Automation Part 1 Do you have a need to create multiple availability...
Author: Troy Ault Date: 06/18/2015