Featured Articles
Windows Server
Fix broken WMI provider in SQL Server
Being unable to open SQL Server Configuration Manager is often caused by a corrupt or removed WMI provider for SQL Server. This post explains how to resolve this.
Welcome to the core Windows Server administration and engineering hub on saotn.org. Managing modern enterprise Windows Server environments requires a balance of scalable automation, proactive performance maintenance, and strict security baselines.
This category serves as a deep technical repository for sysadmins and infrastructure engineers. Whether you are deploying bare-metal nodes, managing hybrid active directory topologies, or streamlining lifecycle operations via command-line tooling, these verified guides offer production-ready solutions to keep your server fleet stable, secure, and highly optimized.
To assist with your environment maintenance, our essential Windows Server documentation is organized by administrative focus:
Browse the extensive chronological list of Windows Server tutorials, group policy enforcement templates, and deep-level registry troubleshooting guides below.
Windows Server
Being unable to open SQL Server Configuration Manager is often caused by a corrupt or removed WMI provider for SQL Server. This post explains how to resolve this.
Windows Server
Last updated:
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
Last updated:
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.
Windows Server
Last updated:
Learn how to create strong and unique passwords in Windows using PowerShell, because the use of those unique and strong passwords is important.
Windows Server
Last updated:
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
Windows Server
Last updated:
Zabbix is a great tool to monitor your website performance on IIS using Performance Counters, PowerShell and WMI.
Windows Server
Last updated:
Windows Subsystem for Linux (WSL) 2 now has native support for IPv6! 🥳
Windows Server
Last updated:
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?
Windows Server
Last updated:
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…
Windows Server
Last updated:
Use PowerShell, Performance Counters and WMI to get the current number of active connections to IIS websites. Monitor IIS servers in Zabbix
Windows Server
Last updated:
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.
Windows Server
Last updated:
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.
Windows Server
Last updated:
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.
Windows Server
Last updated:
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.
Windows Server
Last updated:
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).
Windows Server
Last updated:
Set up debugging symbols for WinDbg in Windows and debug BSOD like a boss. Set symbol path for WinDbg.
Windows Server
Last updated:
Stop hunting for command-line arguments. Learn the definitive way to extract files from an MSI package using the msiexec /a switch, TARGETDIR, and PowerShell for automated deployments.
Windows Server
Last updated:
Connect virt-manager to a KVM host through an ssh tunnel and arbitrary port in Windows using Windows 11 and WSL 2.
Windows Server
Last updated:
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.
Windows Server
Last updated:
Secure your Windows 11 environment by moving SSH private keys to hardware. Learn how to configure YubiKey FIDO2/U2F support in native OpenSSH, manage the ssh-agent, and eliminate file-based credential risks.