SSMS worked fine, but the Restore Database Wizard took forever to open. Here is what I found for a client during a 55 minute On Demand session.
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.
SQL SERVER – Maintenance Plan Error: Cannot Create a Task From XML For Task, Eue to Error 0x80070057. The Parameter is Incorrect. (OnPreExecute)
Creating a new maintenance plan on my virtual machine failed with cannot create a task from XML, error 0x80070057. Here is the fix that worked for me.