Could not load file or assembly errors come in many flavors. Here is how to read the assembly name and version in the message and fix the missing file.
Restore Database Wizard Slow to Open in SSMS
The Restore Database Wizard reads the backup history stored in msdb before it opens. When that history has grown for years, the wizard is slow. This post counts the history, deletes it in monthly steps with sp_delete_backuphistory, shows how to clean one database’s history, and sets up a regular cleanup so the wizard stays fast.
SQL SERVER – How to Get SQL Server Agent Properties?
During a health check someone asked if SQL Server Agent has settings to tune. It does. Here is how to get SQL Server Agent properties with a simple script.
SQL SERVER – Installation Error – Unable to Open Windows Installer File – 2147286960
Installing SQL Server 2016 failed with “Unable to open Windows Installer file” and error -2147286960. Here is what caused it and how I fixed the setup.
SQL SERVER – FIX: Arithmetic Overflow Error in Object Execution Statistics Report in Management Studio
The SSMS Object Execution Statistics report suddenly failed for a client with Msg 8115, arithmetic overflow converting to int. Here is why and what to do.
SQL SERVER – The Automatically Saved Settings file NewSettings.vssettings Cannot be Found
After cleaning up some data from my user profile, when I launched SQL Server Management Studio 17.4, I got an error. related to automatically saved settings.
SQL SERVER – How to Execute the Query Without Using Management Studio?
A client’s security team removed SQL Server Management Studio from the server. Here are simple ways for beginners to run a query without it.