Monthly Archives: January 2010

What’s In Your Bug-Out Bag?

In my free webcast on disaster recovery planning for small businesses, I talked about building a bug-out bag.

My Bug-Out Bag

My Bug-Out Bag

Every IT professional should have a bug-out bag in the trunk of their car with enough stuff to let them hit the road for 24-48 hours straight.  This gear helps you react more confidently to minor problems and major disasters.  Here’s what I’ve got in my bug-out bag:

A polyester polo shirt. Hardly the pinnacle of fashion, but polyester can be rolled up for months at a time without holding permanent wrinkles.  If I spill something all over the front of my shirt right before I need to be seen in public, this gives me a little bit of an insurance policy.

A couple of old t-shirts. These can serve as apparel or rags, whatever’s needed at the moment.

Swimsuit trunks. Because sometimes an opportunity for sailing or swimming just presents itself, and I’m not too fond of skinny dipping.

A power inverter. Plug this into your cigarette lighter, and you can power a couple of electric outlets for things like laptops, cell phone chargers or a coffee bean grinder.  (Yep – I used that after a hurricane.  Forgot to grind beans ahead of time for my Bialetti Moka coffeemaker that runs off a gas stove.)

Jumper cables with instructions. Every now and then somebody’s car needs a jump-start, and I never remember how these are supposed to clip on. I’ve tried the kind that plug in via cigarette lighters and had miserable luck.

A pocket road atlas. In my disaster recovery webcast, I explain that you might not be able to rely on the internet connection in your fancypants phone.  This little pocket atlas helps me find routes around problems.

A padlock. I move around a lot, and every now and then I need to lock up a U-Haul truck or a storage unit.

Some tools, including an adjustable wrench, needle-nose pliers, and a screwdriver kit with socket fittings.  I’m not handy by any means, but I can lend these tools to someone who can actually fix something.

A self-powered radio/flashlight/charger. I bought this Eton FR150 for $30 last year, and it’s a slick little device.  It’s a small weather radio that also doubles as a cell phone charger, and it’s powered via hand cranking or solar cells.  The manual says that 15 minutes of cranking equals around 1 minute of talk time, and I hope I never have to find out.  It’s easy to crank, and the weather radio works great.

I’ve also got a few more things that aren’t pictured:

  • Bottles of water
  • A box of energy bars
  • A pair of old blue jeans
  • A pair of sandals (good for boating or hiking)
  • Phone charger and cables (I keep those in the glove box)
  • Copies of my insurance paperwork

In the webcast, I also explain other things database administrators should keep in their bag, like install CDs, license keys, and contact lists.  I’m lucky enough not to have to support any production applications at the moment.

You can build a bag just like this for under $50 using things you’ve already got around the house.  They’ll do you much more good in your car trunk.  Hurricane season is coming again this year – why haven’t you built a bug-out bag yet?

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

Website - Twitter - Facebook - More Posts

LiveMeeting Presentation Tutorial

Want to give a presentation over the web with Microsoft LiveMeeting? It’s quick and easy, and with my tips in this six-minute video, you can give a high-quality presentation that attendees will enjoy.

This internet presentation tool is used by PASS chapters – both local and virtual – and Microsoft MVPs get a free LiveMeeting presentation account.

Once you know how to use LiveMeeting, let PASS chapter leaders know that you’re ready, willing, and able to speak remotely.  This helps them out when in-person speakers drop out at the last minute, because you can step in and save the day.  I also have a page in my blog where I list my ready-to-go presentation topics so that chapter leaders can just pick a topic and hit the ground running.

Want more LiveMeeting tips?  Jeremiah Peschka wrote a post with LiveMeeting tips and tricks.

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

Website - Twitter - Facebook - More Posts

SQL Azure Frequently Asked Questions

On Monday 2/1, SQL Azure goes commercially live.  Microsoft’s charging for service now, and that means it’s officially official.

I talk to a lot of enterprise DBAs, project managers, and developers about SQL Server in the cloud.  Here’s some of the questions I get asked most often.

What is SQL Azure?

SQL Azure is Microsoft’s solution for SQL Server in the cloud.  It has a few key differences from traditional SQL Server:

  • Database maximum size is 1GB or 10GB based on your price plan, but no larger
  • You can have as many databases as you want, but they may not be on the same server
  • There’s no cross-database querying
  • There’s no SQL Azure encryption
  • It supports a subset of SQL Server’s T-SQL commands, but not all of them
  • It supports a subset of SQL Server’s datatypes, but not all of them

I like to think of it as SQL Server Lite – it’s an excellent stepping stone to the real thing.  Build your app from the ground up for SQL Azure, and it’s pretty easy to support full-blown SQL Server down the road if your needs change.

How does SQL Azure pricing compare to SQL Server costs?

Azure is a lot cheaper if you only need one database – $10/month for 1gb of data, and $100/month for 10gb of data. Pricing is per database, not per application – you can write multiple applications to query the same database.  Price is only one part of the equation, though.

The more databases you need, or the larger databases you need, the more it makes sense to have your own SQL Server.  Generally speaking, I tell companies that if you have any of these requirements, SQL Azure probably isn’t for you:

  • More than one department that needs to store data in SQL Server permanently
  • You don’t have at least 2 very senior-level programmers who understand the concept of sharding
  • You face security concerns involving HIPAA, SOX, or PCI compliance
  • You’ve already built a schema and/or an application

I’m not saying you can’t meet those needs with SQL Azure, but generally speaking, you’re not the target market for Azure v1.0.  On the other hand, if you have the following requirements, Azure might be a very good fit for you:

  • No full-time IT staff, no DBAs
  • No datacenter (or maybe not even an office)
  • No (or very, very little) legacy code, and you’re building a new app from scratch
  • You don’t mind putting in extra man-hours in the beginning to avoid capital investments

In that situation, Azure might make good sense, but you’re going to have to plan your way around Azure’s limitations.

Why does SQL Azure have a 10GB limit?

I can’t speak for Microsoft, but it would make sense to put a small database size limit to make sure queries run fast.  If you’ve got a 10GB database, it’s easy to make sure every query runs blazing fast.  Throw hardware at the problem, throw a lot of indexes at it, and you’ll get good performance.  Keeping things small also makes backup & recovery easier, and makes high availability design easier.

There are no SQL Azure RAM limits or CPU limits.  You have no control over how much CPU power or memory your database gets.  SQL Server 2008 has a Resource Governor that allows database administrators to throttle queries based on login or database, but Azure doesn’t support those features.

How can I load balance SQL Azure or do cross-database joins?

Since SQL Azure databases max out at 10GB, it would be great if we could create several databases on the same server and use a view to select from all of them.  No dice – that’s not supported.  As of February 2010, your application has to know which databases to query.  If you need to combine results from multiple databases, you’ll need to do that processing inside the application by querying all of the databases and then joining the results together in the app.

Scaling SQL Azure this way is called sharding – partitioning your data into different shards, each stored in a different database (or even different servers.)  Design your app like this, and it will scale like crazy.  If you’re the kind of coder who loves reading the stories on HighScalability.com, you’ll love sharding.  If you’ve never heard of HighScalability.com, you don’t want to architect your own sharded database – bring in somebody who lives this stuff.

How do I handle the SQL Azure backup process?

Unfortunately, right now, you have to build one yourself.  SQL Azure does not support the BACKUP command.  You’ll need to figure out how to sync your data out to an external database, and while you’re doing that design, keep in mind that you pay Microsoft for data transfers in & out of SQL Azure.

Microsoft states that Azure is highly available and contains its own backups across multiple servers.  However, just as RAID is not a backup, high availability is not a backup either.  You need backups if you want protection from any of these scenarios:

BSOD-T

BSOD-T - get yours today!

  • Your app might accidentally delete or modify data
  • Your users might accidentally delete or modify data
  • A hacker might purposely delete or modify data
  • Or believe it or not, Microsoft services just might go down.

Remember, folks, as much as I love Microsoft, we’re talking about the company that brought you the Blue Screen of Death.  You would be irresponsible not to back up your data for your own protection.  (T-shirt available for around $25, and if you want different colors or shirts, click the Customize button after the link.)

How good is SQL Azure performance?

The biggest SQL Azure bottleneck is your bandwidth, because all Azure queries go from your application to Microsoft’s servers and back.  Azure developers report that they’re very satisfied with the query speed, and usually report that it’s faster than servers they’ve built themselves.

The problem will arise when you’re not satisfied with SQL Azure’s performance.  You’ll want to ask these questions:

  • What else is querying my database right now?
  • What does my query execution plan look like?
  • What indexes could I add to make this query run faster?
  • Is another Azure database hammering the server right now?

Unfortunately, SQL Azure doesn’t support any commands, dynamic management views (DMVs), or functions that will help you answer those questions.

Can I use SQL Azure as a backup with log shipping or database mirroring?

No.

Don’t think of SQL Azure as your disaster recovery solution – it doesn’t work that way.  If you design your database for sharding, then you can work out a method to sync between Azure and full-blown SQL Server, but right now you’re very much inventing the wheel.  Your next question would be how to run Azure inside your own datacenter so that you could keep an identical environment between production (Azure) and disaster recovery (your place.)

How do I run Microsoft SQL Azure on commodity hardware?

You can’t run SQL Azure in-house on your own hardware.  It only runs in Microsoft’s datacenters.  If you want to develop against Azure but you don’t want to pay for Azure, you have two options.

Option #1 is to buy SQL Server Developer Edition for under $50.  It’s functionally equivalent to SQL Server Enterprise Edition, but the license prohibits using it in production.  You’ll have to restrict yourself to only using the Azure-level features, though – if you accidentally design your schema to use, say, full text search, it’ll work fine on Developer Edition, but it won’t work in Azure.

Option #2 is to get an MSDN subscription with Azure benefits.

What SQL Azure plans do MSDN subscribers get for free?

It depends on your level of MSDN/Visual Studio:

That pricing is retail pricing, and volume license users get Visual Studio & MSDN cheaper.  Obviously you wouldn’t buy an MSDN subscription just to get $360 worth of SQL Azure databases ($30 * 12 = $360) but it’s part of the picture.  MSDN subscriptions also come with other Azure benefits too, and those Azure benefits stay live as long as you maintain your MSDN subscription.

Got a SQL Azure question I didn’t answer?

Leave it in the comments and I’ll track down the information for you.

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

Website - Twitter - Facebook - More Posts

Upcoming Free Training Events

It’s a new year and a new budget, but your boss is still cheap, right?  Ain’t that somethin’?  Well, good news – got more free SQL Server training events coming at ya.

January 28 Pain of the Week Webcast:
“But It Worked On My Machine!”

Ari Weil and I will show you how to catch bad code and how to prove to your developers why it won’t scale up to production loads. Find out how to recognize common mistakes before they go into production, such as:

  • Scalar UDFs that process too much data
  • Oversized fields
  • Over-reliance on TempDB

Register now for this completely free one-hour LiveMeeting.

February 2 – West Chicago PASS
Perfmon and Profiler 101

These two tools are the key to successful performance tuning. I’ll show you how to get started with these tools, how to slice and dice the results, and even how to data mine the results to look for interesting trends. Whether you like to monitor performance with native tools or third party utilities, knowing how the native tools work will help you get better results out of your tools.

Attendees will learn:

  • Why Perfmon is like a Nissan GT-R’s dashboard
  • What Perfmon counters to measure, and what they mean
  • Four common performance symptoms and how to cure the problems

This will be the inaugural meeting of the new West Chicago chapter, and I’ll be giving away a couple of signed copies of our new book to celebrate! The meeting will be held at 6pm in the Microsoft offices at 3025 Highland Parkway, Suite 300, Downers Grove, IL, 60515. Yes, I used Google Maps for the link, not Bing, because Google Maps has integration with the Chicago Transit Authority so you can get directions via public transit.

If you want to come, email Kim Young to get your name on the list. Pizza starts at 6, and then my presentation starts at 6:30.

February 9 – PASS Virtualization Virtual Chapter
SQL Meets Virtual CPUs, Memory, and Storage

SQL Server can run great in virtual environments like Microsoft Hyper-V and VMware vSphere, but you can dramatically increase the odds of success if you know which knobs to tweak.  Just like SQL Server, virtualization software doesn’t always work best with the default settings, and knowing which settings change SQL Server performance is key.  In this session, I will explain:

Attendees will learn:

  • Why virtual CPUs, memory, and storage are different
  • Hidden gotchas that often hurt virtual performance
  • How to stress test your virtual server to find limits

To attend, go to Virtualization.SQLPass.org and click Register at the top right.  We’ll email the LiveMeeting coordinates to all registered members before the meeting.

March 3rd: All-Day Free Virtual Event
Performance Tuning & Troubleshooting with DMVs

We’re doing an all-day live virtual conference on how to use dynamic management views (DMVs) to do SQL Server performance tuning and troubleshooting. The whole thing will be broadcast live in 720p, and we’ll be taking questions via chat and Twitter. We’re going to have sessions at the beginner, intermediate, and advanced levels taught by:

  • Kevin Kline (BlogTwitter) – Microsoft MVP since 2004, author of SQL in a Nutshell, founding board member of the Professional Association for SQL Server, and all around good guy.
  • Ari Weil (BlogTwitter) – Product Manager for Quest’s performance products, and knows way more about waits, performance tuning, and SQL Server architecture than anybody should.
  • Brent Ozar (BlogTwitter) – your humble author. Okay, well, author anyway.

Register now and just for registering, you’ll be entered into a contest for free goodies!

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

Website - Twitter - Facebook - More Posts

Book Week: The Politics of Writing Books

This week, I’ve talked about the economics of writing books, interviewed Robin Goldstein about The Wine Trials, and interviewed Tom LaRock about his upcoming book.  This week I’m finishing off the series with my thoughts about the mental costs involved in writing a book.

First Things First

When my book contract with Wiley/WROX was initially drawn up, I devoured every line of it.  I’ve been in business long enough to know that every line of a contract exists for a reason; somebody got burned once, and they want to make sure it doesn’t happen again.

The Usual Suspects

The Usual Suspects

One of the lines specified the order of the authors on the cover of the book.  To put them in a SQL statement:

SELECT LastName, FirstName
FROM dbo.Authors
ORDER BY QtyChapters DESC, LastName, FirstName

A little light bulb went off in my head.  You know those WROX books that look like a police lineup with half a dozen head shots?  (Don’t even get me started on the bad Photoshop jobs where they’re all shadowed from different directions and their head sizes don’t match up.)  Suddenly I realized that the guys who were listed first were the ones who contributed the most.  I went through all of the books on my bookshelf to find out who the workhorses were.

Later on during the revision process, the contract had to be revised a couple of times.  Authors’ schedules changed, and people who initially signed on for multiple chapters weren’t able to get the work done.  Life happens. Did you know that not everybody who writes content actually makes the author list?  In our book, only the people who’d written 2 or more chapters were called “authors.”  Cindy Gross and Jonathan Kehayias also contributed chapters, but they’re not on the cover.

During the contract changes, though, I noticed that my name sank down the list inappropriately – I was suddenly listed later than I was supposed to be.  I asked the publisher why, and they said they’d simply copy/pasted names in without regard to the exact order.

I said okay, you’re fixing that, right?

They said no.

At first I thought there was a misunderstanding, but after raising the issue a couple of times, I hit the roof.  This is the content business, after all – if an author made a mistake and copy/pasted something in wrong, and someone else found it, the author would be expected to fix it.  Why wouldn’t the publisher be held to the same standard?  I felt like a bitchy diva for putting my foot down, but I did, and I was prepared to abandon the whole project if the publisher wouldn’t get this detail right.  I didn’t care whether I was going up or down in the list order – I just wanted the order to be accurate.  They ended up fixing it, but as it turned out, this mattered a little less because WROX changed the way it did book covers.

Judging a Book by its Cover

WROX’s covers were among the most recognizable ones on bookstore shelves.  O’Reilly had its animal drawings, WROX had the police lineup of authors, For Dummies was yellow and black, and everybody else was kind of a jumble.  When I saw the author photos on the cover, I knew I was buying something from someone who was really proud of the work they’d done.  They didn’t just put their name on it, they put their picture on it.  Those guys must be real pros.

You Missed The Bus

You Missed The Bus

Midway through the writing process, we got word that WROX decided to dump author photos from book covers.  I was shocked, but now that I work in marketing myself, I figured there was probably a really good decision process behind the scenes.  The more questions I asked, though, the less satisfied I was.  Part of WROX’s rationale was that the author photos were scaring off readers.  Rather than investing a little money in getting good author photos, WROX threw the baby out with the bathwater.

Authors don’t make much of any money writing books, and the authors I talked to all gave the same reason for writing: they wanted the exposure.  Exposure to more readers meant more consulting opportunities and a higher billable rate.  Taking the photo off the cover meant less exposure to readers.

WROX’s choice of sample covers certainly didn’t help their cause.  The cover of Professional XHTML, CSS and JavaScript had a guy running for a bus.  The message: readers missed the bus, which is slang for being too late to catch an opportunity.  It could have been worse, I suppose – the bus could be driving over the guy.  The cover for Beginning Active Server Pages featured a worn-out wheel that wasn’t properly painted and looked dangerous to touch, as if you’d get splinters of paint on your hands.  Everything about this whole thing screamed, “CHEAP STOCK PHOTOS!”

Professional C#

Professional C#

Professional XMPP

Professional XMPP

Of course, when I saw our book’s cover, a race car, I was instantly placated.  That was just epic win.  I needed to let the graphics and marketing folks do what they do best, and focus my own efforts on my job – writing content.

How Publishers Reduce Your Workload

I used to think that writing a book meant locking yourself in a room, banging out hundreds of pages of quality content, and then hitting Print.  I thought authors had complete and total control of their content, and that the content on the page was a brain dump directly from the author.  They had amazing technical accuracy and great command of English grammar, and they were handy with Visio to boot.

My first shock came when Christian Bolton (the head author) told me not to put too much time into the illustrations.  Just get the basic idea down in Visio or whatever, and then the technical illustrator would come behind us and redo all the diagrams.

Wha? Seriously?  Did Christmas come early?

I wish I would have had a webcam on when I read that email, because I bet my expression was just like when I used to find money under the pillow from the Tooth Fairy.  I was giddy with excitement.  When you’re pouring your heart out into writing a book, and you’re under a time deadline to get your content finished, every hour you can save is a really big deal.  The quality of the finished illustrations was icing on the cake – I would have been fine with amateurish stick figures drawn with crayons on a napkin (“Here’s Mr. Raid!”) but these were great.

Working with a publisher means that a lot of people are involved in your book.  Every additional person involved means less work for you, but at the same time, you lose a degree of control.  The best example of this is your editors and technical reviewers.

How Publishers Increase Your Workload

After each chapter is done and you send it to your publisher, they forward it to a team of editors.  Some editors focus on your grammar, and other editors (usually your peers) focus on your technical content.  They don’t just read it and nod – they dive in and criticize it.  You get back a Word doc with lots of comments in the margins.  The editorial grammar comments are pretty easy to take, because most of us know we suck at grammar, but….

I need to take a second here and talk about the interpersonal skills of IT people.  We didn’t get into this field because we’re really good at interacting with people – we got here because we’re good at making machines jump through hoops.  We have a reputation for talking to people the same way we talk to machines: raw commands in all caps.  There is no “PRETTY PLEASE” modifier in T-SQL or C#.  As a result, the editorial comments I got back were frustrating.  I took the criticisms personally, and I found myself hollering at the screen.  Almost everything in the authoring process is a matter of opinion, and we had a lot of differences of opinion.

For example, because solid state drives are becoming more popular, I went to great lengths to call the other ones “magnetic hard drives.”  I know that term isn’t used commonly in IT because the vast, vast majority of drives today are magnetic, but I wasn’t just writing for today – I was writing a book that I hoped would sit on the shelf for years to come.  Right now, people are still buying ten-year-old SQL Server 2000 books.  In the year 2019, if someone picks up my book, the storage market is going to be dramatically different, and I wanted to plan for that.

Every time I got back a marked-up chapter, I cringed, because other people were revising my work, changing my vision.  Don’t get me wrong, most of the time they were great critiques, but I still found myself taking a lot of the remarks personally – especially when they were phrased in the brusque language of IT workers.  The upshot is that the finished product is of much higher quality than the first draft I turned in.  Editors and technical reviewers really made a difference, but authors need to be aware that they cause you more work.

All This Help Has Costs

Editors fix your grammar.  Technical reviewers hone your content.  Additional authors help you finish the book faster.  Graphic artists add pictures worth thousands of words.  Publicists send copies of your book to bloggers and magazines.  Lawyers make sure everybody – okay, well the publisher – is protected.  Reps make sure everything happens on schedule, or as close to schedule as possible.

In my post about the economics of writing a book, I explained that this stuff costs money, but today I want to emphasize that it has a mental cost too.

When you write a book for a publisher, you’re a part of a big production.  You’re a big part, but you’re not the only part, and you’re going to have to interact with a lot of people in order to make it go smoothly.  You’re going to have to negotiate and motivate other people, and you’re going to have to do it in your spare time – times when you might rather be hanging out with your friends, relaxing with your family, or just sleeping.  From the time I signed the contract for my book until the day the publisher told me my chapters were done, I felt horribly guilty when I did anything other than work on the book.

In theory, self-publishing reduces these mental costs because you’re the only one setting the schedule and making demands.  If you decide to relax and postpone everything for a month, nobody’s going to tap you on the virtual shoulder asking how things are coming.  The downside, though, is that your workload multiplies, and you’re even less motivated to finish it.

If you’re thinking about getting into the book business, I’d highly recommend working with a publisher for your first project.

More Thoughts About How to Get Published

Some of my posts include:

Here’s a few posts by published authors that you’ll like:

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

Website - Twitter - Facebook - More Posts

Book Week: Interviewing Tom LaRock on Writing

This week I’m focusing on books – writing, publishing, and marketing.  So far I’ve covered how to make (or lose) money writing a book and how the Wine Trials might work as a business model, and today I’m talking to a first-time author.  Enjoy!

Tom LaRockStar

Tom LaRockStar

Tom LaRock needs no introduction, but you know that when you hear that phrase, someone’s going to do an introduction anyway, and here it comes.  There’s a handful of ways you might know Tom:

And soon, you’ll know him as the author of DBA Survivor: How to Become a Rock Star DBA.  I interviewed Tom to find out why he was writing the book, who it was meant for, and how the business of publishing was working for him.

Brent: After I told you that writing a book felt like punching yourself in the junk, I see that you’ve decided to write a book.  What exactly was behind that thought process?

Tom: First, no one has ever accused me of thinking. Second, I misunderstood, I thought you said it was like pinching yourself a hunk of bacon. Naturally I was excited by that idea. And why would it matter if my writing a book made you punch yourself? it’s not like I would feel anything, right?

Brent: So what’s the book about?

Tom: About how you can survive your life as a DBA. I wrote it with the idea that it should help someone perform their job as a DBA more effectively.

Brent: Who’s the target audience?  When you think about the person on the other side of the page, what are they like?

Tom: It is intended for people who are considering a career as a DBA, or for people who have suddenly found themselves as the DBA. I often hear of these people called “accidental” or “involuntary” DBA’s. I was one of those same people and I set out to write the book that I wish someone would have written for me when I was getting started.

Brent: If someone takes away one thing from the book, what do you want it to be?

Tom: That you can’t do it all yourself. No DBA is an island, you need help from time to time.

Brent: I’d say the same thing about authors, too.  Before I got involved with a book, I had this preconceived notion that an author sat down by himself in front of a word processor, banged out hundreds of pages, then hit print, and it appeared in bookstores everywhere.  Who are some of the people involved in your book, and how are they helping?

Tom: Well, APress provides me with three or four people working on various aspects of editing. And I also have three or four technical reviewers, along with two or three other people that have reviewed at least a chapter or two at my request. Somewhere there is someone putting together a front cover for the book as well. I put the unofficial count at about eight, but it could be a dozen or more people that will help put this all together.

Brent: How did you go about getting a book contract?  What was the pitching experience like?

Tom: I was originally approached to write a book on Operations Manager for the DBA. I put together a rough outline and submitted a proposal, but after some discussion it was not accepted. I recall the relief I felt because it meant that I wouldn’t be punching myself in the junk for the next six months. I sent an email to the editor and explained my relief to him and how if I ever did write a book it would be on something more geared towards professional development.  His response was, “Why don’t you just write the book you want to write? Submit a proposal and your outline and let’s see where it goes.” So I did, and here we are.

Brent: WHAT?!? You know more about Operations Manager than anybody else I know.  Isn’t it enough to know your subject matter start to finish?  What are some of the reasons a book might not get accepted by a publisher?

Tom: Well, lots of people are subject matter experts but are not able to communicate their thoughts in a clear enough way, so I would say that knowing something inside and out is not enough to write a book. You need more than just the knowledge; you need to transfer that knowledge to others in some way, either by yourself or a proxy.

One reason your book may not get accepted is a simple one: money. No publisher is going to publish a book that they do not believe is going to make them a profit in some way. If you think about the target market for a book on Operations Manager 2007 for Database Administrators, then compare that to the number of ‘accidental’ DBA’s, you can see that there is a greater chance of selling more books to the latter than the former. In my opinion, best sellers are simply good books that appeal to the largest possible audience. Other reasons it may not get accepted would be that perhaps the publisher isn’t familiar enough with your ideas or concepts. I doubt APress does romance novels, for example, so they would probably reject such a proposal.

Brent: How is writing a book different from writing, say, a lot of blog entries?

Tom: Well, it takes longer, it is more organized, and you have people reviewing your words and offering suggestions. And at no point in this process did I ever feel I was being told to punch harder. I think all of your talk about how difficult it was for you made me have the mindset that writing a book was going to be very difficult. So, i went in with a certain expectation. I think other people, like yourself, go into the process with blinders on, have a different set of expectations, and are let down in the end. Watching you punch yourself for weeks on end was great for me.

I also noticed just how happy you are now that it is over. that’s how I feel when I get done with a run. I hate dragging my ass all over town for miles on end, but I love the feeling I get when it is over and done with.

Brent: Wow, I never thought of it that way.  Writing a book is a lot like running a marathon – there’s a long buildup and there’s really only gratification at the very end.  Writing blog posts is like sprints – the gratification comes more often in the process.  When I trained for a marathon, I learned a lot about myself, and I’ll stick with shorter runs!  You’ve finished the 26.2 mile monster, though, and you’re already training for your next one, right?  What about your personality makes you well-suited for marathons and book writing?

Tom: Yes, I have a guaranteed entry to the 2010 NYC Marathon, and I have already started building a base so that I can get a jump on my training when it officially starts in April. The program runs for roughly 20 weeks, so you find yourself running for about five months before race day. I’ll probably do well over 700 miles on the road this year, if all goes well. I am also hoping to do the Hartford Marathon as a tune-up for NY, as Hartford takes place three weeks before New York.

No matter what you choose to do in life, running, writing, whatever it may be, you need to have some level of self-discipline. You need to be somewhat organized, have an action plan of sorts, and be determined to follow things through to completion. Many people have all of those same traits, but they manifest themselves in different ways. Think about people who admire cars. They always seem to know all sorts of minutiae about various makes and models of cars. That ability takes passion, and time, and self-discipline. Me? I can’t tell you the make of a car on the highway without seeing the brand logo. But I can tell you six different inbounds plays to run against a zone defense, why the sideline break is the hardest to defend, and where the best spots on the floor are for offensive rebounds. Everyone has a different passion, a different focus, and applies their self-discipline in a different way.

Brent: What have you learned in the process of writing the book – about yourself, and about the process of becoming a DBA?

Tom: I learned that writing is a full time job. These days, if I don’t set aside enough time to write something, and write it well, I almost don’t bother getting it started. I used to just write stuff down and hit ‘publish’. Not anymore. Now I outline my thoughts, try to write complete sentences, and give myself time to get it done correctly. The book made me understand the difference between getting something done, and doing something well. I also learned that I made a lot of mistakes as a new DBA. Technical mistakes, no question, but also mistakes in how I communicated with others. You know, the ‘soft skills’ that everyone needs to improve upon? I think I am a lot better now than when I started, but some days it is hard to tell if the Universe is just sending bad karma back my way or if I am still doing a poor job of communicating with my peers.

Brent: Why did you start a web site about the book, and what do you plan to put on there?

Tom: I started DBA Survivor.com about six weeks ago. I plan to put links there for people to order the book, as well as some excerpts from the book. I was also thinking about doing some interviews with other DBA’s where I ask them some questions about what it was like for them when they first started. Over time I hope that I can use the site in order to help others along, almost like a coach. In fact, I have often thought about how cool it would be at some point if I was known as the DBA Coach, and people just called me Coach when they see me at PASS.

I’d like to thank Coach for taking the time to answer my questions.  In my next Book Week post, I’ll be talking about the mental costs and politics involved with the writing process.

Continue to the Politics of Writing Books

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

Website - Twitter - Facebook - More Posts

SQL Server TV Show Contest Winner

I ran a contest recently asking you for SQL Server TV show ideas.  The winner would get an autographed copy of our new book, Professional SQL Server 2008 Internals and Troubleshooting.  My shipment of books finally came in from Wiley, and it’s time to give one away!

SQL Server Swag

SQL Server Swag

My favorites, in chronological order of submission:

* Trek Next Generation – Jen McCown (BlogTwitter)

Pilot: Encounter at Checkpoint

In the first 21st Century Star Trek, we meet Captain Ben-Gan Picard, commander of the Microsoft flagship SQLEnterprise. En route to the distant Checkpoint Station, the SQLEnterprise is made to wait by the all-powerful, capricious being Queue, who judges the SQLEnterprise crew of DBAs as unworthy. Queue stops our heroes from continuing its five year mission to seek out new data and new quantifications, until they first pass a performance test. Once they arrive at Checkpoint Station, the away team – led by the Captain’s #1, Commander William P. Randall – find the city mysteriously filled to capacity.

Make your own Commander Data jokes here.

Whose Line of Code Is It Anyway? – Tim Ford (BlogTwitter)

Where Developers blame each other for bad coding after being caught by the DBA. Or where they write code on the fly with suggestions from the audience while wearing funny hats and not using their own hands.

The DB-A-Team – Bob Pusateri (Twitter)

After being sentenced to deal with abysmal code and uncooperative developers, they promptly escaped from a maximum security datacenter and survive as DBAs of fortune…

“I love it when a query plan comes together!”

The Brad Shulz Network (Blog)

Brad put together an entire lineup, complete with:

  • Little House on the Query
  • America’s Next Top Model Database
  • Null House
  • The Outer Join Limits
  • Buffer the Vampire Slayer

And the Winner Is….

I’m so totally going to get accused of favoritism after she won the SQLServerPedia Dream Trip to PASS last year and now this, but you gotta give it up for Jen McCown’s * Trek pilot!  I kept giggling at the thought of Queue.  Jen will be getting a signed copy of Professional SQL Server 2008 Internals and Troubleshooting.  Congratulations!

I’ll be running more contests here and over at SQLServerTroubleshooting.com over the next few weeks to give away the rest.  Good luck!

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

Website - Twitter - Facebook - More Posts

SQL Server 2008 R2 Release Date: May 2010

The Data Platform Insider just broke the news:

“Today, SQL Server 2008 R2 received an official release date. It will be listed on Microsoft’s May price list, and will be available by May 2010.”

You can read the full press release on the DPI blog, and read carefully.  It notes that customers with Software Assurance can upgrade to R2 at no charge.  However, if you didn’t buy Software Assurance along with your SQL Server licenses, R2 is not a free upgrade.

For more about SQL Server 2008 R2, check my articles and videos:

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

Website - Twitter - Facebook - More Posts

Book Week: The Wine Trials 2010 Review

The Wino and The Wine Trials

The Wino and The Wine Trials

When I reviewed the first edition of The Wine Trials, I called it “a wine book for donut lovers,” saying:

“I don’t have a very sophisticated palate (mmm, donuts) and I gotta think there are some wines that basically taste good to everybody – like, well, donuts.  You don’t need a sophisticated palate to like donuts – you just like ‘em…. So how do we find wines that are the equivalent of donuts – beverages with a wide, almost universal appeal and reasonable donut-style pricetags?”

This year’s updated edition of The Wine Trials has 150 wines under $15, all selected by brown-bag blind tastings done by real people, not wine critics.  I’m suspicious of full-time wine critics because I can’t shake the hunch that they’re getting paid off by wine companies in order to write favorable reviews.  The fact that Parker’s Wine Guide lists two totally different reviews for the same wine didn’t help the cause of pro critics.

If you’re like me – an amateur foodie, by no means a pro – you might think you could reuse the same Wine Trials book for several years in a row.  Not so fast: wines change quite a bit from season to season, even blended wines like the ones that often fall into this bargain price category.  Out of the 100 wines listed in last year’s Wine Trials, only about half of them showed up in this year’s book – even though the number of wines featured has been raised to 150!  Author Robin Goldstein (Blog@RobinGoldstein) was kind enough to grant me an email interview to answer questions about the book and the business.

Brent: I was really surprised that more than half of 2009′s winners didn’t make the cut in 2010. Before you started the research, did you expect that?

Robin: Actually, knowing how different wines can be from year to year, and given how noisy blind tasting results tend to be under controlled conditions, I was surprised that half of 2009′s winners *did* make the cut. That high (in statistical terms, anyway) correlation indicates to me that our process is consistent and rigorous, and it gives me double the confidence in those 50 or so wines, which is why we’ve marked them with a special “repeat winner” designation on the page.

Brent: Did you do any analysis to measure if the palates of the blind tasters have changed? I’m wondering if our tastes skew over time.

Robin: I haven’t done any experiment to that effect, but I am certain that tastes skew over time. Mine have, for one. In the decade or so that I’ve been writing about food and wine, I’ve seen my palate drift away from concentrated, hyped-up New World wines and toward earthy, minerally, very traditional Old World styles like Burgundy and Rioja. It’s another imperfection in the wine rating process, and another reminder of how important it is for readers and wine lovers to blind taste themselves on a regular basis and learn their own palates—not to trust that any critic is going to be able to predict their preferences perfectly. The Wine Trials can’t either. It’s a mere starting point.

Brent: Thank you for not going with the wacko 100-point scale, and thank you for grouping the wines into styles that make it easy to find other wines I’ll like. Thanks for keepin’ it real. Are you worried that over time, as you get more involved with the industry, that you’ll succumb to making the book more complex? What steps do you take to prevent that?

Robin Goldstein

Robin Goldstein

Robin: No, we don’t ever intend to “get more involved with the industry.” Quite the contrary. This book, like the Fearless Critic restaurant guide series, is meant to be a work of totally independent consumer advocacy, and in my mind, the ad-supported wine mags are the opposite of that. In terms of specific steps to make sure we stay independent, aside from tasting everything blind, we don’t accept advertising (or any payments of any kind, like submission fees) from wine producers; and I don’t pay attention to 100-point wine mag reviews (except when I’m analyzing the industry on an abstract level). The positive feedback we’ve gotten on The Wine Trials indicates that these things really make a difference to readers, so I have no interest in changing our formula, other than to try to review an ever-larger selection of good-value wines.

Brent: The original edition of The Wine Trials included a critique of each bottle’s design. I’m a design freak, but even I found that surprising, because the buyer can judge the design without shelling out the money. Why did you decide to take that angle?

Robin: Well, after spending quite a bit of time proving how much the bottle and label form a big part of your experience of the wine, I thought it would be appropriate to evaluate those elements, too. It’s certainly the most playful part of the wine reviews—and, yes, the buyer can draw his own conclusions—but we’ve gotten feedback that people enjoy reading our design reviews, and we hope, in some small way, to encourage producers to make better-looking bottles, too. The other factor is that more and more people are buying bottles online, and you don’t necessarily get to experience the look and feel directly, so hopefully our design reviews can be useful to readers in those situations, too.

Brent: When you wrote the 2010 book, did you notice any winemakers that tweaked their labels in a way you liked more? I can’t help but wonder, because I bet you’d be so excited if you thought you might have influenced their design!

Robin: I wouldn’t be so immodest as to think that it was because of our book, but Columbia Crest’s redesign was a massive improvement. On the other hand, I think Domaine Ste. Michelle, our #1 sparkling wine in both editions, took a step backward with a frillier and less classy bottle design. Some of the new brands that have come out, like Clean Slate Riesling, I think are moving toward simpler, more elegant design concepts and away from the so-called “critter wine” norms. The Domäne Wachau label is so simple and so beautiful. Just like cheap wine doesn’t have to taste cheap, it doesn’t have to look cheap, either. I think the industry is slowly starting to wake up to this.

Brent: Looking forward to 2011, are there any trends you expect to show up in the next edition?

Robin: We’ll have to leave it to the data to reveal the trends, but I’m seeing an explosion in the number of good under-$15 wines being imported from less famous wine regions like Portugal, in part because of the fact that even with the downturn in the economy, wine drinking hasn’t fallen, but the average amount people spend on a bottle has, and the market has responded. It’s an exciting time to be writing about inexpensive wines.

Here’s one thing I’d wish for: more wines from our neighbors. British Columbia and Mexico’s Valle de Guadalupe (in northern Baja California) are both interesting wine areas, and it’s a lot cheaper to import from these NAFTA countries than from Europe—when will we start seeing more wines on the average supermarket shelves from these exciting emerging regions?

I’d also like to see more wines coming from Uruguay, Hungary, the Czech Republic, Bulgaria, and Montenegro. All of these regions have good climates, long winemaking traditions, and offer fantastic value. Are any importers out there listening?

I’d like to thank Robin for taking the time to answer my questions, and I’d really like to thank him and coauthor Alexis Herschkowitsch for the book.  I recommend it highly, and you can buy it on Amazon for around $10.

The price is a steal – it clued me in to a few wines I never would have tried otherwise.  Freixenet is the sparkling wine from Spain that comes in distinctive black bottles, and I always avoided it because the bottle struck me as such a cheesy marketing gimmick.  I tried it based on the first edition’s recommendation, and I’ve been buying it ever since.  It’s a great everyday sparkling wine, second only to our favorite Francois Montand (which is just really hard to find locally.)  Freixenet appeared in this edition too as one of the two-time selections.

Now, about the business of the book.  In yesterday’s post about books and marketing, I talked about the work of marketing the book, but that’s only half of the book business.  Books can also be used to market other things too.  Us geeks think of books as marketing our skills, getting us better consulting gigs or higher rates.  Parents think of books as marketing toys and games to kids.  In the age of the iPhone, though, think of something else:

Wine Apps in iTunes

Wine Apps (and Lady Gaga) in iTunes

If you’re trying to sell an iPhone app about wine, how do you stand out from the dozens (or hundreds) of other developers trying to do the same thing?  Why would somebody pick your app out of the list of search results for “wine”?

Simple – change their search results in the first place.  Make sure they don’t search for just “wine” and that they search for “wine trials” instead.  By having a book, and by putting your app’s name on your book, you send your book buyers straight to the iTunes store to spend more money on you.

Cross-selling apps and books mesmerizes me, and The Wine Trials is an excellent example of an app that I’d buy.  I’d pay $5 just to have the contents of the book with me on my phone because I buy wine when I’m out at restaurants, and this book would save me from some bad investments.  Right now, I use a task list on RememberTheMilk.com to stash my favorite wines.  (I made that task list public so you can see how it works.)  I can access RTM from anywhere on my iPhone thanks to their app, and it caches my tasks so it works even when I don’t have signal.

Why does this matter to geek authors?  Check out the app store results for SQL Server:

SQL Server Apps in iTunes Store

SQL Server Apps in iTunes Store

The books are $4-$6, and the certification tests are around $20.

Are they making money?  Well, it depends on who you call “they.”  The book apps are sold by publishers like Microsoft Press and O’Reilly, and in that case, the original authors make a pretty small percentage of the sale.  (I’d tell you the exact amount, but Wiley/WROX don’t have any books on the iPhone.)  Of course, if you published your own book, you could make more, but then you’d have to manage the app production process.  The Wine Trials is taking this route.

In my next Book Week post, I’ll be interviewing a first-time author who’s already a rock star, and talk about his experiences with the writing and marketing process.

Continue to an Interview with Author Thomas LaRock

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

Website - Twitter - Facebook - More Posts

Book Week: The Economics of Writing a Book

This week I’m focusing on books and the book business.  Today I’ll be covering the money thing for authors, and tomorrow I’ll be reviewing a book I like for both the content and the business.  Enjoy!

Now that I’m holding a physical copy of our book in my hand, the pain of the experience has started to fade, and I can write about it with an open mind.

Books Are Products

You, Too, are a Product

You, Too, are a Product

Publishing is a business.  Every book publisher needs to get a return on their investment in you – and yes, they do make an investment in you.  You might think you’re the one doing all the work, but the publishers have to pay for:

  • Editors to check your work
  • Graphic artists to redraw your illustrations and design the cover
  • Layout pros to turn your Word doc into something printable
  • Lawyers to manage all the contracts
  • Professional sadists who love asking you if you’re done yet
  • Marketing people to convince mainstream bookstores to carry your work
  • And oh yes, the printed books themselves.  Ever notice those thousands of books in the clearance bin?  They cost just as much to print as the ones that sell for full price.

The amount of revenue they bring in for your book needs to be higher than the expenses, which means they need to sell as many copies as possible for as much money as possible.  Some publishers give away their books – but that doesn’t mean they’re willing to sink money into an unlimited number of books willy-nilly.  They’re often using these books as marketing bait in order to get emails from prospective customers.  They want to publish books that will result in a maximum number of downloads (and future customers).

So how do publishers figure out whether the book is a good gamble?  Here’s the book with the perfect odds of success:

  • Good Subject – A book on a subject that’s highly in demand
  • No Competition – No other books cover that subject matter, thereby ensuring readers will buy this one instead of others
  • Author with Expertise – An author who’s extremely experienced with the book’s subject
  • Author with Experience – An author who’s written many a book before and knows how to write well
  • Author with Time – like Jobs said, artists ship.  The book has to get done before the subject matter is no longer interesting or before other competitors move in.
  • Author with Draw – a “brand name” author who readers will actively look for on bookstore shelves.  Even better if the author will actively promote the book, like showing it on all their presentations, do webcasts about it, and blog about it.

Add up all that, and you’ve got the perfect book – but most of the time, this stuff doesn’t add up.  For example, authors don’t have enough time or expertise on a particular subject matter inside the book, so they bring in coauthors (with more time and/or expertise.)  In fact, if you don’t have expertise but you do have the time, you might find yourself getting sucked into book deals as a coauthor just because they’re desperate to get the book out on time.  If you want to be involved in a book, look at that formula to figure out where you’ve got an edge, and then look for other people who need your edge.  If there’s a published author with a book on SQL Server 2008 replication, maybe they’ll need a coauthor on their updated SQL Server 2008 R2 edition.  If you’ve got replication experience, you can offer your services, and presto – you’re in the biz.  Next thing you know, you’ll be the one pitching your own book to publishers.

Pitching Your Book Means Pitching Your Formula

I didn’t pitch our book to Wiley – Christian Bolton did that – but I’ve talked to a bunch of authors about the pitching experience.  (Not the catching experience, though.) Pitching a book involves taking that above formula and improving it with the best possible odds.

Subject – publishers want to know that a lot of people are interested in the subject.  You can prove this out with web statistics on your blog, viewership numbers on webcasts, or search engine trending numbers.  You could also prove it by looking at the sales for other books on the same topic, but if there’s more than a few, you’re going to have problems with…

Competition – search online bookstores for other books on the same subject.  Buy them (although, if you’re proposing to write a book on the subject, you probably own them already), and evaluate their strengths and weaknesses.

Expertise – the publisher probably doesn’t know you, and they’re going to want the equivalent of a job interview.  Can you prove you have the skills to cover the topic well?  The last thing the publisher wants is another James Frey.

Experience – getting a book contract is like getting a job as a DBA; you can’t get a job without experience, and you can’t get experience without a job.  The trick is to start by working as a technical editor for someone else’s book, which gets you involved in the bookmaking process in a safe way.  I’ll save the editing process for another blog entry.

Time – prove to the publisher that you can get the book out the door before a product version change or new competitors come in.  If you have any hobbies, friends, or relatives, that’s going to be a drawback, and you’ll need to bring in coauthors.  Don’t even think about doing your first book by yourself – it’s possible, but a recipe for trouble.

Draw – just like you think you’re not experienced, you probably think you don’t have draw.  You’re wrong.  As an online geek, you already have a big head start – you can create a blog, do presentations, and generally work your rear off to promote the book.  Publishers want someone who’s going to work just as hard after the book hits the shelves, and these days, you can make more than just royalties.  These days, I think this last point is even more important than the writing parts, because…

Writing Doesn’t Pay

No, No One Stole the Radio

No, No One Stole the Radio

One of the cheapest cars on the market is the 2010 Hyundai Accent 3-door in the “Blue” spec.  The “Blue” refers to the buyer in more ways than one.  Your face will turn blue as you roll the windows up and down manually, because there’s no air conditioning.  You shouldn’t try it while you’re driving, either, because there’s no antilock brakes or stability control.  Besides, you need to focus on shifting gears – no fancypants automatic transmission here.  About the only thing “Blue” doesn’t refer to is Rhythm & Blues, because you won’t be listening to any music in this penalty box – that’s right, no radio.  You’ll regret this purchase every time you turn the key – and I mean the key in the door, because there’s no power locks or keyless entry.

Work your rear off every night and weekend for a year straight to bang out a book, you’ll make just enough advance money to buy this beauty, pay the taxes, and insure her for a year.  Maybe even get gas, if you’re lucky.  Your spouse may never forgive you for leaving them alone for so long, but on the bright side, they won’t ask for the car as part of the divorce settlement.

Divide out the author work between multiple people, and it gets easier – but pays even less money.  I make more in a day of consulting than I made sweating over two chapters for months.  And royalties?  Forget about it – once you split the checks up between multiple authors, you’re not making much of anything.

Oh, and remember – this is advance money – you don’t really own it yet.  The publisher is loaning you money with the expectation that your book will make a profit.  If your book doesn’t sell enough copies, you can end up owing them money.  One prominent author I’ve spoken with has only made money on one of his last three books.  The publisher has sent him bills for the repayments of the advances on the other two books.  That’s right – he lost money writing books!

But Marketing Pays

Every now and then on my blog, I do book reviews.  The book review includes a link to buy the book at Amazon, and that link is what’s called an affiliate link.  When people click through that link, I make 7% or more of whatever they buy – whether it’s the book I recommended, another book, a mix CD, or a Wii.  The money adds up fast:

Amazon Referral Earnings

Amazon Referral Earnings

Each time someone buys our book, for example, I make $2.65.  That’s more royalties than I make for my chapters, and guess which one takes less work.  If they happen to add a Wii or a mix CD to their cart, even better.  Yes, I see what you people buy, and I giggle when I see you buying books on Japanese rope bondage and edible collagen casings.  I love you people because you make me look normal.

Anyway, the point is that when the book hits the shelves, a good author’s work isn’t finished.  You can improve your book’s formula by following through and marketing it.  Building the book’s site is just the first step, and then you can take it to the next level by:

  • Linking to that site when you talk about the book
  • Presenting to user groups (your local PASS chapter, PASS virtual chapters, C# user groups, etc) and put the site & the book in your presentation
  • Writing great blog posts that people send to each other, and in the bottom of that post, link to the book for more information
  • Running contests on your site that get people talking about the book

Yes, this stuff feels like spam.  The reality is that most readers aren’t going to know about your book until someone tells them – and that someone could be you.  If you’re not already completely turned off by the whole marketing thing, check out ProBlogger’s list of ways to make more money from your blog, and then everywhere it says “blog,” think “book.”  Later this week, I’ll blog more about how I’m planning to market our SQL Server book.

Professional SQL Server 2008 Internals and Troubleshooting

Professional SQL Server 2008 Internals and Troubleshooting

Would I Write Another Book?

I used to think that anybody who’d published a book must be an absolute genius, and I held them in absurdly high regard.  Now that I’ve been on the other side, I still respect authors, but for different reasons.  A successful author is a good businessperson who took all of the publishing factors into account, did the best they could with their equation, and crossed the finish line.

If you’re in it for the money, write blogs about books (or Wiis or collagen casings or rope bondage) and use affiliate links.

If you’re in it for the love of the subject matter, then write a book.  It’ll be a ton of work, you’ll lose your shirt (relative to consulting income), and your family will hate you while you’re doing it, but afterward, you’ll feel good.

In the long term, I’m in it for a lot of different reasons, and it’s more than just the subject matter.  My next book will be a self-published ebook (hopefully also available through Amazon in printed form), but it won’t be about SQL Server.  I’m working on a book that will combine my love of technology plus my wacko marketing experience, and the way I deliver the book will be part of the book itself.  Tomorrow I’ll talk about a book that has the potential for a really good business model.

Continue to The Wine Trials and its Business Model

More Thoughts About How to Get Published

Some of my posts include:

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

Website - Twitter - Facebook - More Posts