SQL Architecture Articles

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQLServerCentral.com » Suggestions » SQL Architecture Articles

SQL Architecture Articles

Rate Topic

Display Mode

Topic Options

Author

Message

Chand00

Posted Tuesday, July 07, 2009 7:23 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Saturday, March 02, 2013 4:42 AM
Points: 525, Visits: 1,096

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.

Thanks
Chandra Mohan

Post #748523

GSquared

Posted Tuesday, July 07, 2009 7:25 AM

SSCoach

Group: General Forum Members
Last Login: 2 days ago @ 1:45 PM
Points: 15,442, Visits: 9,572

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

Post #748526

Chand00

Posted Tuesday, July 07, 2009 7:30 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Saturday, March 02, 2013 4:42 AM
Points: 525, Visits: 1,096

Hi,

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

Thanks
Chandra Mohan

Post #748531

Lynn Pettis

Posted Tuesday, July 07, 2009 8:40 AM

SSC-Insane

Group: General Forum Members
Last Login: Today @ 11:14 PM
Points: 21,832, Visits: 27,862

ChandraMohan Nandula (7/7/2009)

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.

Cool

Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)

Post #748605

Steve Jones - SSC Editor

Posted Wednesday, July 08, 2009 9:13 AM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 5:09 AM
Points: 31,526, Visits: 13,864

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.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #749381

GilaMonster

Posted Wednesday, July 08, 2009 10:01 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 4:08 PM
Points: 38,099, Visits: 30,392

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 2008, MVP
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

Post #749445

C.K.Shaiju

Posted Monday, April 04, 2011 7:40 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Sunday, March 03, 2013 10:42 PM
Points: 179, Visits: 561

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?

Post #1088049

Evil Kraig F

Posted Thursday, April 07, 2011 10:03 PM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 5:35 PM
Points: 5,722, Visits: 6,194

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 | Forum Netiquette
For index/tuning help, follow these directions. |Tally Tables
Twitter: @AnyWayDBA

Post #1090366

C.K.Shaiju

Posted Friday, April 08, 2011 2:11 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Sunday, March 03, 2013 10:42 PM
Points: 179, Visits: 561

Ok Craig, Thank you.

Post #1090441

« Prev Topic | Next Topic »

Permissions