Small Enhancement to Microsoft SQL Server CU Knowledge Base Articles

Microsoft has made a small, but helpful improvement to the format for their Knowledge Base articles that accompany new Cumulative Updates for SQL Server 2012 and SQL Server 2014. As you hopefully know, there will not be any more cumulative updates for SQL Server 2008 or SQL Server 2008 R2, since those versions are now […]

SQL Server 2014 RTM Cumulative Update 3

Microsoft has released (about a week early by my calendar) SQL Server 2014 RTM Cumulative Update 3, which is build 12.0.2402. It has 32 fixes in the public fix list. As always, I think that you should strongly consider applying this update to your SQL Server 2014 instances, after you have done your normal round […]

SQL Server 2014 RTM Cumulative Update 2

Microsoft has released SQL Server 2014 RTM Cumulative Update 2, which is Build 12.0.2370.0. It has 48 hotfixes in the public fix list. This is one of the more interesting fixes: FIX: Intense query compilation workload does not scale with growing number of cores on NUMA hardware and results in CPU saturation in SQL Server […]

SQL Server 2008 Service Pack 3 Cumulative Update 17

On May 19, 2014, Microsoft released SQL Server 2008 Service Pack 3 Cumulative Update 17, which is Build 10.00.5861.0. This Cumulative Update has nine hotfixes in the public fix list, most of them for the Database Engine. The most interesting one to me is this one: FIX: Performance problems occur when database lock activity increases […]

Microsoft DreamSpark for Students and Educators

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, […]

Performance Related Fixes in Post-SQL Server 2008 Service Pack 3 Builds

As you may be aware, Microsoft released SQL Server 2008 Service Pack 3 back around October of 2011. Even though there has not been an official announcement yet from Microsoft, it seems likely that there will not be a SQL Server 2008 Service Pack 4 release before SQL Server 2008 (and SQL Server 2008 R2) […]

Final Service Packs for SQL Server 2008 and SQL Server 2008 R2

As we get ever closer to the end of mainstream support for both SQL Server 2008 and SQL Server 2008 R2 on July 8, 2014, I am very curious whether Microsoft is planning on releasing a SQL Server 2008 R2 Service Pack 3 or a SQL Server 2008 Service Pack 4 ? SQL Server 2008 […]

Performance and Stability Related Fixes in Post-SQL Server 2012 SP1 Builds

Updated to include SP1 CU9: There have already been nine Cumulative Updates (CU) for the Service Pack 1 branch of SQL Server 2012. There have been a fairly high number of hotfixes in every one of these Cumulative Updates, as more people are using SQL Server 2012 over the past eighteen months. SQL Server 2012 […]

Performance Related Fixes in Post-SQL Server 2008 R2 Service Pack 2 Builds

As you may be aware if you have been reading my blogs or books over the years, I am a pretty strong advocate of staying current with both SQL Server Service Packs and SQL Server Cumulative Updates. This is also something that SQLskills recommends on our customer engagements. Despite this, it is still quite common […]

Most Recent Cumulative Updates for SQL Server

Here are the most recent cumulative updates for SQL Server 2012, 2008 R2 and 2008. SQL Server 2012 RTM CU10 (11.0.2420)          released on October 21, 2013 SQL Server 2012 SP1 CU6 (11.0.3381)            released on September 16, 2013 If you are on SQL Server 2012, both RTM and Service Pack 1 are still a “supported service […]

SQL Server 2012 RTM Cumulative Update 10

Microsoft has released SQL Server 2012 RTM Cumulative Update 10 (Build 11.0.2420). This CU only has four fixes in the Public hotfix list. Two for SSAS, one for SSRS, and one for the Database Tuning Advisor (DTA). From a Database Engine perspective, there is not too much to get excited about for this particular cumulative […]

SQL Server 2008 Service Pack 3 Cumulative Update 11

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 […]

A SQL Server Hardware Tidbit a Day – Day 16

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

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

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

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

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

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

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

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

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

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

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 […]