Decode PowerShell Command from Running Processes

There are times when I’ve found a PowerShell process running that is taking up a bunch of resources. Sometimes they’ve even been my own scripts running in the context of a SQL Server Agent Job with a PowerShell job step. Because I can have multiple PowerShell job steps running at a time, sometimes it’s difficult…

0

Install SQL Server 2017 Using PowerShell Desired State Configuration and SqlServerDsc

How many times have you clicked through the SQL Server installation interface just clicking the same old buttons, entering the same old information, not giving it much of a second thought? Then the installation finishes and the realization of “I forgot to specify the DBA group in the sysadmins role” hits. Now you have to…

0

Dynamically Determine a DSC Configuration Name Inside a Configuration

I ran across a scenario where I needed to reference the name of the configuration inside the configuration. I was looking for an automatic variable that contained this information, however I was unable to locate one searching online or by asking colleagues. The suggestions I received were to call the Get-PSCallStack cmdlet or use the $MyInvocation automatic variable….

0

Install SQL Server 2017 Using PowerShell Desired State Configuration

Update: The xSQLServer DSC resource has been renamed to SqlServerDsc. An updated version of this article has been created and published here. How many times have you clicked through the SQL Server installation interface just clicking the same old buttons, entering the same old information, not giving it much of a second thought? Then the…

2