Monthly Archives: March 2011

SQL Server Denali CTP1 Diagnostic Information Queries

Here is the first SQL Server Denali–specific version of my Diagnostic Information Queries. There are actually only two queries (which are marked in the script) that are different from the SQL Server 2008 and 2008 R2 version of these queries. … Continue reading

Posted in SQL Server Denali | Tagged | 2 Comments

Boulder SQL Server User’s Group Meeting

I will be presenting at the Boulder SQL Server User’s Group (BSSUG) on March 15, 2011. My presentation will be on “Hardware 201: Selecting and Sizing Database Hardware for OLTP Performance”.  Here is the abstract: The foundation of database performance … Continue reading

Posted in Computer Hardware, SQL Server 2008 R2, Teaching | Tagged , | 2 Comments

Mirrored Database Backups vs. Striped Database Backups

I have seen a few people get confused about the difference between a mirrored database backup (which is only available in SQL Server 2005 Enterprise Edition and above) and a striped database backup. A Mirrored Backup is simply a database … Continue reading

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

A Small Collection of SQL Azure Queries

We have been doing some more work with SQL Azure lately, so I have put together a small collection of queries that are pretty useful if you are working with SQL Azure. As a DBA who likes to know what … Continue reading

Posted in Microsoft, SQL Azure | Tagged , | 6 Comments

SQL Server Videos on Channel 9 From Microsoft

Here is a collection of 13 short (less than 10 minutes each) videos about improvements in SQL Server Denali, and in some cases SQL Server 2008 R2 that are posted on Channel 9. They were all added on March 4, … Continue reading

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

Las Vegas SQL Server User’s Group Presentation on March 10

I will be giving a virtual presentation via LiveMeeting on March 10, 2011. The S3OLV User Group meeting starts at 6:30PM PST. My presentation will be “Hardware 201: Selecting and Sizing Database Hardware for OLTP Performance”. Here is the abstract: … Continue reading

Posted in Computer Hardware, Teaching | Tagged | 3 Comments

Visual Studio 2010 SP1 Released

Microsoft has released the RTM version of Visual Studio 2010 SP1, which is available on the MSDN Subscribers web site. Microsoft’s Jason Zander has an interim fix list for SP1 available here. Microsoft’s Brian Harry has the  Team Foundation Server … Continue reading

Posted in Microsoft, Visual Studio 2010 | Tagged | Leave a comment

March 2011 Version of SQL Server 2005 and 2008 Diagnostic Queries

Another month, and another new version of my SQL Server Diagnostic Information queries for both SQL Server 2005 and SQL Server 2008/2008 R2. I have uploaded the scripts for each version to DropBox (see the links below). There are two … Continue reading

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

SQL Server Hardware Selection Presentation from Rocky Mountain Tech Trifecta

I just wanted to post a link to my presentation on Hardware 201: Selecting and Sizing Database Hardware for OLTP Performance that I gave on March 5, 2011 at the Rocky Mountain Tech Trifecta in Denver, Colorado.

Posted in Computer Hardware, SQL Server 2008 R2 | Tagged , | 2 Comments

SQL Server 2008 R2 RTM Cumulative Update 6 Released

Microsoft actually released SQL Server 2008 R2 Cumulative Update 6 on February 21, 2011, so I am a little late to blog about it, but I wanted to have a record (since I sometimes use my own blog posts to … Continue reading

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