Moving a WordPress site from HTTP to HTTPS is seven steps. This tutorial covers the backup, the certificate, the two WordPress addresses, the link replacement, mixed content, the 301 redirect and the follow-up in Search Console and Analytics.
SQL SERVER – Maintenance Plan – Could not load type ‘Microsoft.SqlServer.Dts. Runtime.Wrapper. IDTSPackageSigning100’ from Assembly
Fix the maintenance plan error in SSMS, could not load type IDTSPackageSigning100, when existing plans run fine but you cannot modify them.
Unable to Initialize Encryption in SQL Server: Error 17182 and the Security Library
Unable to initialize encryption can stop SQL Server before it accepts a connection, as it did on a SQL Server 2008 SP4 instance in 2017. This post reads the startup messages, corrects an old explanation about missing TLS registry keys and shows tested checks for the ERRORLOG, the certificate and the Schannel settings.
SQL SERVER – FIX : Error Msg 8672 – The MERGE Statement Attempted to UPDATE or DELETE the Same Row More Than Once
While preparing a demo I hit Msg 8672: the MERGE statement attempted to UPDATE or DELETE the same row more than once. Here is why and how to avoid it.
How to Get Status of Running Backup and Restore in SQL Server? – Interview Question of the Week #113
How do you check the status of running backup and restore operations? Here is the script I built to see every backup and restore running on the server.
Print Status Messages Using RAISERROR WITH NOWAIT
To see progress while a long script runs, use RAISERROR WITH NOWAIT instead of PRINT. This post builds a progress loop, formats values with placeholders, and shows the percent sign trap that garbles a message. It also explains how severity decides whether a message stays inside a TRY block, and where the 2,047 character limit cuts a message.
SQL SERVER – Script Upgrade – Server Principal ‘MS_PolicyEventProcessingLogin’ Has Granted One or More Permission(s)
SQL Server would not start after patching: Script Upgrade failed because ##MS_PolicyEventProcessingLogin## had been granted permissions. Here is the fix.