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 ...

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, ...

Relational?!? Move On, Geezer!Maybe you're thinking that relational databases management systems (RDBMSs), like Microsoft SQL Server and Oracle, are going the way of punched cards and rotary phones.  After all, there's been a lot of hype these days in the IT media about the rise of so-called NoSQL (Not Only SQL) databases. ...

Check out the new white paper “Key Methods for Managing Complex DB Environments” at Quest.com. Heterogeneous database management hassles used to be much less common than today. When I first started at Quest nearly ten years ago, I'd put forward that on 15-20% of my big customers regularly managed more than one major database platform. (That ...

There are so many great tools out there for data professionals using Microsoft SQL Server.  I really like to see all of these great tools made free to the public.  On the other hand, I'm bummed that the tools are cast about in a very decentralized fashion. If you haven't done migrations before, you might want to start with these ...

Back in late May, my pal Buck Woody (blog | twitter) and I presented SQL Server for the Oracle DBA.  Buck played Jerry Lewis' role, while I played the straight man a la Dean Martin.  You can see the recording and slide deck here.  Since both Buck and I spent a considerable number of years working on Oracle, we felt like we had ...