MSSQL – check that the Agent Job have been run as Schedule
admin I have this problems, that if a schedule inside a Agent job, have not been started for some reason, there will be no errors about this problem. So Í have…
Computer
Implement SQL Server Agent Jobs with AlwaysOn Availability Groups
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…
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…
ADFS – Bad Request 400 in Internet Explorer
Today i have a customer that got an Bad Request Error 400, when he try to logon to ADFS from inside their own network, with domain connected computers.The error is…