Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: March 2011

Intel Sandy Bridge Mobile Processors Explained

The long wait for the new, mobile Sandy Bridge processor equipped laptops is nearly over. Most of the large system vendors have announced their new lines, and systems are starting to actually ship.

These machines will have significantly better performance and better battery life than their 2010 vintage predecessors.

Below… Read more

0 comments, 517 reads

Posted in Glenn Berry's SQL Server Performance on 24 March 2011

Presenting To Columbus SQL Server User’s Group on April 14

I will be doing a live, virtual presentation for the Columbus, Ohio SQL Server User’s Group on Thursday, April 14. The meeting is from 6PM till 8PM, Eastern time, and I believe that my presentation will start at about 6:45PM.

Here is the title and abstract:

Dr. DMV: How to…

Read more

1 comments, 303 reads

Posted in Glenn Berry's SQL Server Performance on 23 March 2011

Microsoft System Center Advisor (Release Candidate)

Microsoft’s Brad Anderson announced the availability of the Release Candidate of Microsoft System Center Advisor today in his keynote presentation at the Microsoft Management Summit 2011 in Las Vegas.

This is a new product that periodically captures configuration information about your servers (that you have added to the product), and… Read more

0 comments, 578 reads

Posted in Glenn Berry's SQL Server Performance on 22 March 2011

SQL Server 2008 SP2 Cumulative Update 3

Microsoft has released SQL Server 2008 SP2 Cumulative Update 3, which is Build 10.00.4279.00. I count 25 fixes listed in the Knowledge Base article for the Cumulative Update.

Here is the SQL Server 2008 CU Build Matrix:

-- SQL Server 2008 RTM is considered an "unsupported service pack" as…

Read more

0 comments, 676 reads

Posted in Glenn Berry's SQL Server Performance on 22 March 2011

SQL Server 2008 SP1 Cumulative Update 13

Microsoft has released  SQL Server 2008 SP1 Cumulative Update 13, which is Build 10.00.2816.00. I count twelve fixes listed in the Knowledge Base article for the Cumulative Update.

I am a little surprised that they did not skip the unlucky number 13, but I am not actually superstitious about… Read more

0 comments, 246 reads

Posted in Glenn Berry's SQL Server Performance on 22 March 2011

SQL Server 2005 SP4 Cumulative Update 3

Microsoft has released SQL Server 2005 SP4 Cumulative Update 3, which is Build 9.0.5266. There are only five fixes listed in the KB article for this final release. Here is what Microsoft says about the release:

SQL Server 2005 SP4 CU 3 marks the final Cumulative Update release for…

Read more

0 comments, 720 reads

Posted in Glenn Berry's SQL Server Performance on 22 March 2011

SQL Server 2005 SP3 Cumulative Update #15

Microsoft has released SQL Server 2005 SP3 Cumulative Update 15, which is Build 9.0.4325. There are only six fixes included in this final release. Here is what Microsoft says about the release:

SQL Server 2005 SP3 CU 15 marks the final Cumulative Update release for SQL Server 2005 SP3…

Read more

0 comments, 302 reads

Posted in Glenn Berry's SQL Server Performance on 22 March 2011

Are You Taking Advantage of Twitter for SQL Server?

One thing I always do lately, whenever I give a presentation is ask the audience how many of them use Twitter. In most cases, less than half of the audience is on Twitter, and it is often much lower than that.

This gives me an opportunity to spend a few… Read more

4 comments, 283 reads

Posted in Glenn Berry's SQL Server Performance on 18 March 2011

Teaching Two Classes at University College–University of Denver

I will be teaching two classes for the Spring 2011 Quarter at University College – University of Denver. One will be on campus, and one will be online.

The on campus class will be ICT 4415 Database Backup and Recovery w/Lab , which despite the title, will be more… Read more

0 comments, 220 reads

Posted in Glenn Berry's SQL Server Performance on 18 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.

There will be additional Denali-specific items added in the… Read more

1 comments, 378 reads

Posted in Glenn Berry's SQL Server Performance on 16 March 2011

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 is the underlying server hardware and storage subsystem. Even the…

Read more

0 comments, 190 reads

Posted in Glenn Berry's SQL Server Performance on 15 March 2011

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 backup where two copies of the database backup file are… Read more

1 comments, 614 reads

Posted in Glenn Berry's SQL Server Performance on 14 March 2011

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 is going on with my database servers and individual databases,… Read more

0 comments, 1,174 reads

Posted in Glenn Berry's SQL Server Performance on 11 March 2011

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, 2011.

These are basically high level conceptual videos with Program… Read more

2 comments, 588 reads

Posted in Glenn Berry's SQL Server Performance on 9 March 2011

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:

The foundation of database performance is the underlying server hardware…

Read more

1 comments, 231 reads

Posted in Glenn Berry's SQL Server Performance on 9 March 2011

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 (TFS) related fixes listed here. Finally, Microsoft’s Amit… Read more

0 comments, 330 reads

Posted in Glenn Berry's SQL Server Performance on 8 March 2011

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 new queries in this version:

-- Get total buffer usage…

Read more

3 comments, 196 reads

Posted in Glenn Berry's SQL Server Performance on 8 March 2011

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.


Read more

0 comments, 194 reads

Posted in Glenn Berry's SQL Server Performance on 5 March 2011

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 find things later). This is Build 10.0.1765.0, and I count… Read more

1 comments, 575 reads

Posted in Glenn Berry's SQL Server Performance on 1 March 2011

Rocky Mountain Tech Trifecta on March 5

I will be attending and speaking at the Rocky Mountain Tech Trifecta in downtown Denver on March 5, 2011. This is a free, all day event that combines what you would get at a SQLSaturday along with what you would see at a Code Camp. There is .NET, SQL Server,… Read more

0 comments, 182 reads

Posted in Glenn Berry's SQL Server Performance on 1 March 2011