+1 Tuning and managing/operating SQL Server requires access to a bunch of things other than the SQL Server databases. If the DBA is competent, then they should have a decent knowledge of Windows Server, plus great knowledge of SQL Server. Knowing about patching, clustering, VSS, MPIO/networking and other standard Windows Server topics means that they can be trusted to keep their SQL Server clusters working properly and not stuff things up. Otherwise, have great Windows Ops people who know something about SQL Server.
Worst case is if you have two groups that know nothing about how the other product works. Cheers Ken From: Andrew S. Baker [mailto:[email protected]] Sent: Tuesday, 24 January 2012 12:38 AM To: NT System Admin Issues Subject: Re: SQL servers and DBA's I've had the privilege of working with very competent -- and even stellar -- DBAs, and so virtually all of those environments have operated as MBS outlined below. A few have done it as Ed outlines in his email. ASB http://XeeMe.com/AndrewBaker Harnessing the Advantages of Technology for the SMB market... On Mon, Jan 23, 2012 at 9:34 AM, Michael B. Smith <[email protected]<mailto:[email protected]>> wrote: I've got large clients that do it both ways. IN GENERAL, I would say that the large clients who have competent and thoughtful DBAs tend to provide them with local admin, and those that don't - don't. Regards, Michael B. Smith Consultant and Exchange MVP http://TheEssentialExchange.com From: David Lum [mailto:[email protected]<mailto:[email protected]>] Sent: Monday, January 23, 2012 9:22 AM To: NT System Admin Issues Subject: SQL servers and DBA's How do you guys handle DBA access to your SQL boxes - are they local admins? David Lum Systems Engineer // NWEATM Office 503.548.5229<tel:503.548.5229> // Cell (voice/text) 503.267.9764<tel:503.267.9764> ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to [email protected] with the body: unsubscribe ntsysadmin
