I was at a company where system load was increasing significantly every month and the sql server database we were running on was locking up causing timouts for the intranet and public sites it supported. We didn't know how to fix the problem quickly. We brought in a $90/hr sql server expert. He cleaned out the deadlocks in about 2 weeks. Over another 8 months he did a massive amount of optimization work across hundreds of sprocs, made schema changes, hardware changes, changed the way we distributed db instances across the hardware, the amount of hardware/db instances... This is what a great dba can do. This particalur guy however wouldn't be good for coming in at 4am and running processes for data validation. I don't think he was ever in before 11 and he'd laugh in your face if you suggested he come in at 4 and run processes.
-----Original Message----- From: Unmoderated discussion of advanced .NET topics. [mailto:[EMAIL PROTECTED] On Behalf Of Steve Welborn Sent: Wednesday, September 14, 2005 7:25 AM To: [email protected] Subject: Re: [ADVANCED-DOTNET] Business logic >>The most important person on any development project is usually a DBA. >>Good DBAs can save a project - simply because THEY know what they're doing >>and can create a performing database and schema. I venture to say a great developer doesn't need a DBA for anything because they would have the skills to do every layer of an application, from creating and maintaining a database(keeping the performance up), business logic classes and design, to the front end. I've been a developer for 9 years and only once have I had the opportunity to work with a real DBA. All he did was come in at 4am and run processes for data validation so that when we programmers get in the data will be where we need it. This was about 5 years ago, had I known then what I know now we would of gotten rid of the DBA and put the data validation in a class somewhere and scrubbed the data as it went to the database. Steve __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com =================================== This list is hosted by DevelopMentorR http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com =================================== This list is hosted by DevelopMentor® http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com
