Install Windows Server Servicing Stack Updates (SSU) using PowerShell

You can install Servicing Stack Updates (SSU) for Windows Server 2016 and Windows Server 2019 using PowerShell, without downtime. Because they must be installed prior to your normal Windows Server security updates, you can install them anytime you want to during the day. Here’s a small PowerShell example to do so. Did this post helped…

Continue reading Install Windows Server Servicing Stack Updates (SSU) using PowerShell

File cabinet image

Manually failover all databases in an SQL Server Database Mirroring configuration

How to manually failover an SQL Server database mirroring session? How to manual failover mirrored SQL Server databases using Transact-SQL (T-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). In this article I’ll show you…

Continue reading Manually failover all databases in an SQL Server Database Mirroring configuration

Important note about Windows Update KB4056892

There is another VERY IMPORTANT THING with Microsoft Meltdown patches like update KB4056892: – Customers will not receive these security updates and will not be protected from security vulnerabilities unless their anti-virus software vendor sets the following registry key: Did this post helped you solve a problem? Or dit you find it interesting? Support Sysadmins…

Continue reading Important note about Windows Update KB4056892

Windows Update error 0xc1420127 and 0xc190010b when upgrading Windows 8.1 to Windows 10

Last weekend I had to update my girlfriends laptop from Windows 8.1 to Windows 10. Some might say, an easy task. Well, it wasn’t. After downloading the Windows 10 update through Windows Update, Windows Update returned errors 0xc1420127 and 0xc190010b, even using the Windows 10 media creation tool. And as always there are many reasons…

Continue reading Windows Update error 0xc1420127 and 0xc190010b when upgrading Windows 8.1 to Windows 10