Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-02-14 : 09:00:43
|
| baby writes "Pl let me know what a production dba's daily work is ? and on what i have to concentrate more to become a production dba." |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2006-02-14 : 09:05:26
|
Backups. You'll do a lot more than backups, but if you get them wrong, you'll probably be looking for a new job, and if you've lost databases then it's pretty hard to do any other work.  Learn it, know it, live it, to the point where backups and restores are just as natural as doing a SELECT.Next would be performance tuning. This involves studying your data models, the types of queries that are run against them, and doing analysis to determine if indexes are needed. It can get pretty involved and is a separate topic unto itself.Maintenance activities such as updating statistics, reindexing and/or defragging indexes, and job scheduling/rescheduling would come next. This is just my own personal priority list, other people will provide more information. |
 |
|
|
SQLServerDBA_Dan
Aged Yak Warrior
752 Posts |
Posted - 2006-02-14 : 11:46:36
|
quote:
Originally posted by AskSQLTeam
baby writes "Pl let me know what a production dba's daily work is ? and on what i have to concentrate more to become a production dba."
I would recommend you become and anesthesiologist or something else in the medical field. Medical employees will always be needed and the pay will always be good. Don't become a DBA.  |
|
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-02-14 : 12:36:10
|
quote:
Originally posted by AskSQLTeami want to become a SQL SERVER DBA
Me too |
|
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2006-02-14 : 12:50:43
|
quote:
Originally posted by AskSQLTeami want to become a SQL SERVER DBA
First, you must be chosen by the Grand Council Of Elders. |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-02-14 : 13:49:36
|
quote:
Originally posted by AskSQLTeam
baby writes "Pl let me know what a production dba's daily work is ? and on what i have to concentrate more to become a production dba."
Be careful what you wish for. It may come true.CODO ERGO SUM |
|
|
|
bakerjon
Posting Yak Master
145 Posts |
|
|
|
|
|
|
|
i want to become a SQL SERVER DBA