Home Forums SQL Server 2008 SQL Server 2008 - General things to know when designing a new database RE: things to know when designing a new database

  • January 22, 2013 at 11:15 am

    #1579764

    DiverKas (1/22/2013)

    1) Do NOT let your C#/VB/ASP/Pascal guys design the database.

    2) Do NOT let your DBA's design the database.

    3) Hire a Data Architect.

    Just saying. The first 2 groups have very biased views of how data should be structured for VERY different reasons, neither of which usually solves the entire problem.

    #2 is NOT necessarily true -- it depends on the DBA. I have long-term experience in all phases of the design process.

    Also, if you hire someone who's solely a Data Architect, then you have to hire an additional person to convert the logical model into a physical model.

    SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.