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.
Sysadmins of the North
Technical SysOps blog, where topics include Sysadmin, DevOps, computers, servers, web, MySQL, database, virtualization, optimization and security
Sysadmins of the North
Technical SysOps blog, where topics include Sysadmin, DevOps, computers, servers, web, MySQL, database, virtualization, optimization and security
Category Windows Server
Mastering Windows Server requires more than just following documentation; it’s about navigating the real-world complexities of deployment, security, and performance. From optimizing IIS for high-traffic environments and hardening OpenSSH configurations to managing PHP on Windows, this section provides deep-dive tutorials and battle-tested scripts. Whether you are managing legacy builds or the latest Windows Server 2025 releases, these guides focus on efficiency and stability for the modern infrastructure.
As environments shift toward hybrid setups, the integration between Windows Server and Linux-based tools has never been more critical. Here, you will find specialized knowledge on bridging that gap, including DevOps workflows, automation via PowerShell, and hardware-backed security. These articles are written by a sysadmin for sysadmins – cutting through the noise to deliver the specific configurations you need to keep your production environments running smoothly.
Read MoreFix broken WMI provider in SQL Server
Update SQL Server Management Studio (SSMS) automatically
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.
Disable ECDH public server param reuse in Windows Server IIS
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.
Create strong passwords in Windows
Learn how to create strong and unique passwords in Windows using PowerShell, because the use of those unique and strong passwords is important.
Install IIS in Windows 11 using PowerShell
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
Monitor website performance in IIS with Zabbix
Zabbix is a great tool to monitor your website performance on IIS using Performance Counters, PowerShell and WMI.
IPv6 support for WSL2! 🥳
Windows Subsystem for Linux (WSL) 2 now has native support for IPv6! 🥳
Windows SID to username and vice versa
Old school: learn how to convert a Windows SID (security identifier) to an username, or vice versa (username to SID) using PowerShell and VBScript. Because sometimes you just need to convert a Windows SID to an username, don't you?
Get SQL database backup details with PowerShell
Whenever I need to restore an SQL Server .bak backup file, I want to know some properties of the backup file to make sure I'm working with the correct file(s). Luckily, the .bak file and PowerShell provide all the information I need, so I don't have to start a Restore procedure in SQL Server Management Studio (SSMS) just to view the header information. As you know, SSMS is slow...
Get IIS Current Connections using PowerShell
Use PowerShell, Performance Counters and WMI to get the current number of active connections to IIS websites. Monitor IIS servers in Zabbix
Install SSL/TLS certificates in Windows Server using PowerShell
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.
Tune Windows Server TCP/IP and IIS
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.
Install Windows Updates using PowerShell
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.
Create an additional SQL Server Login
Sometimes you need to create an additional SQL Server Login (user) for your database (databases). Here is a small T-SQL snippet that creates such a login for contained databases in SQL Server and adds memberships.
Monitor SQL Server and databases in depth using Zabbix
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).
Configure Windows Debugging Symbols in WinDbg
Set up debugging symbols for WinDbg in Windows and debug BSOD like a boss.
Extract files from an MSI package
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 to a KVM host through an ssh tunnel and arbitrary port in Windows 11 and WSL 2
Connect virt-manager to a KVM host through an ssh tunnel and arbitrary port in Windows using Windows 11 and WSL 2.
Windows 11 and WSL 2 DevOps environment
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.
YubiKey support in OpenSSH for Windows 11
In this post, I'll show you how to properly install Microsoft OpenSSH client in Windows 11 and Windows 10, and how to configure your YubiKey.
![[HttpException (0x80004005): The length of the URL for this request exceeds the configured maxUrlLength value.]](https://cdn.saotn.org/wp-content/uploads/2025/06/Length_of_URL_for_request_exceeds_maxUrlLength_value-11-150x150.png)
