Fix the maintenance plan error in SSMS, could not load type IDTSPackageSigning100, when existing plans run fine but you cannot modify them.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
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.
SQL SERVER – FIX : Msg 35295, Level 16 – Log Backup For Database ‘DBName’ on a Secondary Replica Failed
During load testing, a log backup on a secondary replica failed with Msg 35295 because the last backup LSN was ahead of the redo LSN. Here is why.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.