Visual Studio 2019 Causes SSMS to Hang or Run Slowly

I recently noticed that my local development copy of SQL Server Manager Studio (SSMS, v12.0.5659.1) would sometime run very slowly and other times seemed just fine. This was typically when writing code. For example, running a query or attempting to modify an existing stored procedure would take up to a minute or more to appear. I searched and found others with similar issues but none of the resolutions worked for me. Then by chance I noticed that my Visual Studio 2019 (v16.67.6) was actively running a local web application project. As soon as I stopped that, SSMS would immediately return … [Read more...]

How We Fixed Windows Update Error 80245006

  We were seeing Windows Update error 80345006 on several Windows Server 2012 R2 servers and none of the fixes I found helped. ESET Server AV was on each of these servers but I had already temporarily disabled protection but with no effect. Later, we had decided to uninstall ESET AV just to see if that helped. But first we tried manually turning off options and the first one we tried resolved the problem! ESET >> Settings >> Advanced Settings >> WEB & EMAIL >> Disable Application protocol content filtering under PROTOCOL FILTERING This apparently disables all of Web Access … [Read more...]