Implement SQL Server Agent Jobs with AlwaysOn Availability Groups
admin The function I use fn_hadr_group_is_primary from this post is a UDF (User Defined Function) that we create in the master database. The function gets an Availability Group name as an…
2019
Add Exchange management Shell to “normal powershell
Here are a script, that you can include in yours script, to add Exchange management shell, to “normal” powershell scripts.
List all unmanage snapshot on Storage
To list all unmanage on a nimble storage, you can ssh to the SAN, and run this command:
mssql get the backup information with copy_only information.
I need to find a way to see if the backup chain where broken. On my search I found this could script, created by “hot2use”I have found this script on…
Move from Office 365 to Onpremise in a Hybrid enviroment
import-module msonline(install-module msonline) $O365CREDS = Get-Credential$ONPREMCREDS = Get-Credential #used UPN Username $SESSION = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://ps.outlook.com/powershell -Credential $O365CREDS -Authentication Basic -AllowRedirection Import-PSSession $SESSIONConnect-MsolService -Credential $O365CREDS #You can run…
Monitoring a Automatic Seeding in msSQL Always on Availability Groups
This command, can be run on both the primary and secondary node.
msSQL Session running on database
To see witch session id, that run command against a database, you can run this:
Linux: Change default IP address on host with multiple IP address
If you have a host with multiple IP address on it, and you need to change witch IP address it present it with on the Internet, you can change the…