In video number 45. Secure (HTTPS) DSC Pull Server with SQL Database using a Group Managed Service Account (gMSA), I setup an HTTPS DSC Pull server with a SQL backend using a gMSA to authenticate to SQL. We tested the Pull server simply by accessing the IIS website to...
How to build a Secure (HTTPS) DSC Pull Server with a SQL Database using a Group Managed Service Account (gMSA)
You have seen on the interwebs many blog posts and videos about setting up a Secure DSC pull server with SQL authentication with a local SQL service account. What I have not seen is a tutorial for how to setup a secure DSC Pull Server with a SQL Database...
How to use Chocolatey to Install Software remotely on multiple computers.
In a previous video I used just PowerShell to install software remotely. In this video I show you how to use the Chocolatey packager manager to install packages (software) from the chocolatey repository on multiple computers simultaneously using a single function. Be careful what packages you’re downloading, there are...
Remote Computer Inventory with PowerShell vNext, 2020 Edition
This is the successor to the first inventory script I put together in 2016 (https://www.signalwarrant.com/remote-computer-inventory-powershell/) This version uses the Get-CIMInstance CMDlet to get all the information from the WMI classes as opposed to the WMI CMDlets. I have also added some additional information that I thought was relevant. If...
PowerShell Splatting How-To: I should use it more and so should you!
In my experience splatting is one of those often overlooked and underutilized features of PowerShell. Full disclosure, I don’t use it regularly myself. Most times I just forget it’s a thing. For those that are new to PowerShell, splatting looks more difficult than it really is. The whole idea...
Format and Combine Merch by Amazon Sales reports in seconds with PowerShell
I dabble a bit in Merch by Amazon and have grown to hate the monthly sales reports they give you. For whatever reason, Amazon dumps a bunch of useless information in the first column of the CSV file. Why they do that, I have no idea, but it makes...
How to get the local Administrators of one or many computers remotely with PowerShell.
This is a request that was made by someone a few months ago. It’s been a while so I apologize for not remembering who requested it. We’re using the Win32_GroupUser class to get the local administrators of a computer or many computers remotely. The function is modular enough to...
Visual Studio Code and Azure DevOps (formerly VisualStudio.com) Integration Step-by-Step
My previous video walked through the process of using the old Visual Studio Team Services VS Code extension. That extension has now been deprecated. With the latest version or VS Code (I installed v 1.28.1) you should see the Azure Repos extension baked into VS Code. The only other...
Enterprise Security: How to configure and use Group Managed Service Accounts
I routinely see organizations big and small still using “regular” Active Directory user accounts as service accounts. Typically, they have the password for those service accounts set to never expire or an alternate password policy that only requires the password is changed yearly. If your organization is managing service...
Quickly deploy LAB Virtual Machines with the AutomatedLab PowerShell Framework
My Requirements: Use PowerShell to minimize the time spent on creating VMs. Install ADDS along with the VM creation. Use a differencing disk for all the VMs to save disk space. In the spirit of kickstarting this channel again, I needed to spin up a few Virtual Machines to...