Category Archives: SQL Server 2008

Hotfix for SQL Server 2008/2008 R2 Periodically Does Not Accept Connections Bug

Posted on November 26, 2011 by Glenn Berry

Microsoft has released a hotfix for a very frustrating issue that plagued me for a couple of years at NewsGator.  I recently became reacquainted with this old problem with Error: 18056, Severity: 20, State: 29. Basically what happens is that … Continue reading →

Posted in SQL Server 2008, SQL Server 2008 R2 | Tagged | 18 Comments

SQL Server 2008 Service Pack 3 Cumulative Update 2 Released

Posted on November 22, 2011 by Glenn Berry

Microsoft has released SQL Server 2008 Service Pack 3 Cumulative Update 2, which is Build 10.00.5768.00. I count only 3 fixes in this CU. As I always do, I want to remind everyone that this CU is only for SQL … Continue reading →

Posted in Microsoft, SQL Server 2008 | Tagged | Leave a comment

SQL Server 2008 Service Pack 2 Cumulative Update 7 Released

Posted on November 22, 2011 by Glenn Berry

Microsoft has released SQL Server 2008 Service Pack 2 Cumulative Update 7, which is Build 10.00.4323.00. I count 18 fixes in this CU, several of which are related to Full-Text indexes. If you are still on the SQL Server 2008 … Continue reading →

Posted in Microsoft, SQL Server 2008 | Tagged | Leave a comment

October 2011 SQL Server 2008 Diagnostic Information Queries

Posted on October 18, 2011 by Glenn Berry

Since Microsoft has been so busy releasing Cumulative Updates for both SQL Server 2008 and SQL Server 2008 R2 over the past few days, I thought it would be a good time to release a new version of my SQL … Continue reading →

Posted in SQL Server 2008, SQL Server 2008 R2 | Tagged | 10 Comments

SQL Server 2008 SP3 CU1

Posted on October 18, 2011 by Glenn Berry

Microsoft has been busy getting SQL Server Cumulative Updates released over the past couple of days. The latest release is SQL Server 2008 SP3 CU1, which is Build 10.00.5766.00. This update has 19 listed fixes. Remember, this Cumulative Update is … Continue reading →

Posted in Microsoft, SQL Server 2008 | Tagged | Leave a comment

Microsoft Releases SQL Server 2008 SP3 RTM

Posted on October 6, 2011 by Glenn Berry

Microsoft has released the final, RTM version of SQL Server 2008 Service Pack 3. This is build 10.00.5500. It includes the fixes up to the point of SQL Server 2008 SP2 CU4 (Build 4285). That means that (as usual) if … Continue reading →

Posted in Microsoft, SQL Server 2008 | Tagged | 2 Comments

September 2011 SQL Server 2008 Instance Level Diagnostic Queries

Posted on September 26, 2011 by Glenn Berry

Since it is late September, I thought it would be a good time to release an updated set of Diagnostic queries that focus completely on SQL Server instance level metrics. These queries go a little deeper into the Instance level … Continue reading →

Posted in SQL Server 2008, SQL Server 2008 R2 | Tagged , | 6 Comments

SQL Server MVP Deep Dives, Volume 2 Available at PASS 2011 Summit

Posted on September 24, 2011 by Glenn Berry

Volume 2 of the SQL Server MVP Deep Dives book is now available for pre-order from Amazon and from Manning. This book has all new content, rather than just an update or refresh of Volume 1. Just like the first … Continue reading →

Posted in Microsoft, PASS, SQL Server 2008, SQL Server 2008 R2, SQL Server Denali | Tagged | 1 Comment

September 2011 SQL Server 2008 Diagnostic Queries

Posted on September 20, 2011 by Glenn Berry

Its been a couple of months since I have released an updated version of my SQL Server 2008 Diagnostic Information Queries, so I thought it was about time for a new version. The first half of this set of queries … Continue reading →

Posted in SQL Server 2008, SQL Server 2008 R2 | Tagged , | 6 Comments

Microsoft Releases Two Cumulative Updates for SQL Server 2008

Posted on September 20, 2011 by Glenn Berry

Sticking to their eight week release cycle, Microsoft has released two different Cumulative Updates (CU) for SQL Server 2008. The first update is SQL Server 2008 SP1 CU16, which is Build 10.00.2850. This CU has seven fixes by my count. … Continue reading →

Posted in Microsoft, SQL Server 2008 | Tagged | Leave a comment