Patrick Curran PCfromDC
PCfromDC
/ 4- Install SQL03.ps1
Last active
November 25, 2015 20:38
Ignite 2015 session Using Desired State Configuration to Deploy SQL
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| $nodeName = "SQL03" | |
| Configuration SQL2014 { | |
| param ($nodeName) | |
| Node $nodeName { | |
| #region Set Parameters | |
| $isoName = "en_sql_server_2014_enterprise_edition_x64_dvd_3932700.iso" |
PCfromDC
/ Sync AD to SQL.ps1
Last active
November 8, 2019 16:55
This is a PowerShell script that grabs all users from AD and puts them into a SQL table.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # Array of Domain Controller Server Names | |
| $DCs = @("DC01","DC02","DC03") | |
| # Database Server | |
| $dbServer = "sql2012-03" | |
| # Database Name | |
| $databaseName = "pcDemo_Personnel" | |
| # Production System User Table Name |
NewerOlder