Installing a service pack on a clustered instance failed with EnumeratorException: Failed to retrieve data for this request. Detail.txt showed the cause.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Availability Group Missing or Deleted Automatically?
After a network issue, two availability groups vanished from SSMS. Here is how the logs explained an availability group missing or deleted automatically.
Move a WordPress Site from HTTP to HTTPS: A Complete Tutorial
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.
SQL SERVER – Errorlog The Server was Unable to Initialize Encryption Because of a Problem with a Security Library
SQL Server would not start, and the ERRORLOG said the server was unable to initialize encryption because of a problem with a security library.
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.
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.