SQL Server 2008 R2 SP2 CU9

Microsoft has released SQL Server 2008 R2 SP2 CU9, which is Build 10.50.4295. This CU has eighteen hotfixes in the public fix list. Some of the more important ones are listed below: FIX: Poor performance when SQL Server 2008 or SQL Server 2008 R2 requires memory from a local node in a NUMA environment FIX: […]

Microsoft Update offering SQL Server 2012 SP1 Cumulative Update 2

I was doing some routine maintenance on one of the SQLskills lab servers (a pretty nice Dell PowerEdge R720) on Sunday night when I noticed that Microsoft Update (which is a superset of Windows Update) was offering “Update Rollup for SQL Server 2012 Service Pack 1 (KB2790947)” as an Optional Update for a Windows Server […]

Windows Update vs. Microsoft Update

If you are running any recent version of Windows (including Windows RT), you have Windows Update available as part of the operating system. If you so choose, you can also install Microsoft Update, which is a superset of Windows Update that will allow you to get updates for Microsoft Office, Windows Live, the .NET Framework, […]

How to Obtain and Install SQL Server Service Packs and Cumulative Updates

If you are in charge of one or more SQL Server instances, whether they are on your laptop, or a large Production data center, you should be aware of how SQL Server updates and fixes are released, and how you can obtain them from Microsoft. First, a few definitions: RTM means Release to Manufacturing. It […]