April 10, 2015 at 11:37 pm
Hi
We should monitor Database Objects created by development dept.
in 2 views :
- View , sps , .. to have best performance
- Tables , ... To have standard Design. Such as select best PK and constraints , .. and review Relational tables and ..
First of All I should prepare a guide line for Developers as a template and guide for them
And the second a complete refrence for me to control them.
If there is such Guide please introduce to me.
if you know a simple reference about normalization please introduce to me .
Thank you
April 11, 2015 at 4:22 am
There are simple references for normalization all over the place online. Just do a search and you'll find one.
As to a guide on database design, I'm not aware of a good one that's laid out like a checklist. Closest one I'm aware of is Brad McGehee's Sure DBA Checklist[/url].
Other than that, Louis Davidson has an excellent book on database design. I have a book on query tuning that includes a checklist in the last chapter. My link is below there in my signature.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 11, 2015 at 1:34 pm
MotivateMan1394 (4/10/2015)
HiWe should monitor Database Objects created by development dept.
in 2 views :
- View , sps , .. to have best performance
- Tables , ... To have standard Design. Such as select best PK and constraints , .. and review Relational tables and ..
First of All I should prepare a guide line for Developers as a template and guide for them
And the second a complete refrence for me to control them.
If there is such Guide please introduce to me.
if you know a simple reference about normalization please introduce to me .
Thank you
Further on Grant's excellent advice, don't try to build a check-list type guide on what or how to do anything on the database, focus on how to streamline development iteration which will build accumulated knowledge on both sides, for the developers it enhances their knowledge on database practices and for you, the knowledge of the problems the developers are working on, hence how to advice them. A check-list approach will fail as there are almost infinite possibilities/problem combinations, simple mechanism like a check-list cannot cover but the simplest of those. In other terms, teach the developers when and how to ask a question;-)
😎
April 11, 2015 at 2:42 pm
Excellent points Eirikur. I agree. I do like the checklist for the common problems, using the wrong data type, functions on columns, stuff like that. But even those, tell people why they're problematic so that they understand not just "The DBA says we can't do this." Education and teamwork is the way to go.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply