How to verify SMBv1 is disabled in Windows and Windows Server

Since WannaCry and Petya ransomware were spreading through Windows systems in 2017, it’s recommended to have Server Message Block version 1 (SMBv1) disabled in Windows clients and Windows Server. Now SMBv1 is not installed by default in Windows 10 1709 and Windows Server, version 1709 and later, but how can you be sure it is disabled in older Windows versions? Easy, use PowerShell.

Read More

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 how to force a failover.

Read More