Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Architecture Articles Expand / Collapse
Author
Message
Posted Tuesday, July 7, 2009 7:23 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, July 25, 2014 12:52 PM
Points: 530, Visits: 1,134
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
Posted Tuesday, July 7, 2009 7:25 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Friday, June 27, 2014 12:43 PM
Points: 13,872, Visits: 9,596
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
Posted Tuesday, July 7, 2009 7:30 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, July 25, 2014 12:52 PM
Points: 530, Visits: 1,134
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
Posted Tuesday, July 7, 2009 8:40 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 11:10 AM
Points: 20,705, Visits: 32,358
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.



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
Posted Wednesday, July 8, 2009 9:13 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 10:42 AM
Points: 31,084, Visits: 15,532
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
Posted Wednesday, July 8, 2009 10:01 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 7:59 AM
Points: 39,984, Visits: 36,353
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
Posted Monday, April 4, 2011 7:40 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, September 23, 2014 5:06 AM
Points: 196, Visits: 660
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
Post #1088049
Posted Thursday, April 7, 2011 10:03 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 1:46 PM
Points: 5,384, Visits: 7,458
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
Posted Friday, April 8, 2011 2:11 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, September 23, 2014 5:06 AM
Points: 196, Visits: 660
Ok Craig, Thank you.

_____________________________________________
One ounce of practice is more important than tonnes of dreams
Post #1090441
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse