MSSQL database roles get all securables – Full script out the Database Roles
Thanks for the script to John Eisbrener – Check for new version here: https://dbaeyes.wordpress.com/2013/04/19/fully-script-out-a-mssql-database-role/
Kenneth Qvistgaard Dalbjerg, IT Konsulent i århus
Thanks for the script to John Eisbrener – Check for new version here: https://dbaeyes.wordpress.com/2013/04/19/fully-script-out-a-mssql-database-role/
After installation of these update, you can have problem booting you server. with this warning: The digital signature for this file couldn’t be verified. file:\windows\system32\winload.efi status 0xc0000428 You can fix it by booting you...
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.
To list all unmanage on a nimble storage, you can ssh to the SAN, and run this command:
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:
Sidste kommentar