Tag Archives: SQL Server Hardware

Behemoth of the Server Room?

Back during the PASS 2011 Summit in Seattle, I was interviewed by Tony Davis, Andrew Clark, and Rodney Landrum about hardware, storage subsystems and virtualization.  This was a fun little impromptu interview, filmed in a somewhat quiet location during the … Continue reading

Posted in Computer Hardware, PASS, Processors, SQL Server 2008 R2, SQL Server 2012, Storage Subsystems | Tagged , | Leave a comment

SQL Server Hardware Choices Made Easy

Redgate has released a free eBook that I wrote called SQL Server Hardware Choices Made Easy. This is basically a compilation of the month long series I wrote in April 2011, called A SQL Server Hardware Nugget A Day, along … Continue reading

Posted in Computer Hardware, Processors, Storage Subsystems | Tagged | 6 Comments

SQL Server Hardware Book News and Reviews

Today was an exciting day, since I discovered that fellow SQL Server MVP Brent Ozar (Blog|Twitter) had posted a very nice review of my book SQL Server Hardware. That means a lot to me, since I respect Brent, both as … Continue reading

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

A SQL Server Hardware Nugget A Day – Day 1

Well, I apparently did not learn my lesson last year, when I did a month long series called “A DMV a Day”, where I wrote a blog post every day during the month of April, since I am going to … Continue reading

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

SQL Server Workload Types and Hardware Selection

There are two primary relational workload types that SQL Server commonly has to deal with, the first being Online Transaction Processing (OLTP) and the second being Decision Support (DSS)/Data Warehouse (DW). OLTP workloads are characterized by numerous, short transactions, where … Continue reading

Posted in Computer Hardware | Tagged , | 4 Comments