Clear mssql cache
If you for example need to test a query against two SQL servers hardware, its a good idea to clear the cache first.This query can do this:
If you for example need to test a query against two SQL servers hardware, its a good idea to clear the cache first.This query can do this:
When going to Settings -> Accounts -> Access work or school, og push the "connect" buttom. I could just see that the popup, asking for my mail address, just popup,…
If you have vmware ESXi or Microsoft Hyper-v, you can expand a disk, from the hypervisor console, very simple. But afterwards the partition the servers is not expand.It is always…
If you need to get all certificates, from a list of remote computers, you can use this script:
If you need to found out whitch groups (mailling groups) a contact is member of in Microsoft 365, then you case use these powershell commands: Replace [email protected] with yours mail…
To sign a certificate with a specific template with Windows Certificate Authority
You can use this command to see the status of the Raid Controller and Raidset. Here you can see under PD List, that drive 252:3 14 stand as UGood. Thats…
If you ever need to see the status of a running jobs, this TSQL can be very helpfull
If you wan to know the sync status of a always On availability group database replication, this command can be used:
You can run this commands to see what updates, that PRTG windows update probes is warning about.