SQL Architecture Articles

  • Hi,

    I did not find any articles related to sql server 2005 architecture here. Even in the forums when a user ask about the sql architecture I had seen replies that ask the user to refer BOL. But why dont we have an article which explains sql server architecture. Because most people rely on SSC rather than BOL and in BOL it is difficult for a newbie to understand the architecture.

    [font="Verdana"]Thanks
    Chandra Mohan[/font]

  • Architecture is a pretty broad subject. What kind of articles are you asking about?

    Something about logical design? Physical design? Normal forms? Gathering business requirements? Something else?

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • Hi,

    Logical design and physical design. When we have articles for reporting services architecture why cant we have for sql server.

    [font="Verdana"]Thanks
    Chandra Mohan[/font]

  • ChandraMohan Nandula (7/7/2009)


    Hi,

    I did not find any articles related to sql server 2005 architecture here. Even in the forums when a user ask about the sql architecture I had seen replies that ask the user to refer BOL. But why dont we have an article which explains sql server architecture. Because most people rely on SSC rather than BOL and in BOL it is difficult for a newbie to understand the architecture.

    I refer people to Books Online as it really should be the first place people look for help. Yes, it leaves a bit to be desired at times and can be difficult to find things at other times, but it has a wealth of knowledge if you take the time to explore. It won't answer every question, but it will help you focus your questions that will allow the knowledgeable members of SSC to help you understand the various concepts better, rather than trying to rewrite what is in BOL in a forum post.

  • Those are hard articles to write, and honestly, a few that we've had haven't gotten great reviews or readership. It's complex, and it's hard to understand, and it seems people don't want to make the effort.

    That being said, articles in design are always welcome.

  • ChandraMohan Nandula (7/7/2009)


    Logical design and physical design. When we have articles for reporting services architecture why cant we have for sql server.

    Probably because no one wants to write them. Want to give it a shot?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Even though it is a vast subject, it is a common question in interviews. “Tell me something about SQL Server Architecture”. Do not know what he is expecting from this question.

    Obviously in interview it should be a brief answer. The candidate will be totally confused the moment asked by this question. He doesn’t have any idea from where he has to start.

    Do you think that this question is only to make the candidate uncomfortable? Or is there any answer to clear this SPECIAL 🙂 situation?

    _____________________________________________
    One ounce of practice is more important than tonnes of dreams

  • C.K.Shaiju (4/4/2011)


    Do you think that this question is only to make the candidate uncomfortable? Or is there any answer to clear this SPECIAL 🙂 situation?

    Neither. It's to show the interviewer what are a few of the first things you think about during architecture of a system/database. Do you think database or server first? Do you think in data or flow? Do you imagine and intuit or do you go for technical documents?

    It's open ended on purpose.


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • Ok Craig, Thank you.

    _____________________________________________
    One ounce of practice is more important than tonnes of dreams

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply