Today’s quiz from Chris Shaw is a two-parter, and for once in a web quiz, the second part really is a quiz.

1. Do you feel that you have a reliable SAN solution? If so, what’s the secret?

Your SAN Admins

Your SAN Admins

The key to getting a reliable SAN solution that no human being can mess up is to spend over a million bucks on it and buy an Enterprise-class SAN.  Those things are engineered like nobody’s business.  Once they’re set up, it’s hard for us meatbags to goof it up.

Spend less than that, and you get a midrange or entry-level SAN.  These SANs, if left to themselves, are pretty reliable.  The problem comes in when well-meaning mammals walk up and start tweaking dials or upgrading firmware.  The more changes you make to your SAN, the less reliable it gets.

I hardly ever see a stock Honda Civic at the side of the road with the hood up.  The only times I see a stranded Civic is when it’s loaded up with spoilers, tinted windows, custom rims, a fire extinguisher mounted to the A-pillar, and a series of add-on gauges rising up from the dash.  If you don’t want your SAN to look like something out of the Fast and the Furious, the secret is to lay off the nitrous oxide and stop tweaking settings.

2. Explain database mirroring in layman’s terms.

When asked to explain radios, Albert Einstein said:

“You see, wire telegraph is a kind of a very, very long cat. You pull his tail in New York and his head is meowing in Los Angeles. Do you understand this? And radio operates exactly the same way: you send signals here, they receive them there. The only difference is that there is no cat.”

Database mirroring is exactly the same.  See?  Now, if you’ll excuse me, I’m itching to go play Einstein on a Beach by Counting Crows.  I always giggle when I hear it on the radio – it’s like Einstein’s meowing.

Who I’m Tagging

I’m taggin’ the funniest SQL guys I know – the old Bacon Bits and Bytes crew – to see if they’ll outfox my database mirroring analogy:

Brent Ozar
I make Microsoft SQL Server faster and more reliable. I love teaching, travel, and laughing.

I’m mostly a figurehead here at Brent Ozar Unlimited. My true skills are menu advice, interpretive dance, and reading Wikipedia.
Brent Ozar on sabtwitterBrent Ozar on sablinkedinBrent Ozar on sabinstagramBrent Ozar on sabgoogleBrent Ozar on sabfacebook
↑ Back to top
  1. thanks for the tag…i think…

  2. Pingback: Database Mirroring Freak Show – SQL Quiz from Chris Shaw | The SQL UPDATE Statement

Leave a Reply

Your email address will not be published. Required fields are marked *