Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Be a good Database Administrator? Expand / Collapse
Author
Message
Posted Saturday, October 4, 2008 5:26 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, October 7, 2008 1:03 PM
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.
Post #580781
Posted Saturday, October 4, 2008 5:48 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, April 21, 2009 3:30 PM
Points: 40, 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.
Post #580786
Posted Saturday, October 4, 2008 7:40 PM


Keeper of the Duck

Keeper of the Duck

Group: Moderators
Last Login: Friday, November 14, 2014 7:14 AM
Points: 6,625, Visits: 1,876
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, CISA, MCSE, Security+, MVP - SQL Server
Regular Columnist (Security), SQLServerCentral.com
Author of Introduction to SQL Server: Basic Skills for Any SQL Server User
| Professional Development blog | Technical Blog | LinkedIn | Twitter
Post #580799
Posted Sunday, October 5, 2008 8:41 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, October 7, 2014 2:38 PM
Points: 209, Visits: 642
Brian has said it all...very well put :). 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-
Post #580892
Posted Monday, October 6, 2008 7:13 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 2:01 PM
Points: 40,390, Visits: 36,823
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 2008, MVP
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

Post #581069
Posted Tuesday, October 7, 2008 7:35 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, May 10, 2013 6:46 AM
Points: 86, Visits: 145
Learn to say NO early and often

Actually I would say that the main thing is that you understand what is happening in your userbase re:DB access and head off problems before they arrive; even if they are only perception.
Post #581779
Posted Wednesday, October 8, 2008 8:59 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Sunday, November 24, 2013 7:15 PM
Points: 88, 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.
Post #582662
Posted Wednesday, October 8, 2008 2:36 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, October 10, 2008 5:34 PM
Points: 54, Visits: 221
hi,
can you share all ur experiences for all points u mentioned?
Post #582926
Posted Sunday, April 24, 2011 11:38 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, April 24, 2011 11:56 AM
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.
Post #1097919
Posted Sunday, April 24, 2011 12:00 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 2:01 PM
Points: 40,390, Visits: 36,823
Please note: 3 year old thread.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
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

Post #1097921
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse