I got the chance to give an updated version of Hardware 201: Selecting and Sizing Database Hardware for OLTP Performance to an audience of about forty people at the Denver SQL Server User’s Group on May 19, 2011, which was a lot of fun. You can download the presentation here Read more

Microsoft has released two new Cumulative Updates for SQL Server 2008 SP1 and SQL Server 2008 SP2. The first one is SQL Server 2008 SP1 Cumulative Update 14, which is Build 2821. This CU has only ten fixes.

The second one is SQL Server 2008 SP2 Cumulative Update 4 Read more

I will be giving the main presentation at this month’s meeting of the Denver SQL Server User’s Group on May 19, 2011. Here is the abstract:

“Hardware 201: Selecting and Sizing Database Hardware for OLTP Performance”

The foundation of database performance is the underlying server hardware and storage subsystem. Even…

Read more

Since we are in the middle of May 2011, I thought was was time to update my SQL Server 2008 Diagnostic Information Queries. These are very similar to the April 2011 version except for one new query at the end of the set.

You can click on the link… Read more

PASS has added a new feature to the session selection process for the PASS Summit 2011, which they are calling the PASS Summit 2011 Session Preference Survey. This allows you to mark multiple proposed sessions for the PASS Summit 2011 as “Preferred”.  This gives you the opportunity to… Read more

I will be speaking at the Colorado Springs SQL Server User’s Group, live and in person, on Wednesday, June 15, 2011.  I will be giving an updated version of my Hardware 201: Selecting and Sizing Database Hardware for OLTP Performance presentation. The meeting will be at the Mr. Biggs… Read more

Today is the last day to submit session abstracts for the PASS 2011 Summit.  I was lucky enough to speak at PASS in 2009 and in 2010, so I hope my luck will continue. I submitted two sessions last night, and I plan on submitting at least two more sessions… Read more

Writing a month long series is always a lot more work than you initially expect. You would think that I would have remembered that fact from April 2010, when I wrote my DMV a Day series…  Since my memory was short, I decided to write another month long series… Read more

For Day 30 of this series, (which is the last day), I am going to talk a little about RAID, which stands for Redundant array of independent disks or Redundant array of inexpensive disks, depending on who you believe.

RAID is a technology that allows use of multiple hard… Read more