Fix broken WMI provider in SQL Server

Being unable to open SQL Server Configuration Manager if often caused by a corrupt or removed WMI provider for SQL Server. This post explains how to resolve this.
Being unable to open SQL Server Configuration Manager if often caused by a corrupt or removed WMI provider for SQL Server. This post explains how to resolve this.
The fire-and-forget method to update SQL Server Management Studio (SSMS) automatically by uninstalling any installed version and downloading & installing the newest available version from Microsoft.
Windows Server IIS is known for reusing DH key values, but there is a way to disable ECDH public server param reuse in Windows Server IIS and here is how.
Learn how to create strong and unique passwords in Windows using PowerShell, because the use of those unique and strong passwords is important.
Have a need for IIS in your Windows 11 development station, and now you wonder how to install IIS? Here I describe how you can easily install IIS and some modules using PowerShell
Zabbix is a great tool to monitor your website performance on IIS using Performance Counters, PowerShell and WMI.
Windows Subsystem for Linux (WSL) 2 now has native support for IPv6! 🥳
Use PowerShell, Performance Counters and WMI to get the current number of active connections to IIS websites. Monitor IIS servers in Zabbix
The following PowerShell snippet can be used to quickly install an SSL (or TLS) certificate in Windows Server. It assumes you have a PFX file and its password. The default location is Cert:\LocalMachine\My, to use for IIS websites.
In this small post I'll guide you through the various Windows Server and IIS configuration settings, for an optimized network performance, high performance websites and high volume of web requests.
You can use PowerShell to install Windows Updates automatically, unattended and simple. Neat, right? For this, you don't have to have an enterprise environment with WSUS, or Windows Server, but since this is Sysadmins of the North, I assume you do. In this post I show you how to install Windows Updates with PowerShell and the PSWindowsUpdate module.
Monitor Microsoft SQL Server, databases and performance with Zabbix, PowerShell, Performance Counters and WMI. Keep SQL Server and databases in top shape and performance up! In this post I show you how you can use Zabbix to monitor those important aspects for database administrators (DBA).
Set up debugging symbols for WinDbg in Windows and debug BSOD like a boss.
Windows has the ability to allow the MSI package (.msi file) contents to be extracted using the command line or via a script. I keep forgetting the correct msiexec.exe syntax to use to extract files from an .msi file (MSI package), so here is a short post with the command.
Connect virt-manager to a KVM host through an ssh tunnel and arbitrary port in Windows using Windows 11 and WSL 2.
In this post I describe some of the settings and changes I made to make my Windows 11 and Ubuntu WSL2 into a fully fledged development environment. Here are the settings and tools I use for DevOps / SysOps on Windows.
Now Win32-OpenSSH has decent support for FIDO/U2F hardware authenticators you can finally use your YubiKey for SSH authentication in Windows 11, jeej! Here is how.
Learn how to add VirtIO drivers to your Windows Recovery Environment (Windows RE) to recover your Windows virtual machines. Using Powershell of course and Windows Server 2022.
If you have tens (hundreds) of servers and/or users it's easier to retrieve user SSH public keys from Active Directory (AD) than from various unmanaged authorized_keys files.
Learn how to install SQL Server cumulative updates (CU) silently using PowerShell opposed to the cumbersome task of running the GUI installer.