SQL Database Administration

Question

Post reply

SQL Database Administration

catunivdl919

SSC Rookie

Points: 28
More actions
June 11, 2015 at 6:46 am

#309096

Hi all,
I'm fairly new to the organization that I'm with but ultimately I serve in a role where I'm the systems/network admin as well as DBA. I have basic knowledge of SQL but would like to learn / develop necessary skills to be a SQL Server DBA. Can anyone suggest books/tutorials or just plain tasks that I should be concentrating on?
Thank you in advance
Peter

Viewing 7 posts - 1 through 6 (of 6 total)

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

Almighty SSCrazy Points: 2001 More actions · Answer 1

start with this

http://www.red-gate.com/community/books/accidental-dba

Quite useful

Rajan Patel Right there with Babe Points: 788 More actions · Answer 2

Almighty (6/15/2015)
start with this
http://www.red-gate.com/community/books/accidental-dba
Quite useful

Ed Wagner SSC Guru Points: 287026 More actions · Answer 3

I would start with this:

1. When are the backups taken?

2. Where are the backups stored?

3. Are the backups viable? Can they be used to restore? Have you tested them?

4. Is your sa account disabled? You want it disabled, but have to make sure it's okay.

There are a lot more questions to ask about the environment you're responsible for, this these would be the first ones on my list.

Then start going through some stairways on this site. If needed, I'd suggest starting with the one on backups. There's a book on troubleshooting for the accidental DBA at http://www.sqlservercentral.com/articles/books/76296/ that might come in handy. Remember, you don't want your first time doing something to be when you're under stress and pressure to get it done. This applies to recovering a database from backup or determining why SQL Server gives someone an error.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Jeff Moden SSC Guru Points: 1004412 More actions · Answer 4

Ed Wagner (6/15/2015)
I would start with this:
1. When are the backups taken?
2. Where are the backups stored?
3. Are the backups viable? Can they be used to restore? Have you tested them?
4. Is your sa account disabled? You want it disabled, but have to make sure it's okay.
There are a lot more questions to ask about the environment you're responsible for, this these would be the first ones on my list.
Then start going through some stairways on this site. If needed, I'd suggest starting with the one on backups. There's a book on troubleshooting for the accidental DBA at http://www.sqlservercentral.com/articles/books/76296/ that might come in handy. Remember, you don't want your first time doing something to be when you're under stress and pressure to get it done. This applies to recovering a database from backup or determining why SQL Server gives someone an error.

On item #4, I'd likely do the BSOFH thing and disable the SA account to find out if anything was using it. If they come to you about something it broke, tell them that you'll enable it for a week, which should be time for them to fix their problem. 😉

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Almighty SSCrazy Points: 2001 More actions · Answer 5

get the All SQL server under u r control. check the maintainenace task on all server . ensure valid backups are taking place . and all required acees present . and then after learning the things u can go in deep and tighten the security and all ..

start with the book i mentioned at the start. u will be in good shape after u finished thhat

catunivdl919 SSC Rookie Points: 28 More actions · Answer 6

Thank you all for the tips. I will follow your steps and I have already downloaded a copy of the book. Should have a report back soon.... Again, Thank you!