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 12345»»»

An Introduction to Database Design Expand / Collapse
Author
Message
Posted Monday, January 17, 2011 9:23 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 11:03 AM
Points: 11,194, Visits: 11,167
Comments posted to this topic are about the item An Introduction to Database Design



Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #1049036
Posted Tuesday, January 18, 2011 12:06 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, January 6, 2014 1:47 AM
Points: 292, Visits: 1,084
Excellent article paul.Couldn't ask much better than this.
Great work done.
Satnam
Post #1049078
Posted Tuesday, January 18, 2011 12:09 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 2:18 AM
Points: 6,258, Visits: 7,445
Very nice Paul. A good primer for the millions of simple database conversions out there.


- 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 #1049079
Posted Tuesday, January 18, 2011 12:20 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, September 12, 2014 2:30 AM
Points: 1,420, Visits: 1,838
Hats off to you, Paul! Excellent article. Very beautifully explained via the use of a nice, gripping story that evolves itself into shape.

Thank-you!


Thanks & Regards,
Nakul Vachhrajani.
http://nakulvachhrajani.com
Be courteous. Drive responsibly.

Follow me on
Twitter: @sqltwins
Google Plus: +Nakul
Post #1049082
Posted Tuesday, January 18, 2011 1:17 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: Thursday, March 27, 2014 8:16 AM
Points: 534, Visits: 282
Brilliant article!
Well explained - I think even a DB novice would be able to understand this.

I wish I could have given more stars :)


Kelsey Thornton
MBCS CITP
Post #1049105
Posted Tuesday, January 18, 2011 1:57 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:54 PM
Points: 13,735, Visits: 10,705
Excellent article!
It really explains the basics of database design in a fun, not-too-technical manner.

Great job!

And it's been a long time since I've seen Alice and Bob
(I guess the last time was when Trudy tried to hack into Bobs email account while impersonating Alice)




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1049128
Posted Tuesday, January 18, 2011 2:02 AM


Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, December 16, 2013 12:35 AM
Points: 9, Visits: 121
Hey Paul,

I couldn't stop myself to say that your article was great and nicely present even a layman can understand what you trying to describe through your post.

It just like reading some story about the SQL man.

Good work keep it up..!!!

Thanks,
Anil Maharjan
Post #1049132
Posted Tuesday, January 18, 2011 5:03 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: Saturday, September 10, 2011 8:08 AM
Points: 539, Visits: 201
Paul, thanks for this article and very needed for me at this time as I have an intern who is learning about SQL Server database design. I quickly printed your article out for him to read today and we can discuss later.

Brad
Post #1049222
Posted Tuesday, January 18, 2011 6:46 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, April 20, 2011 11:23 AM
Points: 1, Visits: 14
Great article. I plan on sharing this with a few of my co-workers who are being pushed to learn SQL, yet don't understand DBs.
Post #1049293
Posted Tuesday, January 18, 2011 6:56 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Yesterday @ 1:47 PM
Points: 89, Visits: 470
This is quite possibly one of the best technical articles for a wide audience that I have read in a long time, Paul. To anyone who is already well acquainted with database design, there won't be much new here but that isn't the target audience, is it? I really like how the story was used and how concepts were built upon each other in manageable chunks to get to the final point.

I haven't rated an article in long while but had to stop to log in and rate this one. Anytime I need to explain any of the concepts of normalization or explain database design to a business person, I'll be including this article as a reference.

While the database design aspect of this article may have been a review, I did learn something here - a great method for teaching and writing.



__________________________________________________

Mike Walsh
SQL Server DBA
Blog - www.straightpathsql.com/blog |Twitter
Post #1049301
« Prev Topic | Next Topic »

Add to briefcase 12345»»»

Permissions Expand / Collapse