SQL Quiz 5

Posted: August 10, 2009 in Uncategorized


Most of my SQL Quiz questions I like to keep light. Today I thought I would change the pace a touch. I really want to ask and see what answers we get on a couple of questions.


  1. Do you feel that you have a reliable SAN Solution? If so what is the secret?
    1. This question comes from a tune up session I was doing last year. I had about 160 attendees that I had asked to stand and once they stood I said that if you are confidant in your san and it performance the way you need it to, remain standing. I think 98% of the people that were standing sat down. I have been from client to client that has SAN issues. I know that we have to find the area that we can meet where DBA’s and SAN Administrators can find that happy place in the middle.
  2. I was recently asked to describe SQL Server Database Mirroring. The client that I was answering the question for was trying to use database mirroring for a reporting server. When I explained to him the issues around this he asked me to describe in laymen’s term what database mirroring was.


    My Answers

    1. If you are a DBA I think you need to start learning SAN technology. Not for a job change of conversion, but I think DBA’s that can help with the configuration of the disks are going to be helpful, even with that being said I think DBA’s and SAN Administrators are going to have to reach out and really work close together.
    2. I described database mirroring as a potentially geographically disbursed failover solution. When I sit down and use it and look at the features that I have had a chance to use I see a clone of clustering on the database level that is not bound by physical location.


So as always I will tag two people and hope that those 2 post the answers and then tag 2 other people.

I am going to tag

  • Brent Ozar – He is a great SAN/DBA and I think he will have some great answers.
  • Jason Strate – Good SQL Guy and would love to see what he thinks.


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

  2. SQLRockstar says:

    somehow i knew this would end up in my lap before the end of the day…

  3. […] he went and did it again, Chris Shaw started yet another web chainpost. This time he tagged Brent Ozar and Brent tagged me and put the […]

  4. […] Timothy Ford on Aug.11, 2009, under Bacon Bits and Bytes, Humor, Quizes, SQL, Syndicated So Chris Shaw is at it once again, keeping the SQL Server community on the balls of it feet as opposed to the […]

  5. […] Chris Shaw’s come up with yet another of his SQL quizes, this one’s a little more technical than the previous few have been. Tim Ford tagged me on this one. […]

  6. […] Shaw has a new nickname. I here by dub the “Meme”. He has a new quiz out. Meme tagged Brent Ozar(WWW, Twit) who tagged Thomas LaRock(WWW, Twit) and Tim Ford(WWW, Twit) as […]

  7. […] Quiz 5: SANs Mirroring My turn to answer Chris Shaw’s questions “Do I feel I have a reliable SAN solution?” and “Describe Database […]

  8. […] Chris Shaw’s Blog Quiz – I made some jokes in my response and things went swiftly downhill from there.  See answers from Grant Fritchey, Jason Massie, Tim Ford, Tom LaRock, and others. […]

  9. […] Shaw ( Blog | Twitter ) started another great web chainpost. He tagged Brent Ozar, Brent tagged Thomas LaRock and Tom tagged me. This particular quiz is a […]

  10. […] SQL Quiz started by His Evilness, Chris Shaw. Okay, Chris isn't evil; I just wanted to […]

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s