1 DBA has to know what SQL are running in the database. LINQ automatically generates SQL, many LINQ queries are not optimized. programmers can submit SQL to drag down the whole database easily without notifying the DBA.
2 DBA can assign a XML query plan for specific stored procedure, if you study how query plan works, you will know a fine tuned SQL is quite tricky to write. Study the topic of parameter sniffing.
3 Security - Stored procedure has great security
4 In LINQ, schema modifications of the database sometimes need to touch the application code.
Many developers does not agree with me coze they lack DBA knowledge. I am a rare developer with good DBA skills and good .Net skills.
Friday, 19 December 2008
Subscribe to:
Posts (Atom)
