Welcome to Sysadmins of the North

A technical blog where topics include: computer, servers, web, sysadmin, databases, virtualization, optimization and security.

Microsoft SQL Server logo

Install SQL Server cumulative updates silently

Installing SQL Server cumulative updates is always a cumbersome, and quite daunting task. Unpacking and running the CU installer is a slow process, you have to click through a lot of screens, and it’s hard to get it to install silently. But here is how!

Learn how to install SQL Server cumulative updates (CU) silently using PowerShell opposed to the cumbersome task of running the GUI installer.

Windows Defender: Turn off routine remediation

Here is how to (temporarily) turn off routine remediation in Windows Defender Antivirus (WinDefend). During the transition of antivirus software to Windows Defender Antivirus (WinDefend), I don’t want Windows Defender remediation on threats it might find. Later, when I have more information about potential threats, I can always choose to remediate that threat, e.g. quarantaine or remove it.

black skeleton keys

How to share OpenSSH keys with WSL in Windows 10

Don’t want to copy over your ssh keys from Windows to WSL Linux? Or generate new ones? Then share your Windows OpenSSH key with WSL! The OpenSSH config gives you the option to share keys using an IdentityFile directive. Here is how you can share your keys between Windows 10 and WSL.

Increase WMI memory to support large volume of queries

WMI stopped working: WmiPrvse.exe would just crash after hitting some memory limit of 512 MB. If you run into the same issue with Windows Management Instrumentation, here is how you can increase WMI Provider Service’s memory quota. Doing so resolved my issues. Here is how to optimize WMI.

How-to fix “Get-MpComputerStatus : The extrinsic Method could not be executed.”

This is how I resolved the error message “Get-MpComputerStatus : The extrinsic Method could not be executed.”, in my specific situation. In my situation, I had Windows Defender Antivirus disabled per GPO (“Turn off Windows Defender Antivirus” in Computer Configuration/Administrative Templates/Windows Components/Windows Defender Antivirus). And I wanted to enable Windows Defender in a new GPO, on a specific set of computers.

IIS Manager for Remote Administration in Windows 10

Install and setup IIS Manager for Remote Administration in Windows Server IIS

Learn how to install and configure IIS Manager (InetMgr) for Remote Administration of your Windows Server IIS web server, in Windows 10. You can use IIS Manager to administer various components of your website through a graphical user interface (GUI), if it’s hosted in IIS. This post also shows how to install IIS Web Management Service (WMSVC) on Server Core using PowerShell.

Monitor IIS application pools in Zabbix, part 1

Zabbix can harnas the powers of WMI (Windows Management Instrumentation) to query the Windows system for data. In Zabbix you use wmi.getall for this. Here is a small introduction to query the number of running w3wp.exe processes per IIS application pool in Zabbix.