Sysadmins of the North

Learn how to automatically push your HomeWizard P1 gas meter readings into Tado Energy IQ using a simple Home Assistant automation.

A Gutenberg block for inserting Google AdSense ads into posts.

Being unable to open SQL Server Configuration Manager is often caused by a corrupt or removed WMI provider for SQL Server.

Never forget an OpenSSL command again.

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.

Learn how to use the Twilio SendGrid Web API v3 to send email with PowerShell The post Send mail through SendGrid Web API using PowerShell appeared first on Sysadmins of the North.

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?

Zabbix is a great tool to monitor your website performance on IIS using Performance Counters, PowerShell and WMI.

Use a specific TLS certificate or thumbprint for outgoing HTTPS connections using PowerShell.

Learn how to calculate and create file checksums with PowerShell's Get-FileHash and certutil.exe.

Learn how to use PowerShell Test-NetConnection to test if a TCP port is open The post Test open TCP ports with PowerShell appeared first on Sysadmins of the North.

Windows Subsystem for Linux (WSL) 2 now has native support for IPv6!

Old school: learn how to convert a Windows SID (security identifier) to an username, or vice versa (username to SID) using PowerShell and VBScript.

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).

Use PowerShell, Performance Counters and WMI to get the current number of active connections to IIS websites.

Use PowerShell to install SSL certificate in Windows Server and change its FriendlyName property.

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.

Easily send your DevOps reporting by email with this PowerShell function, because the Send-MailMessage cmdlet is obsolete.

Sometimes you need to create an additional SQL Server Login (user) for your database (databases).

Monitor Microsoft SQL Server, databases and performance with Zabbix, PowerShell, Performance Counters and WMI.

Query all posts in WordPress not having a Yoast SEO meta description yet.

Set up debugging symbols for WinDbg in Windows and debug BSOD like a boss.

How to extract MSI files without installing (quick command-line method).

Take control of your server resources by learning how to block aggressive bots and unwanted search engines using .htaccess and mod_rewrite.

Connect virt-manager to a KVM host through an ssh tunnel and arbitrary port in Windows using Windows 11 and WSL 2.

DevOps in Windows: 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.

Secure your Windows 11 environment by moving SSH private keys to hardware.

Display full username in ps.

Use Zabbix to monitor your web application and application pool's .NET CLR Garbage Collected heap by utilizing WMI and PowerShell.

Find out fast if your IIS webservers have EnableTrailerSupport enabled for https.sys in the registry.

How can I convert an SqlCe database to Microsoft SQL Server?

Out of the box, Umbraco is a well built and pretty fast content management system.

Block PHP files like sendmail.php on Windows Server IIS webservers.

Add a trailing slash to URL's in Umbraco 8, using IIS URL Rewrite Module, without breaking the Umbraco backend.

Learn how to add VirtIO drivers to your Windows Recovery Environment (Windows RE) to recover your Windows virtual machines.

Storing SSH public keys in Windows Server Active Directory gives you a single location where you manage public SSH keys instead of on numerous separate servers.

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

short PowerShell snippet for you to remove a computer object from Windows Server Update Services (WSUS) The post Remove computer object from Windows Server Update Services (WSUS) in PowerShell appeared first on Sysadmins of the North.

Add, list, and remove IP addresses in Windows Firewall (PowerShell & netsh): How to bulk add IP addresses in Windows Firewall, list an IP address and how to remove all IP addresses from Windows Defender Firewall with Advanced Security.

For the time being, some manual labor is involved, but it is still manageable.

Native support for HTTP/3 in Windows Server 2022, jeej!

Turn off Windows Defender routine remediation using a GPO setting called "DisableRoutinelyTakingAction".

Here is how you can share your SSH keys between Windows 11/10 and WSL 2 if you don't want to copy over your ssh keys from Windows to WSL 2 Linux, or generate new ones.

Learn how to fix memory issues and subsequent crashes in WMI / WmiPrvse.exe by increasing available memory and handles The post Increase WMI memory to support large volume of queries appeared first on Sysadmins of the North.

Enabling Windows Defender per GPO failed with the error message "Get-MpComputerStatus : The extrinsic Method could not be executed.", here is how to resolve this issue.

Use IIS Manager to administer various components of your website through a graphical user interface (GUI) if it's hosted in Windows Server IIS.

If you want to quickly delete all saved Remote Desktop credentials from your Windows 10 Credentials Manager, here...