Category Archives: SQL Server 2008

SQL Server 2008 Diagnostic Information Queries (April 2012)

Posted on March 28, 2012 by Glenn Berry

Since it is nearly April, I will go ahead and jump the gun again and post an updated version of my SQL Server 2008 Diagnostic Information Queries. This version works on SQL Server 2008 and SQL Server 2008 R2. There … Continue reading →

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

SQL Server Database Mirroring Tips and Tricks, Part 3

Posted on March 27, 2012 by Glenn Berry

One of the challenges you face with SQL Server database mirroring is making sure that all of the databases that are dependent on each other will failover together, so they are running on the same side of the database mirroring … Continue reading →

Posted in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 | Tagged | 12 Comments

SQL Server Database Mirroring Tips and Tricks, Part 2

Posted on March 21, 2012 by Glenn Berry

If you ever find yourself having to setup database mirroring between different, untrusted Windows Domains, one of the most common ways to do it involves creating certificates on each instance, creating logins and users for those certificates, and copying the … Continue reading →

Posted in Microsoft, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 | Tagged | 1 Comment

Microsoft Releases SQL Server 2008 SP3 Cumulative Update 4

Posted on March 21, 2012 by Glenn Berry

Microsoft has also released SQL Server 2008 SP3 Cumulative Update 4. This is Build 10.00.5775.00, and it has ten fixes listed in the public fix list. Remember, this Cumulative Update is only for SQL Server 2008 SP3. It will not … Continue reading →

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

Microsoft Releases SQL Server 2008 SP2 Cumulative Update 9

Posted on March 20, 2012 by Glenn Berry

Right on schedule, Microsoft has released SQL Server 2008 SP2 Cumulative Update 9. This is Build 10.00.4330.00, and it has seven fixes listed in the public fix list. Remember, this Cumulative Update is only for SQL Server 2008 SP2. It … Continue reading →

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

SQL Server Database Mirroring Tips and Tricks, Part 1

Posted on March 12, 2012 by Glenn Berry

Even though SQL Server Database Mirroring is deprecated in SQL Server 2012, it is still a very useful HA/DR technique that should work perfectly well for at least two-three major versions of SQL Server after the newly released SQL Server … Continue reading →

Posted in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 | Tagged | 7 Comments

SQL Server Database Mirroring (Not Dead Yet)

Posted on March 7, 2012 by Glenn Berry

SQL Server Database Mirroring is a high availability and disaster recovery feature that was added to the product with SQL Server 2005, and enabled without a trace flag in SQL Server 2005 SP1. It was enhanced in SQL Server 2008 … Continue reading →

Posted in Microsoft, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 | Tagged | 6 Comments

January 2012 SQL Server 2008/2008 R2 Diagnostic Information Queries

Posted on January 23, 2012 by Glenn Berry

Since Microsoft recently released a couple of new Cumulative Updates for SQL Server 2008, I thought it was finally time to release a new version of my SQL Server 2008/2008 R2 Diagnostic Information Queries for January 2012. You will need … Continue reading →

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

Scaling SQL Server Presentation from SQLSaturday #104 Precon

Posted on January 12, 2012 by Glenn Berry

On Friday, January 6, 2012, I got the opportunity to present an expanded version of my “Scaling SQL Server” presentation down in Colorado Springs. I think it went pretty well, and I got some nice feedback from the attendees. Being … Continue reading →

Posted in PASS, Processors, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 | Tagged | 2 Comments

SQL Server 2008 Diagnostic Information Queries (December 2011)

Posted on December 28, 2011 by Glenn Berry

Here is a fresh set of diagnostic information queries for SQL Server 2008 and 2008 R2 for December 2011. Some of the queries (which are labeled) will only work with SQL Server 2008 R2 Service Pack 1 or later. Most … Continue reading →

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