| Param([string]$ComputerName) | |
| [System.Collections.Generic.IDictionary[[uint32],[string]]]$statusCodes = New-Object -TypeName 'System.Collections.Generic.Dictionary[[uint32],[string]]' | |
| # list from https://docs.microsoft.com/en-us/previous-versions/windows/desktop/wmipicmp/win32-pingstatus | |
| @' | |
| Success (0) | |
| Buffer Too Small (11001) | |
| Destination Net Unreachable (11002) | |
| Destination Host Unreachable (11003) | |
| Destination Protocol Unreachable (11004) | |
| Destination Port Unreachable (11005) |
| function ConvertTo-Icon { | |
| [CmdletBinding(DefaultParameterSetName = 'BySuffix')] | |
| Param ( | |
| # Specifies the source image filename | |
| [Parameter(Mandatory = $true, ValueFromPipeline = $true)] | |
| [string]$Path | |
| , | |
| # the name of the .ico file | |
| [Parameter(Mandatory = $true, ParameterSetName = 'ByLiteralName')] |
| declare @sp_who2 table ( | |
| Spid int | |
| ,[Status] varchar(255) | |
| ,[Login] varchar(255) | |
| ,HostName varchar(255) | |
| ,BlkBy varchar(255) | |
| ,DBName varchar(255) | |
| ,Command varchar(255) | |
| ,CpuTime int | |
| ,DiskIo int |
| Function New-TelnetClient { | |
| [CmdletBinding()] | |
| Param ( | |
| [Parameter()] | |
| [string]$ComputerName = '127.0.0.1' | |
| , | |
| [Parameter()] | |
| [int]$PortNo = 23 | |
| , |
| Add-Type -Path (Get-Command 'Microsoft.SqlServer.Management.UserSettings.dll').Source | |
| [bool]$loaded = $false | |
| Get-Item -Path 'C:\Windows\assembly\GAC_MSIL\Microsoft.SqlServer.ConnectionInfo\*\Microsoft.SqlServer.ConnectionInfo.dll' | Select-Object -ExpandProperty FullName | Sort-Object -Descending | ForEach-Object {if (!$loaded ){try {Add-Type -Path $_;Write-Verbose "Successfully loaded $_";$loaded=$true}catch{Write-Warning "Failed to load $_"}}} | |
| [string]$settingsFilePath = (Resolve-Path (Join-Path -Path $env:APPDATA -ChildPath 'Microsoft/SQL Server Management Studio/*/SqlStudio.bin')).Path | Sort-Object -Descending | Select-Object -First 1 | |
| if ($settingsFilePath) { | |
| try { | |
| [System.IO.MemoryStream]$ms = [System.IO.File]::ReadAllBytes($settingsFilePath) | |
| [System.Runtime.Serialization.Formatters.Binary.BinaryFormatter]$formatter = New-Object -TypeName 'System.Runtime.Serialization.Formatters.Binary.BinaryFormatter' | |
| [Microsoft.SqlServer.Management.UserSettings.SqlStudio]$sqlStudio = $form |
| $source = '\\path\to\source' | |
| $destination = '\\path\to\dest' | |
| robocopy "$source" "$destination" /zb /e /xf * | |
| <# | |
| See https://ss64.com/nt/robocopy.html for notes | |
| /zb - If you get access denied on a folder, try using backup mode to access it (see http://www.rainingforks.com/blog/2015/suggested-robocopy-switches-explained.html for detail) | |
| /e - Copy subfolders (/s), including empty ones. | |
| /xf * - exclude files matching a filename pattern; in this case any filename, so only copy directories | |
| Note: dest will contain the child folders of source; not source itself. |
| #based on code from https://stackoverflow.com/questions/113542/how-can-i-uninstall-an-application-using-powershell | |
| function Uninstall-Application { | |
| [CmdletBinding(SupportsShouldProcess = $true)] | |
| Param ( | |
| [Parameter(Mandatory = $true)] |
| copy-item 'C:\Windows\winsxs\amd64_microsoft-windows-cleanmgr_31bf3856ad364e35_6.1.7600.16385_none_c9392808773cd7da\cleanmgr.exe' 'c:\windows\system32\' | |
| copy-item 'C:\Windows\winsxs\amd64_microsoft-windows-cleanmgr.resources_31bf3856ad364e35_6.1.7600.16385_en-us_b9cb6194b257cc63\cleanmgr.exe.mui' 'c:\windows\system32\en-US\' |
| #Simulation of https://youtu.be/6JwEYamjXpA?t=1870 | |
| function Get-CoinTossPossibleValues {@('H','T')} | |
| function Get-CoinToss { | |
| [CmdletBinding()] | |
| Param ( | |
| [Parameter()] | |
| [int]$NumberOfTosses = 1 | |
| , | |
| [Parameter()] | |
| [string[]]$PossibleValues = (Get-CoinTossPossibleValues) |
