Category Archives: SQL Server 2005

SQL Server Diagnostic Information Queries for August 2013

Posted on August 8, 2013 by Glenn Berry

I have gone through and made some minor updates and bug fixes for all of my SQL Server Diagnostic Information Queries for this month. I also added two new queries at the end of the script, to collect some information … Continue reading →

Posted in Diagnostic Queries, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 | Tagged , | 15 Comments

SQL Server 2005 Diagnostic Information Queries (May 2013)

Posted on May 7, 2013 by Glenn Berry

Here is the May 2013 version of my SQL Server 2005 Diagnostic Information Queries, with some minor tweaks and improvements to several of the existing queries. To go with it is an updated, blank 2005 results spreadsheet, where the tabs … Continue reading →

Posted in SQL Server 2005 | Tagged , | Leave a comment

SQL Server 2005 Diagnostic Information Queries (Dec 2012)

Posted on December 6, 2012 by Glenn Berry

Here is the December 2012 version of my SQL Server 2005 Diagnostic Information Queries, with some minor tweaks and improvements. I dropped a couple of redundant queries, and added a new query at the end. To go with it is … Continue reading →

Posted in SQL Server 2005 | Tagged , | 4 Comments

SQL Server 2005 Diagnostic Information Queries (August 2012)

Posted on August 23, 2012 by Glenn Berry

Here is the August 2012 version of my SQL Server 2005 Diagnostic Information Queries, with some minor tweaks and improvements. To go with it is an updated, blank results spreadsheet, where the tabs in the spreadsheet are labeled and in … Continue reading →

Posted in SQL Server 2005 | Tagged , | 6 Comments

SQL Server 2005 Diagnostic Information Queries (June 2012)

Posted on June 12, 2012 by Glenn Berry

Here is the latest version of my SQL Server 2005 Diagnostic Information Queries, with some minor tweaks and improvements, including query numbering and one new query at the end. To go with it is an updated, blank results spreadsheet, where … Continue reading →

Posted in SQL Server 2005 | Tagged , | 9 Comments

SQL Server 2005 Diagnostic Information Queries (May 2012)

Posted on May 3, 2012 by Glenn Berry

Even though SQL Server 2005 fell out of Mainstream Support back in April of 2011, I know many people are still using it and will be for some time to come. Because of this, I decided to release an updated … Continue reading →

Posted in SQL Server 2005 | Tagged , | 4 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

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