So, running a couple of Hyper-V machines, and needing to determine their local IP addresses to connect to them. As long as the Hyper-V Integration Services are installed (apt-get install hyperv-daemons on Debian-based distributions), PowerShell on the host machine will have access to the IP addresses of the client machine. Without the Integration Services, PowerShell […]
I keep having to look these up, so I stored them here. Office LTSC 2024 Product KMS Client Setup Key Office LTSC 2024 XJ2XN-FW8RK-P4HMP-DKDBV-GCVGB Office LTSC 2021 Product KMS Client Setup Key Office LTSC 2021 FXYTK-NJJ8C-GB6DW-3DYQT-6F7TH Office 2019 Product KMS Client Setup Key Office Professional Plus 2019 NMMKJ-6RK4F-KMJVX-8D9MJ-6MWKP Office Standard 2019 6NWWJ-YQWMR-QKGCB-6TMB3-9D9HK Project Professional 2019 […]
I’ve found these useful during development: Listing running queries: SELECT pid, now() – pg_stat_activity.query_start AS duration, query FROM pg_stat_activity WHERE state = ‘active’ AND pid <> pg_backend_pid(); Listing queries that have run for more than a full minute: SELECT pid, now() – pg_stat_activity.query_start AS duration, query FROM pg_stat_activity WHERE state = ‘active’ AND pid <> […]