Category Archives: Automation

Automated Configuration Management: Deploying SQL Server via PowerShell DSC

Desired State Configuration (DSC) is a new PowerShell feature that manages Windows infrastructure (servers and applications), both on premises and in the cloud. It’s built into PowerShell 4.0 and is part of the Windows Management Framework. PowerShell DSC comes shipped … Continue reading

Posted in Automation, Deployment | Leave a comment

Configuring SQL Server to use Managed Service Accounts (in PowerShell)

When building out a new SQL Server environment, one consideration is the service account used to run SQL services. In SQL 2014 there are five options to choose from: Local Account Built-in Account – The Local Service, Network Service or … Continue reading

Posted in Administration, Automation, PowerShell, Scripting | 1 Comment