October 4, 2013 at 6:03 am
We are starting a New campaign for which we need DBA checklist & Templates for SQL SERVER 2008.. all required checklist DBA uses...
which should include Maintenance tasks etc.. etc.. everything which is required.. Please suggest
************************************
Every Dog has a Tail !!!!! :-D
October 4, 2013 at 6:29 am
I can only suggest that you hire a DBA. There is no step-by-step recipe or template for things a DBA has experience with. Also, every database on every server is different for different reasons. Doing the same thing to all databases on the same box, may cause issues with some of them.
It all depends on what is really needed. Things like some databases would not need log backups every 10 minutes, some may not need them at all. Where some would. But it all depends. Some would need some of the more "hi transaction" tables moved to another filegroup, or even another drive, where some will not.
You cannot use a Template for things. There are many great DBAs out there that love and need the work, hire one.
Andrew SQLDBA
October 4, 2013 at 9:48 am
Right Andrew.. but they will not do so.. they have asked a developer to perform this task:-D
************************************
Every Dog has a Tail !!!!! :-D
October 4, 2013 at 10:56 am
Tell them that is not the job of a Developer. I am not a Developer, because I am a DBA. I would not hire a painter to build my house. That is not what that person has experience doing, or the correct tools to do.
Tell them, "I hope that you don't want your data around for very long". I have a great story about this fact.
Both Myself and another DBA were scheduled to interview on the same day. We both went in before the small panel of school board people for the interview. Seems that things went well for us both, as we discussed later at lunch with each other after the interview process. Come to find out later on, neither of us got the job. But we did meet up later on at a credit card company, we were both working as a SQL DBA there. One day, he started laughing and called me over. He read the headlines of the newspaper aloud. The topic of the story was this:
Anyone having any papers, report cards, old grade books, etc... please notify the school board. We have some how lost all of our data and we are trying to build as much back as we can. If anyone knows of anyone having any of this, please call or come by.
Seems they decided to hire, Not a DBA, but someones nephew that knew a little bit about computers. Not Servers, not Databases, not anything but small home computers. He had dropped all databases, and then to try and fix the issue, formatted the drives, because he was told that is what to do. This person did not take a backup of any data, and did not know the right thing to do to quickly recover the data and get it back up and running. Not only that, he did now know anything about servers.
Having the right person for the job, will pay for them many times over. A Good DBA is not a magician either, nor a clean up person. Most companies will want to hire a DBA after someone else, with no DBA experience has already had their mits in it, and messed things up but good.
I once walked off a job, quit that day. All because they let a develop, not a database developer, design the database. And then when I was hire, they wanted to know why it took so much effort and time to create a simple query. I told them the truth,
The database is not designed to do that. We need to scrap that and start over.
I told them over and over. So one time they came to me again, and ask me how to make things run faster, we need this database to perform much better. That is when I told them,
I am by no means a magician or a janitor. I have told you what needs to be done, and you don't like the truth.
After that, I walked out that afternoon.
I keep in touch with a couple nice people I met there, not IT people. They have told me that the company has hired a couple more good DBAs and they have all walked off the job after a few months.
Andrew SQLDBA
October 4, 2013 at 11:24 am
OnlyOneRJ (10/4/2013)
Right Andrew.. but they will not do so.. they have asked a developer to perform this task:-D
Start by updating your resume, because a company that won't hire a person who can actually do the job is the kind of company that will blame anyone tangentially involved when the person who can't do the job messes up (and it's when, not if)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 4, 2013 at 12:04 pm
Exactly Right Gail
Run while you can before your name gets tar on it.
What was also funny about that true story I told in my post. The school board contacted both of us asking if we would come work there. LOL
No way in hay!!
Andrew SQLDBA
October 5, 2013 at 4:00 am
Lolzz Andrew... Thanks Gail....
Now they have got a DBA who knows about Backup/restore, logins, user access, Maintenenace tasks etc.. but no knowledge of performance tunning...
they are from different department so i cant interfere... just friend needs help on it..
actually he has been hired to assign tasks & subbmit & maintain checklist on daily basis abt DB server, which may include tasks, backup/restore info etc.. daily DBA checks etc..
************************************
Every Dog has a Tail !!!!! :-D
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply