Day: June 15, 2020

blog.KimConnect.com >>
Post Image

Read More

June 15, 2020June 15, 2020 kimconnectkimconnect

PowerShell: Excute Function Remotely

$computername=$env:computerName $adminUsername='doeMainAdmin' $adminPassword='frackingPassword' $adminCredential=New-Object -TypeName System.Management.Automation.PSCredential -ArgumentList $adminUsername,$(ConvertTo-securestring $adminPassword -AsPlainText -Force) function execFunctionRemotely{ param( [Parameter(Mandatory=$true)][string]$computerName,…
0 Comments
Post Image

Read More

June 15, 2020June 15, 2020 kimconnectkimconnect

PowerShell: Install PSTools

if(!(get-command psexec -ea SilentlyContinue)){ if (!(Get-Command choco.exe -ErrorAction SilentlyContinue)) { Set-ExecutionPolicy Bypass -Scope Process -Force;…
0 Comments
Post Image

Read More

June 15, 2020June 15, 2020 kimconnectkimconnect

PowerShell: Microsoft SQL Database Migration

Update 9/25/20: There's another version of this script has has been rewritten form scratch. IMO,…
0 Comments
Post Image

Read More

June 15, 2020June 15, 2020 kimconnectkimconnect

PowerShell: Obtaining SQL Database Default Paths

# This function returns an array of 3 string values reflecting default Data, Log, and…
0 Comments
Post Image

Read More

June 15, 2020June 15, 2020 kimconnectkimconnect

Loading the SQL Server Management Objects (SMO)

function loadSMO{ $ErrorActionPreference = "Stop" $sqlpsRegistry="HKLM:\SOFTWARE\Microsoft\PowerShell\1\ShellIds\Microsoft.SqlServer.Management.PowerShell.sqlps" try{ if (Get-ChildItem $sqlpsRegistry -ErrorAction "SilentlyContinue") { throw "SQL…
0 Comments