Sysadmins of the North

Technical blog, where topics include: computer, server, web, sysadmin, MySQL, database, virtualization, optimization and security

Author: Jan Reilink (Page 1 of 20)

Testing two Gutenberg syntax highlighting Blocks

Just a quick note that I’ll be testing out two syntax highlighting blocks for WordPress 5.0 Gutenberg over the next few days or weeks. So don’t worry when you see changes in posts you haven’t seen before or faulty syntax highlighting. Please do send me a comment if you see or experience strange behavior with code examples. The plugins I’m testing are shiny-code and code-syntax-block (and if you’re a WordPress enthousiast, they need your help and support!)

Silently import .reg file in your Windows registry

To add a .reg file silently to your Windows registry, you can use the regedit command. As almost always, the /s parameter is for silent and /q for quiet.

Read More

How to uninstall and remove Adobe Flash Player in Windows Server

Ever wondered why Windows Server Update Services (WSUS) offers Flash updates for Windows Server? Adobe Flash Player is installed on Windows Server 2016 if you have the Remote Desktop Session Host (RDSH) role installed. Yikes! I can imagine you want to delete Adobe Flash Player without deleting the RDSH role, and here is how.

Read More

HTTP/3

Daniel Stenberg writes on daniel.haxx.se blog

The protocol that’s been called HTTP-over-QUIC for quite some time has now changed name and will officially become HTTP/3. This was triggered by this original suggestion by Mark Nottingham.

Read More

Umbraco Project Belle

Umbraco CMS optimization – 11+ tips

Tips to optimize the performance of Umbraco powered websites

Umbraco is a popular, ASP.NET powered, content management system (CMS). Even though it performs pretty well, here are 11+ optimization tips for Umbraco on IIS.

Read More

Security?

WordPress .htaccess security best practices in Apache 2.4.6+

Apache Access Control done right, ‘Allow/Deny from all’ versus ‘Require All Granted/Denied’

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. But unfortunately, old documentation is never updated and people even still write blog posts using that old syntax, leaving you with an unprotected website. Not what you had in mind, now is it?…

Read More

How to set SVN_EDITOR environment variable in Windows Server

On a newly installed workstation or server, you might encountered the following subversion error when you commit a change:

Read More

File cabinet image

Manually perform a fail-over of all databases in an SQL Server Database Mirroring configuration

Manually fail-over an SQL Server database mirroring session

How to perform a (forced) manual fail-over by using Transact-SQL in SQL Server 2017. This 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).

Read More

Hyper-V Quick Create: run Ubuntu virtual machines even easier

With the Hyper-V Quick Create feature added in the Windows 10 Fall Creators Update, Microsoft have partnered with Ubuntu and added a virtual machine image. So in a few quick minutes, you’ll be up and developing. This is available now – just type “Hyper-V Quick Create” in your start menu!

Read More

ASP and ASP.NET connection strings for Microsoft SQL Server and MySQL

A connection string 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 example connection strings to connect ASP.NET and ASP to Microsoft SQL Server or MySQL.

Read More

Start all stopped application pools that have Autostart set to true

Just a quicky: Start all stopped application pools in IIS that have the autostart property set to true. Easily with appcmd, and here’s is how.

Read More

MySQL Connector/ODBC C# test script

Whenever you need to test your ASP.NET connection to your MySQL database, using ODBC, you can use the following C# test script. Currently it uses MySQL ODBC 8.0 Unicode Driver, but you can easily change the version used. As a bonus it prints some connection information and it requires an SSL connection to your MySQL database (SslMode=REQUIRED).

Read More

Working with file attributes in PowerShell

How to use the Windows PowerShell cmdlet Get-ItemProperty to work with file attributes.

Working with PowerShell’s 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-ItemProperty in PowerShell to perform and streamline day to day tasks like installing or updating software based on file versions.

Read More

Windows Server logo small

Windows 10 and Windows Server quality updates

What’s next for Windows 10 and Windows Server quality updates

Microsoft’ll be bringing a new design for quality updates to the next major versions of Windows 10 and Windows Server, coming later this year, Maliha Qureshi writes. This design creates a compact update package for easier and faster deployment.

Read More

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

connect securely to your MySQL database from PHP PDO using an SSL encrypted connection

If you want to connect securely to your MySQL database over SSL using PHP Data Objects (PDO), here is how…

Read More

Page 1 of 20

Powered by WordPress & Theme by Anders Norén