Since WannaCry and Petya ransomware were spreading through Windows systems in 2017, it’s recommended to have Server Message Block (SMB) version 1 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 versions of Windows? Easy: PowerShell.
(more…)Windows Server
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.
Windows Server
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.
(more…)Misc
HTTP/3
Daniel Stenberg writes on daniel.haxx.se blog:
(more…)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.
WordPress 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?…
(more…)Windows Server
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:
(more…)SQL Server
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).
(more…)Windows Server
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!
(more…)Code base
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.
(more…)Code base
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).
Windows Server
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.
Windows Server
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.
(more…)Code base
How to use SSL in PHP Data Objects (PDO) mysql
Connect to MySQL 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…
(more…)