First day as a DBA

Question

Post reply

First day as a DBA

Ivelisse Maldonado

Old Hand

Points: 372
More actions
September 27, 2005 at 7:59 pm

#166094

If anyone can offer some advise, on what are the things that one should check for on their first day as a dba any documentation we be appreciated.
Thanks.

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Ray M SSC-Insane Points: 21093 More actions · Answer 1

Well it depends on your roll. Are you an administration dba in charge of backups, recovery, availability, security?

or are you a development dba that is in charge of creating objects writing code?

Both?

You need to hunt for documentation. If it doesn't exist push for / volunteer to create it. it will help you asess what exists and available. familiarize yourself with backup/recovery plans.

raj-247939 SSCertifiable Points: 5999 More actions · Answer 2

Hi,

If today is ur first day as a DBA .

Start like this:

(i) Database name and Service pack.

(ii) No of Databases and mode of Recovery.

(iii) No of Tables, Views and Indexes.

(iv)Available Space on Disk.

(v) List of user stored procedures.

(vi) No of usres and security issues.

(vii) Backup Maintinance Plan

(viii) Scheduled Jobs.

In this way u can start.

hope u will find better way.

from

Killer

Ivelisse Maldonado Old Hand Points: 372 More actions · Answer 3

Ivelisse Maldonado

Old Hand

Points: 372

September 27, 2005 at 10:19 pm

#593530

Thanks, this helps.

Ivelisse Maldonado Old Hand Points: 372 More actions · Answer 4

It will be in every aspect of administration. Any suggestion helps.

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 5

This may help you :

http://www.sqlservercentral.com/columnists/bknight/dbaroles.asp

http://www.sqlservercentral.com/columnists/sjones/whatsadbaanoverview.asp

http://www.sqlservercentral.com/columnists/sjones/thevalueofadba.asp

http://www.sqlservercentral.com/columnists/jyao/howtobeagooddbastrategyandtactics.asp

Ivelisse Maldonado Old Hand Points: 372 More actions · Answer 6

Ivelisse Maldonado

Old Hand

Points: 372

September 28, 2005 at 7:16 am

#593647

Thanks, I will read through the articles.

Vee Hall of Fame Points: 3028 More actions · Answer 7

Hi Ivelisse Maldonado

Thanks to raj for Providing the following information..U can Use

Start like this:

(i) Database name and Service pack.

(ii) No of Databases and mode of Recovery.

(iii) No of Tables, Views and Indexes.

(iv)Available Space on Disk.

(v) List of user stored procedures.

(vi) No of usres and security issues.

(vii) Backup Maintinance Plan

(viii) Scheduled Jobs.

Apart from these i would like add some more point...

if U r co-ordinating with the development team.. or in the development team..

1> Follow Constistant object naming convention..

2> Use sensible datatypes ..and tell others to do the same, it makes a lot of sense..

3> Dont give create statement permission to all the members in the team , let the creation of each object is decided by team leader or by u.

I think i made some sense here

cheers

raj-247939 SSCertifiable Points: 5999 More actions · Answer 8

Hi Veeresh,

U really added important thing.

hope this help the guy.

from

Killer

Ivelisse Maldonado Old Hand Points: 372 More actions · Answer 9

Ivelisse Maldonado

Old Hand

Points: 372

September 29, 2005 at 7:05 am

#594012

Thank you for the information.