potatoqualitee

$servers = 'sql01','sql02','sql03'

foreach ($server in $servers) {
    Invoke-Command -ComputerName $server -ScriptBlock {
    $services = Get-CimInstance -ClassName 'Win32_Service' | Where-Object {
        $_.description -match 'sql' -and $_.StartMode -match 'Auto' 
    }
    foreach ($service in $services) { 
        sc.exe failure $service.name reset= 86400 actions= restart/5000/restart/10000/restart/10000/ 
        }

potatoqualitee

# save the newest versions of PackageManagementand PowerShellGet
mkdir C:\temp\psmods
Save-Module PackageManagement, PowerShellGet -Path C:\temp\psmods

# restart the console so that the DLLs are removed from memory and the directories can be removed
exit

# start powershell as administrator
$paths = "C:\Program Files\WindowsPowerShell\Modules\PackageManagement", "C:\Program Files\WindowsPowerShell\Modules\PowerShellGet"

potatoqualitee

function findshit ($str) {
    $str = [regex]::escape($str)
    Select-String -Pattern $str -Path (Get-ChildItem C:\github\dbatools\*.ps* -Recurse  -Exclude 'allcommands.ps1', '*.dll', "*psproj")
}

potatoqualitee

Something we appreciate about PowerShell and dbatools is that there are often a number of perfectly valid ways to solve the same problem. Considering this, some of the questions have multiple answers.

Some answers are different ways to express the same solution.

Chapter 2

Find all commands that have DbaReg in their name.

Get-Command *dbareg* -Module dbatools
# or

potatoqualitee

Function Export-FileIcon {
	<# 
	.SYNOPSIS
	Export-FileIcon exports high-quality icons stored within .DLL and .EXE files.
	
	.DESCRIPTION
	Export-FileIcon exports high-quality icons stored within .DLL and .EXE files. The function can export to a number of formats, including
	ico, bmp, png, jpg, gif, emf, exif, icon, tiff, and wmf. In addition, it can also export to a different size.
	

potatoqualitee

# thanks https://stackoverflow.com/a/36716601/2610398
function Import-ModuleRemotely {
    param (
        [string]$ModuleName = "xWindowsUpdate",
        [System.Management.Automation.Runspaces.PSSession]$Session
    )
    begin {
        function Exports ([string] $paramName, $dictionary) {
            if ($dictionary.Keys.Count -gt 0) {
                $keys = $dictionary.Keys -join ","

potatoqualitee

function Initialize-DbDisks {
    <#
.SYNOPSIS
    Hello

.DESCRIPTION
    VMware only, and Windows and Mount points

.PARAMETER Path
    The Path to the STIG xml file. Not required, as they've been included.

potatoqualitee

# No longer used but didn't want to throw it away.
function Invoke-WsusDbQuery {
    [CmdletBinding()]
    param (
        [string]$ComputerName = $script:WsusServer,
        [PSCredential]$Credential = $script:WsusServerCredential,
        [string]$Pattern,
        [string]$UpdateId,
        [switch]$EnableException
    )

potatoqualitee

function Save-KBFile {
    <#
    .SYNOPSIS
        Downloads patches from Microsoft

    .DESCRIPTION
         Downloads patches from Microsoft

    .PARAMETER Name
        The KB name or number. For example, KB4057119 or 4057119.

potatoqualitee

Set-Content -Encoding UTF8 -Path C:\github\dbatools\allcommands.ps1 -Value "### DO NOT EDIT THIS FILE DIRECTLY ###"
Get-ChildItem -Path "C:\github\dbatools\functions\*.ps1" -Recurse | Get-Content | Add-Content C:\github\dbatools\allcommands.ps1
Get-ChildItem -Path "C:\github\dbatools\internal\functions\*.ps1" -Recurse | Get-Content | Add-Content C:\github\dbatools\allcommands.ps1

Remove-Item -Recurse C:\gallery -Force
mkdir C:\gallery\dbatools
robocopy c:\github\dbatools C:\gallery\dbatools /S /XF *.psproj* *.git* *.yml /XD .git .github Tests .vscode | Out-String | Out-Null

Remove-Item -Recurse C:\gallery\dbatools\bin\build -ErrorAction Ignore
Remove-Item -Recurse C:\gallery\dbatools\bin\projects -ErrorAction Ignore