For debugging purposes it can sometimes be useful to find out how many queries your database has handled in the last X minutes. Here is how you can get that information in some of the more common databases. I use 30 min as an example here so just modify the 30 to whatever length you…
How to open a program as your user on another users desktop remotely
Getting nested nuget dependencies using Powershell
A digital Sticky note that is always on top
How to quickly find the path of exe / binary / command files on you computer
A few days ago I wanted to find where exactly a binary/exe "command" was located on the disk, specifically nuget. I tried checking the path variable but was unable to find anything useful. Turns out that once again Powershell had a quick solution. I thought Get-Command only showed you Powershell cmlets, that's wrong. It works…
Installing all drivers in a driverpack folder using Powershell
Running a Powershell script on your code before a git commit using pre-commit
If you’re looking to use PowerShell with the open-source framework called pre-commit, this isn’t the right article for you. Instead, I’ll be focusing on Git’s built-in pre-commit functionality without relying on any third-party tools. If that sounds confusing, don’t worry, I’ll explain this later on. I just wanted to clarify this at the beginning so…
How to invoke a Task Sequence on your machine using Windows Powershell
Fixing CERT_TRUST_IS_UNTRUSTED_ROOT when using Git on Windows
When using git on windows you may run in to this error message when trying to interact with a remote git repo unable to access 'https://gitserver.local/MyTeam/MyRepo/': schannel: CertGetCertificateChain trust error CERT_TRUST_IS_UNTRUSTED_ROOT This happens when the repo is on a server with a certificate your git client does not trust. What can be a bit unintuitive…
Powershell script for getting your Configuration Manager servers
Something I find very hard to do in practice is keeping documentation up to date, if you don't automate this it simply will not get done. In this post I am sharing a PowerShell function that can be used to get all your Configuration Manager servers and what roles they have, great for building automated…