Open PowerShell in Admin mode
Copy the script
Run it.
SQl Hunt,
2019-05-03 (first published: 2015-03-29)
Open PowerShell in Admin mode
Copy the script
Run it.
clear-host $ascii=$NULL;For ($a=33;$a –le 126;$a++) {$ascii+=,[char][byte]$a } Function GET-Temppassword() { Param( [int]$length=10, [string[]]$sourcedata ) For ($loop=1; $loop –le $length; $loop++) { $TempPassword+=($sourcedata | GET-RANDOM) } return $TempPassword } write-host "Your Random Generated Password Is below: `n `r" -ForegroundColor GRAY $password1 = (GET-Temppassword –length 19 –sourcedata $ascii ) $password2 = (GET-Temppassword –length 19 –sourcedata $ascii ) $password3 = (GET-Temppassword –length 19 –sourcedata $ascii ) write-host "`n `rPASSWORD1: `r" write-host $password1 -ForegroundColor YELLOW write-host "`n `rPASSWORD2: `r" write-host $password2 -ForegroundColor GREEN write-host "`n `rPASSWORD3: `r" write-host $password3 -ForegroundColor CYAN
If you have a requirement to send email to recipients with attachment, can use the script.
2019-05-03 (first published: 2016-05-17)
2,937 reads
Creates a record of all or part of a Windows PowerShell session in a text file.
2019-05-03 (first published: 2015-09-17)
1,066 reads
Using Powershell, Cleanup Older than 30 days of Files & Folder through SQL Job
2019-05-03 (first published: 2015-08-04)
1,894 reads
Check all the running SQL services in different servers.
You can use the details before you start implementing SQL Patch to the servers i.e. if you want to explicitly stop the SQL Services.
2019-05-03 (first published: 2015-03-26)
1,910 reads
Execute the function and pass only the SQL Server Name to check if the SQL Instance is available and if yes, what is the Instance Type.
2019-05-03 (first published: 2015-03-26)
1,180 reads