July 7, 2009 at 7:23 am
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]
July 7, 2009 at 7:25 am
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
July 7, 2009 at 7:30 am
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]
July 7, 2009 at 8:40 am
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.
July 8, 2009 at 9:13 am
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.
July 8, 2009 at 10:01 am
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
April 4, 2011 at 7:40 am
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
April 7, 2011 at 10:03 pm
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.
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
April 8, 2011 at 2:11 am
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