Azure IaaS Server with SQL - Automatic Updates

-
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:
https://docs.microsoft.com/en-us/azure/virtual-machines/windows/sql/virtual-machines-windows-sql-automated-patching

Comments

Post a Comment

Popular posts from this blog

Azure - Check Invitation Status to guest user

-
Image
Often times you will need to invite a 3rd party to your Azure AD tenant to support your environment. When you add them to a resource, they will automatically be invited as a guest user in your Azure AD tenant, however they won't be able to access this until they accept the invitation email. If you send an invite to a guest user you can see if they have accepted the invitation or not. You also have the option to resend the invitation. From Azure AD you can search for guest users and drill down into an individual one. Here is what the email looks like - the key here is the email comes from " [email protected] " because it can be sent on behalf of this may end up in the junk or spam email folder, so be sure to have them check there.
Read more

Advice for breaking into the DevOps field

-
 A former co-worker reached out a few weeks ago and was looking for advice to give to his son who was about to Graduate and looking to break into the DevOps field. Here is the advise I gave, specifically around the Chicago market: A few years ago I read "The Phoenix Project" and that really got me to focus on changing my career trajectory. I think it's a great explanation of some of the fundamentals of the DevOps philosophy without being too dry. I can't recommend it enough. Skills wise - automation is going to the be the key thing to focus on and it's not going away anytime soon. Tools like Ansible & Terraform are really great to spend time with. Depending on what his dream job is, I would look up and start to focus on the skills required to get there. For example, if he's interested in working for Google, he'd probably want to put some time in to learn Golang, Kubernetes, etc. I think the most important thing is to network, if he plans on staying in ...
Read more

Blogs for Azure Information

-
Here are some of the blogs that I follow for information around new features in Azure, OMS, Log Analytics, Azure Monitor, etc. Azure Monitoring Services Health Status https://blogs.msdn.microsoft.com/servicemap-status/ Microsoft Azure Roadmap https://azure.microsoft.com/en-us/roadmap/ System Center Me http://systemcenterme.com/ Quae Nocent Docent (Great weekly OMS, SCOM, and Azure Info) https://nocentdocent.wordpress.com/ Operations Management Suite Blog https://blogs.technet.microsoft.com/msoms/
Read more