Category Archives: Computer Hardware

Selecting an Appropriate Intel Xeon E5-2600 v2 Family Processor for SQL Server 2012

Intel has finally released the 22nm Xeon E5-2600 v2 Family (Ivy Bridge-EP) of processors that will be used in two-socket servers. These processors have slightly better single-threaded performance than the previous 32nm Xeon E5-2600 Family (Sandy Bridge-EP) processors, along with … Continue reading

Posted in Computer Hardware, Intel, Ivy Bridge-EP, SQL Server 2012 | Tagged | 3 Comments

Hardware 201: Selecting and Sizing Database Hardware

On July 25, I had the opportunity to present Hardware 201 for the PASS Performance Virtual Chapter. You can download my deck here. Hardware 201: Selecting and Sizing Database Hardware for OLTP Performance The foundation of database performance is the … Continue reading

Posted in Computer Hardware, Intel, Processors, SQL Server 2012, Teaching | Tagged , | Leave a comment

Speaking in Denver and Boulder in June

I will be speaking at the Boulder SQL Server User’s Group on June 18, 2013 and at the Denver SQL Server User’s Group on June 20, 2013. In both cases, I will be presenting an updated version of  Hardware 201. … Continue reading

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

New Immersion Event Classes at SQLskills

There are three new upcoming Immersion Event classes from SQLskills, including one that I will be teaching, which is the two-day IEHW class on September 18-19. I am really excited to get the chance to teach the IEHW class, and … Continue reading

Posted in Computer Hardware, SQL Server, Teaching | Tagged , | Leave a comment

Hardware 301 Presentation

I had the opportunity to present the latest version of Hardware 301: Diving Deeper into Database Server Hardware two times in one day yesterday! First was a virtual presentation for the PASS Virtual DBA chapter at 12PM, and then I … Continue reading

Posted in Computer Hardware, Processors, Sandy Bridge, SQL Server 2012 | Tagged | 3 Comments

Speaking at PASS Database Administration Virtual Chapter

I will be speaking at the PASS Database Administration Virtual Chapter on February 13, 2013 at 12PM MST. I will be presenting the latest version of my Hardware 301: Diving Deeper into Database Hardware deck. The LiveMeeting link is here. … Continue reading

Posted in Computer Hardware, PASS, Processors, Storage Subsystems | Tagged | 1 Comment

SQL Server 2012 Standard Edition Licensing Limits

As you might be aware, SQL Server 2012 Standard Edition has some hardware-related licensing limits that I think should be adjusted in light of the capabilities of modern, commodity server hardware. As a DBA and consultant, I would like to … Continue reading

Posted in Computer Hardware, Microsoft, SQL Server 2012 | Tagged , | 12 Comments

Microsoft Surface RT Review

Last Friday, pretty much on impulse, I decided to go to the Microsoft Store in the Park Meadows Mall in Lone Tree, Colorado at 8AM to see what kind of line they had for the new Microsoft Surface RT. This … Continue reading

Posted in Computer Hardware, Microsoft, Windows RT | Tagged , | 1 Comment

Understanding Server Hardware Course from Pluralsight

My first training course from Pluralsight, Understanding Server Hardware has just gone live. It is listed in the SQL Server section of the course catalog, even though it is not really SQL Server specific. It is meant as a foundational … Continue reading

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

Interview on RunAsRadio #281 with Richard Campbell

I recently had a chance to record a 33 minute podcast interview on RunAs Radio #281 with Richard Campbell, where I talked about the licensing changes in SQL Server 2012 and how to select your new hardware to minimize your … Continue reading

Posted in Computer Hardware, Haswell, Processors, Sandy Bridge, SQL Server 2012, Windows Server 2012 | Tagged , , | Leave a comment