and I was hunched over my trusty, battered Macbook Pro, sipping whiskey by the backlit keys when the email came in. I got worried as soon I saw the sender, because Big Jimmy May is what they call a “Performance Consultant”. Before I even opened the email, I called my bookie to make sure my checks had all cleared. I’ve only got two kneecaps, and they’re already bad enough just from poundin’ the street looking for info. Thankfully, I was in the clear, so I read the email.
Jimmy said a fella by the name of Christian Bolton was knocking on doors looking for help with a particularly nasty job: exposing the dark, hidden secrets of SQL Server engine internals. To make matters worse, Christian wanted to combine two of my least favorite words: trouble and shooting. Jimmy would have taken the case himself, but he had a job he had to handle in Turkey, and you know how those Turkish jobs go.
Next thing you know, there’s a contract going around out there with my name on it – not to mention things like deadlines. It’s a dirty business, I tell you.
The book authoring process stands in stark contrast to my normal blog entry process: instead of banging out a few ill-advised (but often spell-checked) paragraphs in half an hour and posting it for the world to see, I have technical editors and technical reviewers. They’re like blog commenters, only they have the authority to modify my work BEFORE you see it instead of AFTER. And of course, to see that work, you’re going to have to fork out some moolah.
I’m writing two chapters, covering storage and on the Performance Dashboard Reports, and I wanted to ask you, dear reader – what would you want to see in a Storage chapter? Rather than showing 35 full-page diagrams of the Container Store’s goodies, I figured I’d cover these topics:
Types of Storage
There’s several types of storage that affect the way we make architecture decisions and perform troubleshooting. I’ll cover the basics of each and what their ramifications are:
- Locally Attached Storage
- Storage Area Networks (and touch on multipathing)
- Virtual Servers (how VMware and Hyper-V change storage designs)
- Project Madison (scale-out, shared-nothing nodes)
- Using SQLIO to test storage throughput
Things that Change Storage
- Transparent Data Encryption
- Partitioning (of objects like tables & indexes, not disk partitions)
- Partition Alignment (that’s where the disk stuff comes in)
What We Store
- Full Text Indexes
Any requests? I still have to arrange this stuff in a way that flows, and don’t be surprised if I left off something huge. I came up with this list on a cruise ship, people. Just be glad it doesn’t include “margarita on the rocks” or “cigars”.
Don’t look for a fast turnaround – the book won’t be out until early 2010. Like I said, this is a lot different than publishing a blog entry! Along the way, I’ll be blogging about the process so you can get an inside peek at how it works – things like the contract, my brilliant coauthors, the writing, the reviewers & editors, and so on. That way, when you see it on the shelves of your local bookseller, you’ll be able to explain to the proprietor exactly why they should burn it.
So if you’ll excuse me, I need to go buy my bookie a Christmas present. Now that I know Jimmy May has my email address, I can’t be too careful.