I noticed that some SQL servers were automatically restarting. After looking on the server, it looks like the settings show that the settings are set to automatically deploy updates:
Looking into the settings show that you may see the message "some settings are managed by your system administrator"
Looking deeper - I checked the registry settings and group policy and saw that they were not configured for automatic updates, additionally, the servers were not joined to the domain.
It appears that the SQL server from the Azure market place is set to automatically install updates Sunday at 2AM using the SQL Server IaaS Agent Extension.
To disable or change this, select the SQL server configuration setting and disable the automatic updates setting.
More information can be found here:
Wednesday, December 20, 2017
I ran into some trouble today troubleshooting a developer's workstation. The issue was when using a Point to Site IKEV2 VPN some clients...
If the service principal expires you may need to update the expiration by creating a new key. In Visual Studio Team Services, the ...
Issue: VSTS reports the following error when trying to use WebDeploy on a release. 2017-06-12T15:00:29.1546658Z [command]C:\vstsagent\A5\_...
As you migrate from AWS to Azure ;) you may find that you need to clear up resources to save costs. For example, you may continue to incur...