PowerSQL
Bringing PowerShell and SQL together for the best of both worlds.
SYSTEM Permissions in SQL Server
Okay folks, we need to have a conversation about SYSTEM permissions in SQL Server. SYSTEM is...
Author: randomnote_1 Date: 09/09/2018
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....
Author: randomnote_1 Date: 12/14/2017
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...
Author: randomnote_1 Date: 12/13/2017
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...
Author: randomnote_1 Date: 10/31/2017
Install SQL Server 2017 Using PowerShell Desired State Configuration
Update: The xSQLServer DSC resource has been renamed to SqlServerDsc. An updated version of this...
Author: randomnote_1 Date: 10/10/2017