| Author |
Topic |
|
purisqlserver
Yak Posting Veteran
73 Posts |
 Posted - 2003-05-12 : 14:21:54
|
| HI........People working as dba,.........discuss on the daily or routine jobs u peform in the office.1)the maintenence checks u perform...2)??????????Thanx |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-05-12 : 14:26:09
|
| Whatever's needed in the environment.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
purisqlserver
Yak Posting Veteran
73 Posts |
Posted - 2003-05-12 : 14:30:24
|
| thanx for reply........do list out the regular checks u perform........... |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-05-12 : 16:18:04
|
| Well you can check whether there is space on servers, whether jobs are running for too long, whether users are connected, whether jobs succeeded successfully, did backups run, did test restores of backups run, ...But you should really just check whether the monitoring task you have built is running.Then your time can be spent productively on new work requests.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2003-05-13 : 01:15:01
|
Nigel,You forgot:Check SQLTeam forums for unanswered questions  that seems to be one of the more popular tasks.-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
|
|
|
franco
Constraint Violating Yak Guru
255 Posts |
Posted - 2003-05-13 : 10:23:14
|
| I just love this quote:"If a DBA maintains proper backups and can guarantee recovery of data up to the point required by the business process, they have done the job they were hired for. A solid backup plan is the first thing a DBA is required to do. If a DBA does absolutely nothing else in your company, he/she has earned their money by providing a solid backup plan and protecting your data. Every other activity is a simple bonus on top of this."Franco |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-05-13 : 14:20:46
|
| [quote]I just love this quote:"If a DBA maintains proper backups and can guarantee recovery of data up to the point required by the business process, they have done the job they were hired for. A solid backup plan is the first thing a DBA is required to do. If a DBA does absolutely nothing else in your company, he/she has earned their money by providing a solid backup plan and protecting your data. Every other activity is a simple bonus on top of this."[quote]I should get paid lots more then. I doubt they'll agree though.Tara |
|
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2003-05-13 : 15:48:17
|
| a few more.Performance TunningArchitectureData ModelingData ConsolidationData Mining/WarehousingTeaching developers how to write T-SQL instead of using 500 inserts per data entry form.Porting from Oracle, DB2 to SQL ServerPorting from SQL Server 6.5,7, to 2000 and soon Yukon. |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-05-13 : 16:06:08
|
| Drinking BeerBrett8-) |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-05-13 : 18:45:26
|
quote:
Drinking BeerBrett8-)
My number one responsibility!  Also monitoring production is a big part of a DBA's responsibility. It's probably the most important part but is also the one that doesn't get done as often as other tasks.Tara |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-05-13 : 20:32:46
|
| Assess the risks.Laugh and drink beer.Apply emergency measures to reduce major risks.Worry and drink beer.Apply procedures to eliminate risks.Feel smug and drink beer.Correct problems that the new procedures have uncovered.Not much work to do now so drink beer and find another job.Or wait for the current management to change and get sacked because the new people don't know what a state it was in and think you're not doing anything useful.Accept lots of free beers when they ask you back to sort out the mess in a few months.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
routine job of dba