Microsoft seems to push the idea on automatic updates for SQL server and Yukon.
I disagree fully with this idea. I give many reasons for this and this is a compilation of my thoughts and comments I received or posts I read.
I would like to know what is the attitude of other DBAs on the subject.
Randy Holloway post this:
This idea is something that I can get behind. Vulnerability in your database servers can be very dangerous to your business, and I think that if you run enterprise software like Microsoft's SQL Server and rely on their platform, it may be a good idea to plug into their auto-updates system. I'm looking forward to reading more about how this feature will work.
I like the idea too, but it's totally unfeasible.
Like many others, my SQL box is behind two firewalls, and only visible from a live server, with TCP filtering active, and Netbios service disabled.
So how Microsoft will be able to update the box automatically ?!??
And no way that I open my network to allow this, the risks are too important.
So sadly unrealistic :-(