Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 Creating company's RDBMS development review group

Author  Topic 

dbarr99
Starting Member

2 Posts

Posted - 2008-02-22 : 08:31:56
Hello,
I've proposed to the head of IT at my organisation to head an database development export group to:
- Provide assistance in improving the performance of existing relational databases
- Provide assistance for the development of new database, e.g. correct construction of indexes; data contention, etc.
- Creation of database development standards
- Enforce the above standards for new databases so that the database is not deployed to production servers until it passes the standards.

I'd really like this to be a success as it should improve our rather crappy databases, basically because the people currently creating the databases don't know much about relational design.

Can anyone please post their experiences of setting something like this up, or working on such an expert group where they work? I'd really like to hear the good and bad experiences and what and (what not) to avoid.

Thanks

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-04-09 : 19:41:38
Knowledge about RDBMS is very important for SQL server. Developers need to be really good in designing database structure or get help from DBA.So they won't have problem in production environment
Go to Top of Page

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2008-04-09 : 20:54:38
it's important to have design reviews.

that is, designs must be thought through before code is written and reviewed by people that know what they are doing.


elsasoft.org
Go to Top of Page
   

- Advertisement -