Microsoft
Excel
Conditional highlighting with functions This is a collection of frequently used functions for co...
Installing Certificates on Windows
Using PowerShell to install into the Local Computer store This can only be done with elevated pr...
Microsoft Remote Desktop Certificates
Manually replacing RDP certificate Install the new certificate in the Local Computer Personal st...
Network Policy Server / NPS
Enable NTLMv2 support for MSCHAPv2 RADIUS requests Enables proxied radius requests when using...
On-Prem to Azure DNS Migration
The Azure CLI can easily be used to do this migration. Here's the steps to use the Azure CLI: Cr...
OpenSSH on Windows
https://learn.microsoft.com/en-us/windows-server/administration/openssh/openssh_install_firstuse?...
PowerShell
Active Directory
Get-SMBOpenFile
Basics
Errors and Solutions
This page contains a list of common PowerShell errors and their solutions. Invoke-WebRequest...
Firewall management
List firewall rules with ICMP in the DisplayName Get-NetFirewallRule | Where-Object DisplayName -...
Group Policy and PowerShell
You can manage Group Policy via PowerShell... who knew!? 🤣 Listing GPOs Get-GPO -All | Sort-O...
Querying Event Logs
I noticed that there is a huge speed difference between using an XML Query and PowerShell Get-Eve...
Useful PowerShell Commands
Placeholder Select-String is the Grep equivalent Examples: # Searching for multiple patterns...
TCP/IP Reset
WiFi adapter sees available network, however will not accept tcp/ip address. Attempting to reset ...
Teams
How to stop Aftershokz / Shokz headphones from beeping while muted Source While Teams is ...
Transitioning from old to new
IPv4 ARP -> IPv6 Neighbors netsh interface ipv6 show neighbors # OUTPUT: Interface 16: Wi-Fi ...
Useful MSSQL Queries
Show running queries SELECT req.session_id, req.status, req.command, req.cpu_time, req...
Junctions
Finding junctions / reparse points # return all reparse points on the C: volume DIR C:\ /S /A...