Sysadmins of the North (Page 6)

Technical SysOps blog, where topics include Sysadmin, DevOps, computers, servers, web, MySQL, database, virtualization, optimization and security

Setting up Monit monitoring in Windows Subsystem for Linux WSL

How to install and configure Monit monitoring in Windows 11/10 WSL

Silently import .reg file in your Windows registry

Learn how to silently import a .reg file into your Windows Registry. This neat regedit trick comes in handy quite often. The regedit command is valid for Windows 11, 10, Windows Server 2022, 2019 and older.

How to uninstall and remove Adobe Flash Player in Windows Server

You can easily uninstall and remove Adobe Flash Player from Windows Server using Deployment Image Servicing and Management (DISM)

11+ Tips to optimize Umbraco 7 CMS

11+ tips to optimize Umbraco 7 performance on Windows Server

WordPress .htaccess security best practices in Apache 2.4.6+

Since Apache 2.4.6, a new module is used to configure and set up access control for websites: mod_authz_core. This means you have to use a different syntax for allowing or blocking hosts and IP addresses to your website.

How to set SVN_EDITOR environment variable in Windows Server

Learn how to set SVN_EDTIROR environment variable in Windows Server to resolve subversion errors

Manually failover all databases in an SQL Server Database Mirroring configuration

A manual SQL Server failover can only be initiated from the principal server, and the mirrored database must be synchronized (that is, when the database is in the SYNCHRONIZED state). In this article I will show you how to manual failover mirrored SQL Server databases using Transact-SQL (T-SQL) in SQL Server 2017 and up.

ASP and ASP.NET connectionstring examples for Microsoft SQL Server and MySQL

A connectionstring is sometimes a bit obscure. Do I need ODBC or OLE DB? When you need one and Google for it, you often find old ones that either don't work at all anymore, or are not optimal. This article provides you with a couple of ASP.NET to SQL Server connectionstring examples, and as a bonus for ASP to MySQL too.

MySQL Connector/ODBC C# test script

Quickly test the MySQL database connection from ASP.NET using this C# test script. It utilizes the MySQL ODBC 8.0 Unicode Driver and SslMode is available.

Working with file attributes in PowerShell

Working with PowerShell Get-ItemProperty to get file attributes may boost your work productivity. It's often easier to getting things done if you have a more generic way of doing something. Here is how to use Get-Item and Get-ItemProperty in PowerShell to perform and streamline day to day tasks like installing or updating software based on file versions. I also address changing timestamps on files in short.

How to use SSL in PHP Data Objects (PDO) mysql

If you want to connect securely to your MySQL database using PHP Data Objects (PDO), here is how to connect to MySQL with PHP PDO using an SSL encrypted connection.

Fatal error: Uncaught Error: [] operator not supported for strings - PHP 7.1

With PHP 7.1, some PHP web applications fail because of deprecated code usage. This may result in an error message like `[] operator not supported for strings` for various Joomla, WordPress and Drupal components. Here's how to fix this code for PHP 7.1+.

Windows Server 2016 on Hyper-V stuck at stopping

When a Windows Server 2016 guest VM on Hyper-V hangs while stopping after Windows Updates, and it won't reboot, it might be caused by the recovery debug information type set. Here is some additional information.

List all SPNs used in your Active Directory

List Service Principal Names (SPNs) in your Windows network quickly using PowerShell

Increase WordPress' memory limit WP_MEMORY_LIMIT properly in wp-config.php

How to increase the memory limit for your WordPress website, the right way. In this post I show you a correct way of setting WordPress WP_MEMORY_LIMIT and PHP memory_limit settings to improve Wordpress speed & performance.