how do u know..

  • Hi every one, i have simple yet complicated Question. Is there a way or a list to follow when you are creating a database in sql server 2008. i mean say you want to tell your company that this is the steps i will go through to make the database. you know like you build a house and you know you have to level the ground put the water pipes and electricity pipes and base of the house. hit me back with the answer please.ย 

    Regardsย 

    and good luck ๐Ÿ˜‰

  • The only comment I might make is to say that actually creating the database and the objects within it are probably the most trivial part of the entire project.

    To use your house construction analogy, you need good architect and perhaps a structural engineer (in my world these would be lead DBAs and *experienced* software engineers) to design building plans and specifications. If you have that and a good head contractor (aka project manager) the actual construction can be done by any number good tradespeople (aka programmers).

    Creating the tables and other database objects are a relatively trivial part of the overall task when their definition is part of a well designed and documented product.

    That's my $.02

    The probability of survival is inversely proportional to the angle of arrival.

  • Awesome reply sturner but i would add one thing to this and that is you have this house (database) you may want to protect it a lil bit and put a gatekeeper/policeman (DBA) at the entrance to make sure that the ones that access (users) your house have the proper permission. Just a lil add on =]

    DHeath

    DHeath

  • Nice Reply both u guys but one thing if i can hire these people, then i don't have to study SQL server my self Right. and i must be rich so people can work for me and then i don't have to even know all this Rite....

    i really don't what to say after getting those Answers.

    Now just help me decide.. should i keep on studying or Hire those Architect, Police man, Engineer etc etc to build me a House (AKA Database)

    Regards ๐Ÿ™‚

  • Your project(s), clients, requirements and your desire to learn sql are the answers to that question. If you are looking for a reason not to learn sql then just hire somebody, if you want to do it yourself then roll up your sleeves. This site is a great place to learn.

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 โ€“ Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

  • "Now just help me decide.. should i keep on studying or Hire those Architect, Police man, Engineer etc etc to build me a House (AKA Database)"

    You bring up an excellent point. Not too many people design and build their own house. What they usually do is create the requirements document by determining:

    1 How many bedrooms do we need.

    2 How many cars need to fit in the a. driveway b. garage

    3 How much energy do we want to use to a. heat it, b. cool it

    4 What are the peak and average temperatures, sunlight & wind velocity it handle

    5 Can we add on to it easily if we end up having more people living there.

    6. etc.

    Once these things are determined and *documented* the architect and engineers can develop the design specification and bill of materials (hardware platform, database and software objects).

    The probability of survival is inversely proportional to the angle of arrival.

  • Thanx again guys i just want to know where should i START from right now some times i get hung up in creating database some time rolls some jobs, procedures, Trigger and on and on.... but i want to know is in there some kind of a systematical way i mean i think i'm missing a lot of info like this i have bought some books and videos but they do the same things by not telling you that this is the Head and toes.

    i have Windows Server 2008 r2 and Sql Server 2008 r2 now i think there must be a way they get connect so they will work till the highest. there is just people saying do this and we will talk about that later do that now. isn't any structure to this thing or Microsoft being Microsoft not having Structure to any thing... (not like mac u know)

    well if some one has a decent answer to this Question hit me back...

    regards

  • Sean Lange (2/10/2011)


    Your project(s), clients, requirements and your desire to learn sql are the answers to that question. If you are looking for a reason not to learn sql then just hire somebody, if you want to do it yourself then roll up your sleeves. This site is a great place to learn.

    Or, to stay within the house picture:

    If you intend to blindly trust your architect that he'll need 6 month to design your house and you'll need to pay a few hundred thousand <insert your currency here> for the design, stop studying and make sure you have an open budget.

    But if you need to watch your budget, you might continue to study in order to be able to put the stuff you're told into the right perspective.

    Basically you have two choices: either become a generalist and know enough to distinguish between "sounds logical" and "totally out of scope" or become a specialist and be able to discuss details of the structural analysis your architect comes up with.

    You need to define the point where you want to draw the line: if you don't care what the DB looks like and all you're after is functionality: get a Business Analyst (BA) and/or a Project Manager. Describe what you want and let them do the rest. In that case you should study on how to define your requirements.

    Just keep in mind: if you hire someone you should be able to evaluate their qualification and you should also be able to "translate" the stuff they come up with to check if this is really what you need.



    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • stuner man, i count my self in "NOT TOO MANY" category then. coz i want to build and design and do every thing my self.... and learn that way..

    if u want to see what i have made until now shout me ur mail i'll send you JPEG file of the design that i created...

  • Lutz - that is exactly what I said...however yours can be interpreted by somebody other than myself. ๐Ÿ˜› Well spoken!!!

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 โ€“ Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

  • here are the basic steps:

    1. requirements document

    2. design specification (here is where you define database objects)

    3. test plan document

    4. development

    5. test

    6. beta release

    7. final release

    Everything follows step 1. some of the steps can run concurrently (like 3 - 7 ) but 1 must be done first.

    usually when I have had to come in and "fix" a badly designed system it was because the requirements were never really defined. You can not design a solution if you don't understand the problem.

    ;-);-)

    The probability of survival is inversely proportional to the angle of arrival.

  • first of all sorry about ur name Sturner.

    next guys Hold on I am A STUDENT not a business man not IT pro NOt any Share Holder.

    NOW I WANT TO LEARN THE DATABASE MY SELF, THAT HOUSE THING WAS JUST AN EXAMPLE.

    AS A DATABASE STUDENT I WANT TO KNOW IF THERE IS A LIST OR A STRUCTURE OR A SYSTEM TO BUILD DATABASE THAT ANY BUDY SHOULD FOLLOW....

    STOP WRITING USELESS ID'S

    THANK YOU

  • NOW WE TALKING MAN nice job

    thank you.. is there more to it. what and how this doc should be written or...

  • ramksharma91 (2/10/2011)


    first of all sorry about ur name Sturner.

    next guys Hold on I am A STUDENT not a business man not IT pro NOt any Share Holder.

    NOW I WANT TO LEARN THE DATABASE MY SELF, THAT HOUSE THING WAS JUST AN EXAMPLE.

    AS A DATABASE STUDENT I WANT TO KNOW IF THERE IS A LIST OR A STRUCTURE OR A SYSTEM TO BUILD DATABASE THAT ANY BUDY SHOULD FOLLOW....

    STOP WRITING USELESS ID'S

    THANK YOU

    @ramksharma91

    It would have helped a lot if you would have told us right away you're a student. Now we know.

    Secondly, please stop yelling at us (writing in capitals). There's no reason to do so.

    Since you disqualify our ideas as being useless: Would you be so kind telling us what idea you would consider as being useful? Sturners recent list is the the very basic concept of a solid database design. There are a lot of books written about database design. Would you consider a few book titles as being helpful?



    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • ok i will not yell but i think before you or any buddy write at some blog you should know the problem where it all started.

    now i know there is a lot of books around but it is all to messy no one tells you what come first the EGG or THE Chicken (in database). so where every i start after some time its just get more messy. the way they start is very nice Like-- you create table now put some data into it then we learn DML and then all the sudden BOOM (its just an example) so u know guy like gets lost very easy...

    sorry guys i don't mean to say any thing bad or be rude...

    Regards

Viewing 15 posts - 1 through 15 (of 21 total)

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