Benchmarking I/O: The test rig

Work has been a little crazy lately, but I’ve still been wanting to do some I/O performance testing since we’re due to get some new servers in soon and I wanted to be able to compare apples with oranges. So this past weekend I decided to combine something I’ve been …

Look where you want to go

I ride a motorbike to and from work every day. I thoroughly enjoy getting out on my Suzuki whenever possible – in fact I no longer even own a car. So obviously it was only a matter of time before I tried to wrangle in some kind of tenuous link …

Generate scripts to detach/attach all databases

I haven’t had time to do any Denali testing since my last post, so instead I thought I’d share a script I wrote a while ago which simply generates a script to attach one or more databases using their current file paths (and optionally then detaches these databases). The reason …

Do you want a job? Then don’t do this…

We’re always looking for good “database folk” (i.e. DBA’s or database developers).  Its fair to say that the pickings have been pretty slim for some time now, but we still get a constant trickle of applications that make me want to laugh (and sometimes cry). Here are a few “pain-points” …