Best Practices
On an installed instance of Microsoft SQL Server Express on the workstation, Oracle Food and Beverage recommends that you apply the latest security updates and critical updates including general distribution releases (GDRs), service packs (SPs), and cumulative updates (CUs).
Applying Updates
Microsoft SQL Server updates are available through Microsoft Updates (MU), Windows Server Update Services (WSUS) and the Microsoft Download Center. Security and Critical updates for Microsoft SQL Server are available through Microsoft Updates, and to be able to view these updates, you need to opt-in to MU through the Microsoft Windows Updates applet from the Control Panel.
When you receive an update through Microsoft Updates, the system updates all Microsoft SQL Server features to the latest version in an unattended mode.
Source
See Install SQL Server Servicing Updates for Microsoft recommendations.
Additional Microsoft SQL Server Information
Table 1-1 Microsoft SQL Server 2008 R2
| Latest Service Pack | Source |
|---|---|
|
Microsoft SQL Server 2008 R2 Service Pack 3 (extended support ends on July 9, 2019) |
|
Table 1-2 Microsoft SQL Server 2012
| Latest Service Pack | Source |
|---|---|
|
Microsoft SQL Server 2012 Service Pack 4 (extended support ends on July 12, 2022) |
|
Parent topic: Database Security