nanoDBA

# 2023-06-29 version originally by nanoDBA, greatly enhanced by OpenAI's ChatGPT model
<#
.SYNOPSIS
Get the volumes attached to the EC2 instances.

.DESCRIPTION
This function retrieves the volumes attached to the specified EC2 instances in the specified region.
It returns a list of volume details including the instance ID, instance name, instance type, volume ID, device name, state, availability zone, volume type, IOPS, throughput, and size.

.PARAMETER InstanceNames

nanoDBA

# filename: Lock_and_power_off_display.ps1
#
# This script turns off the display and locks the workstation using the Windows API.
#
# Warning: This script will turn off the display and lock the workstation indefinitely until stopped manually.
# 
# Import the necessary libraries for interacting with the Windows API
Add-Type @"
using System;
using System.Runtime.InteropServices;

nanoDBA

# create an array of SQL Server instances
$allInstances = @('server1', 'server2', 'server3')

# Loop through each SQL server instance
foreach($sqlInstance in $allInstances) { 

    # Output the current SQL server instance
    Write-Output "`$sqlInstance: $sqlInstance"

    # Execute a query on the current SQL server instance and store the results

nanoDBA

# Console Output RED/GREEN failures for SQL Agent job history, multiple key property sorts
# attempting to imitate the output of the SQL Server Management Studio Job History window

$paramHash = @{
    SqlInstance     = 'YOURSERVER01','YOURSERVER02'        # comma separated list of SQL Server instances
    StartDate       = "$(((Get-Date).AddDays(-.1) ))"      # 0.1 days ago - ARE YOU SURE? This does not mean 1 day.  It means 2.4 hours ago.
#    StartDate       = "$(((Get-Date).AddDays(-90) ))"     # 90 days ago
    EndDate         = "$((Get-Date ))"                     # now
    Job             = 'Some SQL Agent Job Name goes here'  # name of SQL Agent job goes here
    ExcludeJobSteps = $false

nanoDBA

Proposed SQL Server Patching Approach
We do not patch to the absolute latest cumulative update(CU).

Rather, we strive to patch to the cumulative update(CU) that 
was released without any intermediate releases(such as hotfixes) 
between it and the most recent CU. Basically N-1 as long as 
there aren't any hotfixes. If there were hotfixes then we'll wait 
until two CU subsequent releases have occurred 
without hotfixes in between the two to deploy the CU.

nanoDBA

$sourceFrameRate = 10.74
$filename = "C:\Users\kilroy\2023-02-17_17-37-36_boxstarter_2_of_2.mp4"
$newFilename = "$(dir $filename | foreach { Join-Path -Path $_.Directory -ChildPath $_.BaseName })_remove_nonmotion_mute_audio.mp4"

ffmpeg.exe -i "$($filename)" -vf "select=gt(scene\,0.0002),setpts=N/($($sourceFrameRate)*TB)" -an "$($newFilename)"

<# -an remove audio #>
<# -vf "select=gt(scene\,0.001),setpts=N/(<framerategoeshere>*TB)"  #>

<# https://superuser.com/questions/984841/ffmpeg-remove-parts-without-motion/1029175#1029175

nanoDBA

<#
.SYNOPSIS
	BoxStarter script to configure Windows 10 development PC.

.DESCRIPTION

	You might need to set: 
			Set-ExecutionPolicy RemoteSigned
			Set-ExecutionPolicy Unrestricted
			Set-ExecutionPolicy Bypass

nanoDBA

do {
    $ssms = Get-WmiObject -Class Win32_Process -Filter "name = 'Ssms.exe'"
    <# Timer/time bomb stub #> $now = Get-Date
    $timespan = New-TimeSpan -Start $now -End (Get-Date).AddMinutes(55)      # '20:25') #'2077-10-09 19:30'
    Write-Host -ForegroundColor magenta "SSMS active user count: $(($ssms.GetOwner()).User.count)"
    Write-Host -ForegroundColor magenta "SSMS active users: $(($ssms.GetOwner()).User)"
    Write-Host -ForegroundColor magenta "Sleeping until $((Get-date).AddSeconds($timespan.TotalSeconds)) ..."
    Start-Sleep -Seconds $timespan.TotalSeconds
}
while ( ($ssms.GetOwner()).User.count -GT 0 )

nanoDBA

### Get Command Line History for all users
# source: https://gist.github.com/nanoDBA/48f2cd1eab1e4433a97bd106e0dac08d
$dirs = (Get-ChildItem -Directory (Split-Path $env:USERPROFILE)).FullName | Sort-Object

$allHistories = foreach($profileDir in $dirs){
    Write-Output "### $profileDir"
    $historySavePath = "$profileDir\AppData\Roaming\Microsoft\Windows\PowerShell\PSReadLine\ConsoleHost_history.txt"
    if(!(Test-Path ($historySavePath) )) {
        Write-Output "### $historySavePath does not exist"
    }

nanoDBA

# Yesterday was the winter solstice, so I am looking forward to more daylight!
# https://stackoverflow.com/questions/63236774/powershell-return-only-sunrise-sunset-time/63237047#63237047
# using API from https://sunrise-sunset.org/api

$lat = 35.787743 ; $long = -78.644257 # substitute desired latitude/longitude

# date range: 2 days ago until tomorrow and Loop de Loop using foreach
-2..1 | foreach {
    $Date = (Get-Date).AddDays($_) | Get-Date -Format "yyyy-MM-dd"
    $Daylight = (Invoke-RestMethod "https://api.sunrise-sunset.org/json?lat=$lat&lng=$long&formatted=0&date=$Date").results