What is the most important thing to take a DBA job

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.

All Forums

General SQL Server Forums

New to SQL Server Administration

What is the most important thing to take a DBA job

Author

Topic

tony4SQL
Starting Member

2 Posts

Posted - 2011-03-02 : 10:56:19

I just got an offer from a small company. 10% of my workload will be DBA role. I have passed the MCTS exam but have a little DBA work experience. What are the most important things I need to know during the the job transfering?

Thanks a lot!

Tony

X002548
Not Just a Number

15586 Posts

Posted - 2011-03-02 : 11:26:02

Makes sure the have backups running, and t log dumps

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/

ajthepoolman
Constraint Violating Yak Guru

384 Posts

Posted - 2011-03-02 : 11:29:24

Oh man, I was hoping that Brett would have some witty response about learning to blame the network admin or to have a catalog of wordy responses memorized that would imply that someone else broke the database!

Hey, it compiles.

X002548
Not Just a Number

15586 Posts

Posted - 2011-03-02 : 11:48:45

Pool Dude!!!

OK...

"It was like this when I got here..."

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/

ajthepoolman
Constraint Violating Yak Guru

384 Posts

Posted - 2011-03-02 : 11:59:26

Thats more like it!

Hey, it compiles.

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2011-03-02 : 16:25:08

Everything you are going to need to know is clearly explained here:
http://sqldumbass.com/

CODO ERGO SUM

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2011-03-02 : 17:12:15

#1 Backup and Restore.
#2 Backup and Restore.

Then make yourself an expert on SQL Internals (particularly storage), Indexes, and T-SQL. You'll be expected to be able to resolve performance issues, and write T-SQL code that the developers aren't good enough to write. And to optimize what they did write. Understand performance indicators, what and how to measure/monitor.

robvolk
Most Valuable Yak

15732 Posts

Posted - 2011-03-02 : 17:33:37

Learn how to make backups WITHOUT using maintenance plans. In fact, learn to make them without using the GUI, just plain ol' T-SQL. Learn how to restore them the same way, and do regular restores against another SQL Server to ensure the backups are valid.

tony4SQL
Starting Member

2 Posts

Posted - 2011-03-02 : 19:23:16

First of all, thanks everybody who read and replied my post. Regular backup and restore is not difficulty for me. Is there any special steps to backup and restore a database with replication (snapshot) on it? How can I find out and monitor all jobs runing on database server?

quote:
Originally posted by Michael Valentine Jones

Everything you are going to need to know is clearly explained here:
http://sqldumbass.com/

CODO ERGO SUM