SQL – Check with statements that are blocked
admin You can check which statements are blocked by running this
Windows
Office 365 -add Teams trial to all users
If you add the Office 365 Teams trail to you tenant, and you will like to give that license to all users, this is the command you can run:
Restart Explorer as Adminstrator
If you have problems with accessing a drive, with the error message: f:\ is not accessible. Access is denied It can happen, if the drive doesn’t have this permission:Everyone (This…
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/
Windows 7/2008/2008 R2 Won’t boot after installation of KB4512506 / KB4512486 / KB4512476
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…
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…
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.
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…