Skip to content

Instantly share code, notes, and snippets.


  • The Full Circle
Block or report user

Report or block AshFlaw

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
View Test-SQLTableExists.ps1
function Test-SQLTableExists
param ($Instance,$Database,$TableName)
$Return = $SQL = $dataTable = $null
$dataTable = Invoke-Sqlcmd2 -ServerInstance $Instance -Database $Database -Query $sql
if ($dataTable) {$return = $true}
else {$return = $false}
AshFlaw / ChocoInstall.ps1
Last active Apr 15, 2018
Install Chocolatey with PowerShell and enable global automatic install confirmations.
View ChocoInstall.ps1
Set-ExecutionPolicy Unrestricted
# Install Chocolatey
Invoke-WebRequest -UseBasicParsing | Invoke-Expression
# Enable Global confirmation (auto accept any prompts)
choco feature enable -n=allowGlobalConfirmation
AshFlaw / Install-Choco.ps1
Created Apr 15, 2018
PowerShell function to install Chocolatey if it isn't already.
View Install-Choco.ps1
Function Install-Choco
Set-ExecutionPolicy Bypass -force
If (!(Test-Path -Path "C:\ProgramData\chocolatey"))
$env:chocolateyUseWindowsCompression = 'false'
Invoke-WebRequest -UseBasicParsing | Invoke-Expression
choco feature enable -n=allowGlobalConfirmation
AshFlaw / Get-StaleADComputers.ps1
Created May 2, 2018
Get computer accounts that haven't logged on in a year.
View Get-StaleADComputers.ps1
$duration = (Get-Date).AddDays(-365)
Get-ADComputer -Filter {LastLogonDate -lt $duration} | Select-Object Name, LastLogonDate | Sort-Object Name
AshFlaw / Set-SQLShinkAllLogFiles.sql
Created May 14, 2018
Shrink all SQL Transaction Log Files on an Instance
View Set-SQLShinkAllLogFiles.sql
USE master
* Update usage statistics. Not a necessary step
* but will provide more accurate results
IF OBJECT_ID('tempdb..#tmp') IS NOT NULL
AshFlaw / Set-SQLInstanceAllDBLogFileSettings.ps1
Created May 14, 2018
Function to set the log file initial size and growth values for all databases on an instance to 512MB
View Set-SQLInstanceAllDBLogFileSettings.ps1
Function Set-SQLLogFileSizeAndGrowth
Import-Module dbatools -ErrorAction SilentlyContinue
If ((Get-Module | Where-Object {$_.Name -eq "dbatools"}) -eq $null)
Write-Output "Installing required module: $dbatools"
AshFlaw /
Last active Dec 29, 2018
Manually renew a Let's Encrypt certificate on a Synology NAS
ssh user@synology.local
sudo -i
# Method 1
/usr/syno/sbin/syno-letsencrypt renew-all
# Method 2 - Verbose
/usr/syno/sbin/syno-letsencrypt renew-all -vv
AshFlaw / Invoke-RemoteVolumeExpand.ps1
Created May 14, 2018
Remotely expand all volumes on a server that have available space.
View Invoke-RemoteVolumeExpand.ps1
Function Invoke-RemoteVolumeExpand
Function Invoke-VolumeExpand
$Include = "C|W|D|E|F"
$Partitions = Get-Partition | Where-Object {$_.DriveLetter -Match $Include}
AshFlaw / ChangeYourADPassword.ps1
Created Jun 1, 2018
Change your AD password with PowerShell
View ChangeYourADPassword.ps1
$AccountName = ""
Set-AdAccountPassword -Identity $AccountName -OldPassword (Read-Host -asSecureString "Current password") -NewPassword (Read-Host -asSecureString "New password")
AshFlaw / LogOffRemoteServer.ps1
Created Jun 18, 2018
Windows Server Core, closed terminal windows. Remote log off of session so next time, console will launch.
View LogOffRemoteServer.ps1
logoff /server:remote_computer_name
You can’t perform that action at this time.