Monthly Archives: May 2012

Analyzing TPC-E Benchmark Performance by Physical Processor Core

The TPC Benchmark E (TPC-E) is an OLTP performance benchmark that was introduced in May, 2007. The TPC-E benchmark is a not a replacement for the old TPC-C benchmark, but rather is a completely new OLTP benchmark. Even though this … Continue reading

Posted in AMD, Computer Hardware, Intel, Processors, SQL Server 2008 R2, SQL Server 2012 | Tagged , | 3 Comments

SQL Server 2008 SP3 Cumulative Update 5 Released

Microsoft has released two new Cumulative Updates for SQL Server 2008 today. The first one is SQL Server 2008 SP3 CU5, which is Build 10.00.5785.00. There are only four fixes listed in the public fix list. The second Cumulative Update … Continue reading

Posted in Microsoft, SQL Server 2008 | Tagged | 1 Comment

Dell 12th Generation Server Cheat Sheet

Over the past several months, Dell has been rolling out a number of new 12th generation servers that all use the new 32nm Intel Xeon E5 series processor (aka Sandy Bridge-EP). These new servers all have much higher memory density … Continue reading

Posted in Computer Hardware, Dell, Processors, SQL Server 2012 | Tagged | 10 Comments

Speaking at Rocky Mountain Tech Trifecta 2012 on May 19

I will be presenting two sessions at the Rocky Mountain Tech Trifecta in Denver on May 19, 2012. This is an all-day, free event that is very similar to a SQLSaturday or a CodeCamp. There are a large number of … Continue reading

Posted in Computer Hardware, Microsoft, Teaching | Tagged | Leave a comment

The Fantastic 12 of SQL Server 2012

The SQL Server Team Blog is in the midst of posting twelve, short weekly videos that let someone from the SQL Server Product team talk about their favorite features and improvements in SQL Server 2012. These videos go up every … Continue reading

Posted in Microsoft, SQL Server, SQL Server 2012, SQL Server Denali | Tagged | 1 Comment

Updated SQL Rockstar Blogger Rankings

This morning, Thomas LaRock (blog |@SQLRockstar) released an updated version of his Blogger Rankings. I was very happy and humbled to see that I had been promoted to the ResourceDB group, which I really appreciate!  My co-worker, Joe Sack (blog … Continue reading

Posted in Blogging, SQL Server, Teaching | Tagged | Leave a comment

SQL Server 2005 Diagnostic Information Queries (May 2012)

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

Building an Intel Ivy Bridge Desktop System, Part 2

A few weeks ago, I wrote about buying some of the components that I needed to build a new 22nm Ivy Bridge based desktop system. When I wrote that initial blog post, the actual Ivy Bridge desktop processors were not … Continue reading

Posted in Computer Hardware, Intel, Ivy Bridge, Processors | Tagged | 5 Comments

Checking Your Main BIOS Version

As some of you may know, I spent four years in the U.S. Marine Corps back during the Reagan administration. I started out as an 0311 Basic Rifleman (aka Grunt) for a couple of years, and then became an 1811 … Continue reading

Posted in Computer Hardware, Dell, Laptops | Tagged , , | 11 Comments