AshFlaw
AshFlaw
/ Test-SQLTableExists.ps1
Last active
April 6, 2018 14:45
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| function Test-SQLTableExists | |
| { | |
| param ($Instance,$Database,$TableName) | |
| $Return = $SQL = $dataTable = $null | |
| $sql = "SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = N'$TableName'" | |
| $dataTable = Invoke-Sqlcmd2 -ServerInstance $Instance -Database $Database -Query $sql | |
| if ($dataTable) {$return = $true} | |
| else {$return = $false} | |
| $Return | |
| } |
AshFlaw
/ ChocoInstall.ps1
Last active
March 20, 2024 19:59
Install Chocolatey with PowerShell and enable global automatic install confirmations.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Set-ExecutionPolicy Unrestricted | |
| # Install Chocolatey | |
| Invoke-WebRequest https://chocolatey.org/install.ps1 -UseBasicParsing | Invoke-Expression | |
| # Enable Global confirmation (auto accept any prompts) | |
| choco feature enable -n=allowGlobalConfirmation |
AshFlaw
/ Install-Choco.ps1
Created
April 15, 2018 11:08
PowerShell function to install Chocolatey if it isn't already.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Function Install-Choco | |
| { | |
| Set-ExecutionPolicy Bypass -force | |
| If (!(Test-Path -Path "C:\ProgramData\chocolatey")) | |
| { | |
| $env:chocolateyUseWindowsCompression = 'false' | |
| Invoke-WebRequest https://chocolatey.org/install.ps1 -UseBasicParsing | Invoke-Expression | |
| choco feature enable -n=allowGlobalConfirmation | |
| } | |
| } |
AshFlaw
/ Get-StaleADComputers.ps1
Created
May 2, 2018 17:07
Get computer accounts that haven't logged on in a year.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| $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 07:43
Shrink all SQL Transaction Log Files on an Instance
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SET NOCOUNT ON | |
| USE master | |
| GO | |
| /* | |
| * Update usage statistics. Not a necessary step | |
| * but will provide more accurate results | |
| */ | |
| DBCC UPDATEUSAGE(0) | |
| IF OBJECT_ID('tempdb..#tmp') IS NOT NULL |
AshFlaw
/ Set-SQLInstanceAllDBLogFileSettings.ps1
Created
May 14, 2018 08:10
Function to set the log file initial size and growth values for all databases on an instance to 512MB
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Function Set-SQLLogFileSizeAndGrowth | |
| { | |
| Param | |
| ( | |
| $Instance | |
| ) | |
| Import-Module dbatools -ErrorAction SilentlyContinue | |
| If ((Get-Module | Where-Object {$_.Name -eq "dbatools"}) -eq $null) | |
| { | |
| Write-Output "Installing required module: $dbatools" |
AshFlaw
/ RenewLetsEncryptSynology.sh
Last active
December 29, 2018 04:29
Manually renew a Let's Encrypt certificate on a Synology NAS
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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 13:38
Remotely expand all volumes on a server that have available space.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Function Invoke-RemoteVolumeExpand | |
| { | |
| Param | |
| ( | |
| $Server | |
| ) | |
| Function Invoke-VolumeExpand | |
| { | |
| $Include = "C|W|D|E|F" | |
| $Partitions = Get-Partition | Where-Object {$_.DriveLetter -Match $Include} |
AshFlaw
/ ChangeYourADPassword.ps1
Created
June 1, 2018 07:38
Change your AD password with PowerShell
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| $AccountName = "" | |
| Set-AdAccountPassword -Identity $AccountName -OldPassword (Read-Host -asSecureString "Current password") -NewPassword (Read-Host -asSecureString "New password") |
AshFlaw
/ LogOffRemoteServer.ps1
Created
June 18, 2018 18:42
Windows Server Core, closed terminal windows. Remote log off of session so next time, console will launch.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| logoff /server:remote_computer_name |