SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Question about DBA authority versus responsibility


Question about DBA authority versus responsibility

Author
Message
webrunner
webrunner
SSCarpal Tunnel
SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)

Group: General Forum Members
Points: 4114 Visits: 3878
Thanks again, everyone.

In this case, it turns out this database supports official software that needs to be supported from the systems side as well, and I met with my colleagues and confirmed in writing that that software vendor is taking responsibility for the SQL Server configuration. However, I will also be invited to meetings pertaining to the software so I know what's going on. At least now I will have a chance to discuss with the vendor, at the meeting, what I did to ensure the basic health of the server and what if anything they recommend to change.

I'm happy with the outcome, but I will be reviewing this with my boss to ensure that as much as possible we are made aware of software that requires SQL while those decisions are being made, not after they're installed and have trouble.

Thanks again,
webrunner

-------------------
"I love spending twice as long and working twice as hard to get half as much done!" – Nobody ever.
Ref.: http://www.adminarsenal.com/admin-arsenal-blog/powershell-how-to-write-your-first-powershell-script

"Operator! Give me the number for 911!" - Homer Simpson

"A SQL query walks into a bar and sees two tables. He walks up to them and says 'Can I join you?'"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
ACinAZ
ACinAZ
SSC Veteran
SSC Veteran (209 reputation)SSC Veteran (209 reputation)SSC Veteran (209 reputation)SSC Veteran (209 reputation)SSC Veteran (209 reputation)SSC Veteran (209 reputation)SSC Veteran (209 reputation)SSC Veteran (209 reputation)

Group: General Forum Members
Points: 209 Visits: 957
Four years ago I was in a Data Admin group that got tired of being called to fix problems in these rogue installs. The Manager got a bright idea and started charging back their time to the development/business group. Once the business-line VP's started seeing very expensive DBA time showing on their monthly cost sheets, the CIO got calls and before long those old systems (one was SQL2000!) were brought up to current specs and the servers were placed under the Data group care. Problems tended to taper off once that happened...
webrunner
webrunner
SSCarpal Tunnel
SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)

Group: General Forum Members
Points: 4114 Visits: 3878
ACinKC (3/11/2013)
Four years ago I was in a Data Admin group that got tired of being called to fix problems in these rogue installs. The Manager got a bright idea and started charging back their time to the development/business group. Once the business-line VP's started seeing very expensive DBA time showing on their monthly cost sheets, the CIO got calls and before long those old systems (one was SQL2000!) were brought up to current specs and the servers were placed under the Data group care. Problems tended to taper off once that happened...


Nice. Thanks for that tip. I will keep it mind. I don't think we have chargebacks that work that way with hours within our department, but I can do something similar by tracking the requests that come in and the hours of my time that they would take up. Something that lets management know that the SQL maintenance for these servers isn't just taking care of itself.

Thanks again,
webrunner

-------------------
"I love spending twice as long and working twice as hard to get half as much done!" – Nobody ever.
Ref.: http://www.adminarsenal.com/admin-arsenal-blog/powershell-how-to-write-your-first-powershell-script

"Operator! Give me the number for 911!" - Homer Simpson

"A SQL query walks into a bar and sees two tables. He walks up to them and says 'Can I join you?'"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
duvvit
duvvit
Grasshopper
Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)

Group: General Forum Members
Points: 10 Visits: 89
I have been supporting MSSQL now for 17 years, and have come across this issue many, many times.
I usually follow the following process:

1. Fix the problem.
2. Install monitoring / alerting processes to warn/fix issues should they occur again.
3. Advise that the systems should 'really' be supported by my group.
4. Provide a report of findings, highlighting where 'gross errors' were made due to not being implemented / administered by individuals skilled in database administration.
5. Leave it at that. If they are really THAT concerned about failing systems, they will see that correct support as advised is necessary, and allow you to maintain any other systems.

You can't be expected to do much more than above, and the report is a great 'get out of jail free' card, advising on issues and offering support.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search