Use TPC Database Benchmarks to Save Money

Last month, I began a series of articles describing database application benchmarking. In the first article, I told you about different ways that you can construct your own database application benchmark. However, you don’t have to reinvent the wheel. The Transaction Processing Council (www.tpc.org) has already created a large number of database benchmarks that are extremely useful and informative. I also described last month how the TPC provides several different types of benchmark tests. For example the TPC-C and TPC-E benchmarks are extremely useful for measuring transaction throughput. … [Read more...]

Read the New TPC Database Benchmarking Series

Introduction to TPC Database Benchmarks Let's talk about database application benchmarking. This is a skill set which, in my opinion, is one of the major differentiators between a journeyman-level DBA and a true master of the trade. In this article published in my monthly column at Database Trends & Applications magazine, I'll give you a brief introduction to TPC benchmarks and, in future articles, I'll be telling you how to extract specific pieces of valuable information from the published benchmark results. But let's get started with an overview … read … [Read more...]

SQL Intersection!

The best emotion to describe how I'm feeling is 'astounded'.  I'm astounded that I'm in such august company to be speaking the SQLIntersection (#iSQL) conference.  Read the blog post from my first SQL Server mentor, Kimberly Tripp, which tells you all about SQLintersection. Check out this list of speakers: Aaron Bertrand, Sr. Consultant, SQL Sentry, Inc. [blog | twitter] Andrew J. Kelly, Mentor, SolidQ [blog | twitter] Bob Ward, Principal Architect Escalation Engineer, Microsoft [blog | twitter] Brent Ozar, Brent Ozar Unlimited [blog | twitter] Conor Cunningham, Principal … [Read more...]

Two New Slide Decks. Plus, the Week in Colorado.

I had the honor of traveling the great state of Colorado last week, speaking at the PASS chapters in Boulder, Colorado Springs, and Denver.  At all three events, we had a stellar attendance and, at least in Denver, broke all the records in recent memory both in terms of overall attendance and in first-timers.  Denver, in fact, was standing room only and had nearly 30 first time attendees.  Great news!  I also want to give a special shout-out of thanks and appreciation to Chris Shaw (Twitter | Blog) whose hard work and tenacity ensured that all of Colorado got to see me speak. From left to … [Read more...]

Build Your Own Microsoft Operations Manager Pack

Operations Manager Management Pack Development Kit I just recently told you about some cool new things happening with System Center - before I stumbled across this tidbit.  Hey, if I could, I'd go back in time and add this entry to the previous one --- yeah, and totally NOT play the stock market to make a fortune through time travel.  But I digress... So the Operations Management Management Pack Development Kit applies to Microsoft Operations Manager 2012 and Microsoft System Center Operations Manager 2007.  It provide the you with all of the info need to design and build a management pack … [Read more...]

Dev Advice: Make a Tiny Dev Database Act Like a HUGE Prod Database

Here's an evergreen question.  It's a question that never completely goes away.  But lately, I've been getting it a few times per week.  So I thought it's time to readdress the question, which usually takes some form of the following: I can't really do effective development on my little dev laptop because our production SQL Server database is 15 gazillionbytes, way too big for my workstation.  What's a uber-nerd to do?  Well, maybe they didn't use the word "uber-nerd".  But you get my drift, right?  The production database is really, really big - unmanageably big for keeping a local copy.  … [Read more...]

Accelerate OLTP with HP and Microsoft’s New High Performance Reference Architecture

If you haven't started to read Shashank Pawar (blog), you're missing out.  Shashank is part of Microsoft Australia and has been writing some very good content lately.  Here's an example from the Reference Architecture for High Performance SQL Server: HP and Microsoft engineering teams have worked together to create a reference architecture to Accelerate Online Transaction Processing (OLTP) database workloads with a fully-flash based HP/Microsoft architecture and achieve significant performance increases, simplified database manageability, and industry leading TCO. The details come in a … [Read more...]

Everybody Needs a Test Harness

When you're developing new Transact-SQL code or modifying some existing code, do you just launch directly into programming? I know that I did just that, for years.  It wasn't until I was trying to performance tune some existing code that I realized I hadn't actually taken caching of data and execution plans into account.  So all those modified stored procedures that I was so proud of might not actually be faster than the first generation of procedures because I hadn't checked to ensure that I was testing cached programs against uncached programs (and, by extension, the data used by those … [Read more...]

Microsoft Document Watch for Operational Excellence

Back when my day-to-day duties included database administration work and enterprise architecture, I became rather obsessed with the idea of operational excellence.  I read everything I could on the topic.  I made a list of favorites, which became somewhat shabby over time, as I dog-eared important pages and scribbled notes in the margins.  (Perhaps that list of favorites might, in and of itself, make a good blog post).  Fast-forward a decade and I'm still mightily interested in operational excellence for IT organizations.  It's just that so much good material is available for free on the … [Read more...]

Microsoft SQL Server Internals & Architecture Matter!

EPIC FAIL!  This was supposed to go out last week.  But I didn't schedule it properly, so I'd just like to point out that there are lots of other great webcasts to watch at the Pragmatic Works webcast URL below.  Plus, my session will be available via streaming by the end of the week.  And thanks the the 1600 folks who registered!   -=-=-=-   Come join me on Tuesday, August 2, 2011 11:00 AM - 12:00 PM EDT for a free webcast covering the internals and architecture of Microsoft SQL Server.  It's not everyday that a dry topic like this is presented in a fun and easy to … [Read more...]