Microsoft has released SQL Server 2008 Service Pack 3 Cumulative Update 11, which is Build 10.0.5840.00. There are six hotfixes in the public fix list. There is no corresponding cumulative update for earlier service pack levels for SQL Server 2008, since they are retired. If you are on SQL Server 2008, you really should be [...]
Glenn Berry
Semi-random musings about SQL Server performance
SQL Server 2008 Service Pack 3 Cumulative Update 11
Posted on: May 21, 2013 5:57 am
A SQL Server Hardware Tidbit a Day – Day 16
Posted on: April 16, 2013 12:14 pm
For Day 16 of this series, I am going to talk about a few useful tools you can use to identify some hardware details about a database server. These tools all require that you have access to login to that server, which might be a problem for some people, depending on the policies of their [...]
Microsoft DreamSpark Program
Posted on: March 25, 2013 1:56 pm
Back in 2008, Microsoft rolled out the DreamSpark program as a means to get Microsoft software design and development tools in the hands of students at no charge. It was initially only for university or college students, but it has been expanded to also cover high school students. Basically, this means that any high school, [...]
SQL Server 2008 R2 Service Pack 1 Cumulative Update 11
Posted on: February 25, 2013 2:39 pm
On February 18, 2013, Microsoft released SQL Server 2008 R2 Service Pack 1 Cumulative Update 11, which is Build 10.50.2869. There are only four fixes in the public fix list for this cumulative update. This cumulative update is only for SQL Server 2008 R2 Service Pack 1. If you have a different version and/or service [...]
SQL Server 2008 R2 Service Pack 2 Cumulative Update 5
Posted on: February 25, 2013 1:49 pm
On February 18, 2013, Microsoft released SQL Server 2008 R2 Service Pack 2 Cumulative Update 5, which is Build 10.50.4276. There are 21 fixes in the public fix list for this cumulative update, which is a pretty decent amount of fixes. This cumulative update is only for SQL Server 2008 R2 Service Pack 2. If [...]
SQL Server 2012 RTM Cumulative Update 6
Posted on: February 25, 2013 1:06 pm
On February 18, 2013 Microsoft released SQL Server 2012 RTM Cumulative Update 6, which is Build 11.0.2401. This CU has 22 fixes listed in the public fix list, which is quite a bit fewer hotfixes than in the first five cumulative updates for the RTM branch of SQL Server 2012. I take this as a [...]
SQL Server 2012 Service Pack 1 Cumulative Update 2
Posted on: February 1, 2013 1:03 pm
On January 21, 2013, Microsoft released SQL Server 2012 Service Pack 1 Cumulative Update 2, which is Build 11.0.3339. This Cumulative Update has 50 hotfixes by my count, and two new features (which is quite unusual for a SQL Server Cumulative Update). This CU gets the SQL Server 2012 Service Pack 1 branch to parity [...]
Important Hotfix for SQL Server 2008 and Newer
Posted on: January 10, 2013 1:46 pm
Microsoft recently released a hotfix for a memory leak leak issue that affects SQL Server 2008, SQL Server 2008 R2, and SQL Server 2012. This memory leak only occurs if the have the AUTO_UPDATE_STATISTICS_ASYNC database level setting enabled for any of your databases. Here is how Microsoft describes the issue in the hotfix KB article: [...]
Performance and Stability-Related Fixes in Recent SQL Server 2008 SP3 Cumulative Updates
Posted on: December 19, 2012 2:04 pm
Even though I like to talk about the most recent major releases of SQL Server, there are still plenty of organizations running SQL Server 2008, which was a good, solid release of the product, with many improvements over SQL Server 2005. Lets assume that you have been pretty diligent about keeping your SQL Server 2008 [...]
Oracle versus Microsoft on Vaporware Fantasies
Posted on: November 25, 2012 6:10 pm
A couple of weeks ago, Oracle’s SVP of Communications Bob Evans wrote a pretty inflammatory blog post that was on ForbesBrandVoice, which seeks to “connect marketers to the Forbes audience”. The original post was removed on November 20, so my link points to a cached copy. In the post, he calls the Microsoft Hekaton project [...]
Windows Update vs. Microsoft Update
Posted on: October 29, 2012 3:45 pm
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, [...]
Task Manager Enhancements in Windows Server 2012
Posted on: October 23, 2012 3:59 am
Windows Server 2012 was released to manufacturing on August 1, 2012, and it became “generally available” to customers on September 4, 2012. It is now being offered as an available server operating system from the Tier 1 hardware vendors, such as Dell, HP, IBM, etc. That means that you are likely to see new servers [...]
