MSSQL – check that the Agent Job have been run as Schedule
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 created this script, that...
Kenneth Qvistgaard Dalbjerg, IT Konsulent i århus
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 created this script, that...
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 input parameter and returns a Boolean value indicating...
Here are a script, that you can include in yours script, to add Exchange management shell, to “normal” powershell scripts.
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 a forum.https://dba.stackexchange.com/questions/204883/how-to-tell-if-a-backup-log-chain-is-broken The script...
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 these commands, to check...
This command, can be run on both the primary and secondary node.
To see witch session id, that run command against a database, you can run this:
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 only showing up in...
How fast is data leving the cache, when it not access again. With this query, you can see how fast data will get expire, and overwritten by new data in the cache. Witch the...
With this query, you can see whitch database that is using most memory
Sidste kommentar