• Bill (DBAOnTheGo) (4/16/2014)


    Personally I'd like to make sure this is out there. Francis Apel, we do appreciate the article and you writing here. Not everyone will agree and in honesty it created some great discussions and got people learning. Thank you for that.

    +1.

    Personally I think it's a great article but like many other posters have said I don't agree with everything but hey it's a "Discussion Group". Sometimes I'll stand corrected if people provided examples but sometimes I'll agree to disagree.

    With SQL Server HA methods I suppose it depends on what people are comfortable with supporting/administering, or have been forced to support. I remember SQL 2000 clustering and that could be a right pain to support, one tiny issue and it would simply refuse to failover. Personally I like clustering, I see it as the bread and butter of a Production DBA. But to implement it takes time and some companies just don't have the time to train people in understanding clustering - as Brent Ozar puts it, "The Accidental DBA" it can be just too much, so it's far simpler to have a single SQL instance.

    qh

    [font="Tahoma"]Who looks outside, dreams; who looks inside, awakes. – Carl Jung.[/font]