June 2007 - Posts

• Understanding SQLIOSIM Output

  One of the things that’s great about my job is the fact that I get to meet people who are a lot smarter than me. One such person I count among my friends is Jimmy May, a Microsoftee from the Indianapolis area. Jimmy has been using SQLIOSIM for a while, Read More... Posted Thursday, June 28, 2007 11:30 AM by KKline | 4 Comments Filed under: Performance

• Final Revelations from the Recent TPC-H Benchmark

  I hope you’ve enjoyed my multipart write up on HP and Microsoft’s most recent TPC-H Benchmark disclosure report. I’m a huge proponent of benchmarking and of reading the vendor disclosure reports. So I hope I was able to convey the highlights from the Read More... Posted Monday, June 25, 2007 11:48 AM by KKline | 9 Comments Filed under: Performance

• Configuration Settings in the Recent TPC-H Benchmark

  One of the first places most people tend to think about when considering boosting SQL Server performance are the settings of SP_CONFIGURE. Yet, when you examine the details of the recent TPC-H benchmark by HP and Microsoft, you’ll see that there really Read More... Posted Thursday, June 21, 2007 5:43 PM by KKline | 3 Comments Filed under: Performance

• Startup Switches used in the Recent TPC-H Benchmark

  Some people take a rather cynical approach to benchmarking by considering them to be inaccurate representations of what the database platform and hardware can do. They’re cynical because the benchmarkers take every opportunity to give their system every Read More... Posted Wednesday, June 20, 2007 5:53 PM by KKline | 5 Comments Filed under: Performance

• Instant Revelations from the Recent TPC-H Benchmarks

  Kevin tells you about the instantly noticable "fudge factors" of the recent TPC-H test for SQL Server. Read More... Posted Tuesday, June 19, 2007 3:34 PM by KKline | 1 Comments Filed under: Performance

• Understanding the latest SQL Server TPC-H scores

  I recently read Brian Moran’s recent article on the latest Microsoft TPC scores ( http://www.sqlmag.com/articles/index.cfm?articleid=96147&puuid=420B5669-1279-9119-120E2F28B99E67C6 ) with great interest. I’m a benchmarking junky from way back in my Read More... Posted Monday, June 18, 2007 10:39 PM by KKline | 2 Comments Filed under: Performance

• Two Quest Products are now GA

  As you may know, I've been with Quest Software for several years now. I'm proud of our SQL Server products and had a hand in the development of most of them. Here are two new releases that I'd like to mention: Change Director for SQL Server v1.2 provides Read More... Posted Thursday, June 14, 2007 2:44 PM by KKline | 2 Comments Filed under: Quest Software

• Any readers live in or near Charlotte?

  Kevin tells you about his next two speaking events Read More... Posted Tuesday, June 12, 2007 11:18 PM by KKline | 1 Comments Filed under: Speaking

• Upcoming Top 10 Data Modeling Mistakes Webcast

  Hi Everyone, I'm delivering the first follow-on presentation to my popular "Top 10 Mistakes on SQL Server". This follow-on presentation focuses on the multitude of common mistakes I've encountered on database designs and during data modeling. Here are Read More... Posted Tuesday, June 05, 2007 7:03 AM by KKline | 0 Comments Filed under: Best Practices

• TechEd 2007 Day 1

  I'm working three days in the SQL Server lounge area - Tuesday mid-day, Wednesday morning, and Friday morning. I'm also delivering an all new version of my popular session "SQL Server Performance Benchmarking & Monitoring. The crowds are thick and Read More... Posted Monday, June 04, 2007 10:01 PM by KKline | 0 Comments Filed under: Releases