SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Be a good Database Administrator?


Be a good Database Administrator?

Author
Message
ahmedbilly2000-898938
ahmedbilly2000-898938
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 10
Hello everybody i'am new in Database (sql server) so i need an advice to be a good Database Administrator.
Thanks.
lgselsky
lgselsky
Valued Member
Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)Valued Member (72 reputation)

Group: General Forum Members
Points: 72 Visits: 77
I am also a new database administrator. My approach is to focus on the basics at first ... backups, maintenance and the like. Make sure the basic functionality is covered for your databases in a reliable manner and be sure that you understand enough about these functions and your environment so that you can respond in that inevitable crisis situation. Learn the functions and practice them.
K. Brian Kelley
K. Brian Kelley
Keeper of the Duck
Keeper of the Duck (43K reputation)

Group: Moderators
Points: 43388 Visits: 1917
If you're speaking of what's considered an operational DBA, there are a few basics:

Backup / Restore:
- Understand the backup / restore options SQL Server provides for you.
- Implement those on your databases to meet your users' needs.
- Test those backups regularly to make sure they are good and to give you an idea of how long the restores take.

Configuration / Performance (OS):
- Understand the various types of RAID and how those can impact your performance.
- Understand how to deploy SQL Server on those RAID configurations to meet cost vs. performance.
- Understand how to measure performance on your SQL Servers (CPU, memory, disk I/O).
- Understand what can cause bottlenecks on those areas.

Configuration / Performance (SQL Server):
- Understand clustered vs. non-clustered indexes and what situations to apply them.
- Understand statistics and how to keep them up to date.
- Understand how to determine when indexes are needed and when they're not.
- Understand how to deploy database and log files to maximize the performance of the disk.

Growth / Capacity Planning:
- Understand how to measure the growth of your databases.
- Understand how to forecast growth over time.
- Understand how to communicate your growth needs to management before it's critical.

Security (SQL Server):
- Understand the difference between users/logins
- Understand how to determine what permissions a login has, down into each database.
- Understand ownership chaining.
- Understand how to get a user the rights that are needed, no more and no less.

K. Brian Kelley
@‌kbriankelley
DHeath
DHeath
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1581 Visits: 657
Brian has said it all...very well put Smile. Of course i will add my .02 from my experience. Make sure you have some broad shoulders and a good knowledge of pretty much EVERY aspect of your system. I am sure that many will agree that when the backups are slow, or applications are running poorly, or networks are running slow, etc... the first stop it appears for EVERY one is the DBA(they will come to you with the problem because data is high on the list). Not only will your prove your data is or is not the problem but your input is quite often wanted for the repair EVEN if its not your field of expertise. Like I was saying Brian is right on the numbers with everything he's quoted..print it and use it as a guideline now and later in your career.

Good Luck

-D-
GilaMonster
GilaMonster
SSC Guru
SSC Guru (413K reputation)SSC Guru (413K reputation)SSC Guru (413K reputation)SSC Guru (413K reputation)SSC Guru (413K reputation)SSC Guru (413K reputation)SSC Guru (413K reputation)SSC Guru (413K reputation)

Group: General Forum Members
Points: 413737 Visits: 47124
I'll add one more to the list.

Disaster recovery
- Know how to fix corruption
- Know what to do when someone drops a table (though if you've done the security right, that shouldn't be possible)
- Know how to restore to any point given your backup strategy
- Practice various scenarios so that if something does happen, you know exactly what to do.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass


john-902052
john-902052
Mr or Mrs. 500
Mr or Mrs. 500 (544 reputation)Mr or Mrs. 500 (544 reputation)Mr or Mrs. 500 (544 reputation)Mr or Mrs. 500 (544 reputation)Mr or Mrs. 500 (544 reputation)Mr or Mrs. 500 (544 reputation)Mr or Mrs. 500 (544 reputation)Mr or Mrs. 500 (544 reputation)

Group: General Forum Members
Points: 544 Visits: 145
Learn to say NO early and often w00t

Actually I would say that the main thing is that you understand what is happening in your userbase reBigGrinB access and head off problems before they arrive; even if they are only perception.
jamesvgeorge
jamesvgeorge
SSC Veteran
SSC Veteran (258 reputation)SSC Veteran (258 reputation)SSC Veteran (258 reputation)SSC Veteran (258 reputation)SSC Veteran (258 reputation)SSC Veteran (258 reputation)SSC Veteran (258 reputation)SSC Veteran (258 reputation)

Group: General Forum Members
Points: 258 Visits: 93
For starters get some good sql server book and read from cover to cover. In my experience this will definitely help as most of the problems that DBAs face are because of ignorance.
bang.prashant
bang.prashant
SSC Veteran
SSC Veteran (290 reputation)SSC Veteran (290 reputation)SSC Veteran (290 reputation)SSC Veteran (290 reputation)SSC Veteran (290 reputation)SSC Veteran (290 reputation)SSC Veteran (290 reputation)SSC Veteran (290 reputation)

Group: General Forum Members
Points: 290 Visits: 221
hi,
can you share all ur experiences for all points u mentioned?
Derek_Wallace
Derek_Wallace
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 6
Hi, I was the SQL Server DBA for two factories running SQL Server in a clustered environment. We had a thruput of 900 transactions per second. Implemented DR and replication using a central distributor. I would agree with all the advice given earlier. So apart for what has been said and stating the obvious read as much as you can on SQL Server - STAY FOCUSED at all times. Don't get lazy. Always be aware of your environment and keep on top of it. A good tool to give you a heads up on potential problems is Spotlight. Hope my input is of use to you going forward. :-)
GilaMonster
GilaMonster
SSC Guru
SSC Guru (413K reputation)SSC Guru (413K reputation)SSC Guru (413K reputation)SSC Guru (413K reputation)SSC Guru (413K reputation)SSC Guru (413K reputation)SSC Guru (413K reputation)SSC Guru (413K reputation)

Group: General Forum Members
Points: 413737 Visits: 47124
Please note: 3 year old thread.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass


Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum







































































































































































SQLServerCentral


Search