I was actually going to ignore that someone had tagged me in a SQL Quiz. I really was. Then I realized that the someone who tagged me was Thomas W LaRock and that he would probably beat me with a broom handle and pour bacon flavored Jaeger down my throat when I got to the PASS Summit, so I decided I should probably do my best to answer the questions.
Do you feel that you have a reliable SAN solution? If so, what’s the secret?
I have no idea if I have a reliable SAN solution. I think it’s reliable, but I’m basing this on the assumption that it hasn’t failed yet. I have to admit that most of our storage uses a direct attached storage device, which irks me to no end since I only have 16 drives to work with. However, I have it on good authority that our SAN has never caught fire or exploded or spontaneously deleted data… within recent memory. (Using these assumptions, my intestinal tract is currently incredibly reliable since it hasn’t experienced a catastrophic failure since I went to that dodgy Chinese buffet in Dayton.)
Explain Database Mirroring in layman’s terms
No. Oh, there’s Thomas W LaRock with a broom handle… I should probably explain database mirroring.
I had to go look this up. I’m a database developer, we don’t work with these kinds of things on a daily basis, we leave that to the production support DBAs. However, I have it on good authority that database mirroring is a very complicated thing, much like sex, and, much like sex, people lie about how great it is, how much of it they’ve got, and everyone claims they’ve had it working in a 3-way but they can’t actually prove it. Although, looking at Books Online, I could be wrong about that…
