SQL Server updates from Microsoft

Is there any way I can get latest updates from Microsoft? like when ever they release a latest service pack or latest patch (If so where can I subscribe so that I can be notified thru my email )..

Pls help
shadycAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

DonNetwork AdministratorCommented:
Why dont you use WSUS?
 
Products Supported by WSUS
0
shadycAuthor Commented:
Is this is the only way?
0
DonNetwork AdministratorCommented:
0
Newly released Acronis True Image 2019

In announcing the release of the 15th Anniversary Edition of Acronis True Image 2019, the company revealed that its artificial intelligence-based anti-ransomware technology – stopped more than 200,000 ransomware attacks on 150,000 customers last year.

shadycAuthor Commented:
It looking good but I need only for  SQL Server security updates and every thing related to SQL Server >pl direct me to that link or what ever so that I can subscribe to it.

Thanks
0
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
If you want to apply Security patches alone, then you need to do it manually.
Using WSUS applies all sorts of patches into your machine.

For SQL Server, that's not recommended.
You can download the Service Packs Manually and apply it which is recommended.

If you do it automatically through WSUS and something fails in the middle then you will risk losing your data and server will be down.

Hence apply patches manually for SQL Server related things.
0
DonNetwork AdministratorCommented:
"For SQL Server, that's not recommended."

Whhhaaaattt? not recommended by who?

 If that was the case it wouldnt be included in products and classifications. WSUS is definitely the way to go. Also you can configure WSUS to email you each time new updates are synchronized. So as soon as there is a SQL update ready to be approved you would get an email(along with all other updates).

As far as a link to only SQL updates, there is none. They would be included in the security bulletins along with all other updates.
0
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
>> Whhhaaaattt? not recommended by who?

If you have automatic updates configured through WSUS, then you might face the following issues.

1. Some Updates require a SQL Server Instance restart which is not recommended in a Production / Live Database.
2. While applying patches / updates it makes internal connection resets which are not recommended in a Production / Live Database.
3. If you apply Updates to go in this manner, then when installing Service Packs you will obtain errors stating that some of the features are already installed. ( Hope you might be aware that SQL Server Updates / Service Packs are cumulative.)

Hence normally in Production Environment, SQL Server Machines will be kept in machines where WSUS is not applicable and Even in many of the hotfixes for SQL Server, it is recommended to install them if they face some kind of problems. Otherwise its not recommended to install those updates.

We have faced several other problems like this in SQL Server because of Automatic Updates from WSUS.

Kindly Note that I am referring only to SQL Server related Updates/ Patches and not for Windows Server patches / Updates.

>>Also you can configure WSUS to email you each time new updates are synchronized. So as soon as there is a SQL update ready to be approved you would get an email(along with all other updates).

Agree with you on this aspect and WSUS works this way. But you need to analyze the updates whether it requires a instance restart or system restart and after that you need to apply it. In a production / Live database servers you cant allow WSUS to run on its own and that's what I referred earlier.

Hope I clarified you better.
0
DonNetwork AdministratorCommented:
Hmmm.... still didnt provide documentation on this recommendation.

WSUS doesnt run on its own. You can configure how updates are approved. You can configure how restarts are handled. You can configure when updates are installed. You can configure for detect only and then install at your leisure. Sounds like you havent a full understanding of all the settings available with windows updates and WSUS.
0
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
Ok.. Some documentation for your reference.

http://support.microsoft.com/kb/942908/
http://support.microsoft.com/kb/943526/
http://support.microsoft.com/kb/945641/
http://support.microsoft.com/kb/945640/
http://support.microsoft.com/kb/942908/

In all the above SQL Server 2005 Updates / Hotfixes, you can see this paragraph "Hotfix Information"

Hotfix information
A supported hotfix is available from Microsoft. However, this hotfix is intended to correct only the problem that is described in this article. Apply this hotfix only to systems that are experiencing this specific problem. This hotfix might receive additional testing. Therefore, if you are not severely affected by this problem, we recommend that you wait for the next software update that contains this hotfix.

It suggests you to wait for the next Service Packs or Cumulative Packs so that the complete tested version of fix can be applied. That's why I recommended not to install these hotfixes through WSUS.

Applying Service Packs would be the ideal way and these kind of hotfixes should be applied only if required.

I am aware of WSUS functionality a little but not in depth but as per the information in all the hotfix links, Can you tell me whether I am correct or not.

Those hotfixes are intended for any machines that faces that problem and not for all. Applying to all machines might affect your existing thing too.

Hope My clarification sounds good with proofs on it.
0
DonNetwork AdministratorCommented:
LOL, no it doesnt prove it one ioda. Those are all hotfixes. Hotfixes are for specific problems in certain cases. Hotfixes are not deployed thru either WSUS or Windows updates. They need to be requested, you dont get them unless you manually download them after getting the link via email. I understand your concerns, But we have been running many SQL databases in WSUS environment without a hitch.
0
shadycAuthor Commented:
I just need to configure WSUS to my email so as soon as there is a SQL update ready to be approved I would get an email(along with all other updates). I can manually install them.
Can any one of you let me know how to subscribe. I dont really see that.


Thanks much!
0
DonNetwork AdministratorCommented:
As below
wsusemail.bmp
0
shadycAuthor Commented:
Can you send me the link pls..?or can you direct me from here..
http://technet.microsoft.com/en-us/wsus/default.aspx
0
DonNetwork AdministratorCommented:
The picture above shows you exactly where to go to configure this. After doing so, every new update that is synchronized in wsus whether approved or not will send you an email.
 
The email will look similar as below

 

wsussampleemail.bmp
0
DonNetwork AdministratorCommented:
I should have also asked, Do you have WSUS installed?
0
shadycAuthor Commented:
No I dont have.
0
shadycAuthor Commented:
Do I need to Install something?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.