SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Suggest me....!
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

ajaxneil
Starting Member

India
5 Posts

Posted - 07/26/2012 :  05:00:17  Show Profile  Reply with Quote
I am working as a Erp Technical consultant from last 1 year i.e. based on sql server,where i have to perform erp activities as a support as well as some dba activities also on daily basis.I am comfortable with sql stored procedures,triggers,views/database backup,restoration,performance tuning.
But i wish to make my career in Database administration as a SQL DBA.
Please suggest me what i have to do for that.

Neel Ratna Singh

lionofdezert
Aged Yak Warrior

Pakistan
885 Posts

Posted - 07/26/2012 :  05:10:23  Show Profile  Visit lionofdezert's Homepage  Send lionofdezert a Yahoo! Message  Reply with Quote
First thing you must have knowlege about, what type of actions you will perform for differnt tasks. Like for point in time recovery you must have transactional log backups and before that you must change database recovery mode to FULL etc.
Sconds thing which is necessary is SQL Server Internals. You must know, how SQL Server actually works. That will help you have better idea about keeping things under control.

Read blogs from SQL Server Experts. Like Pinal Dave's SQLAuthority.com will help you to learn bit by bit, easily. SQL-Serve-Performance.com, SQLServerCentral.com, mssqltips.com, beyoundrelational.com etc
--------------------------
http://connectsql.blogspot.com/

Edited by - lionofdezert on 07/26/2012 05:13:45
Go to Top of Page

ajaxneil
Starting Member

India
5 Posts

Posted - 07/26/2012 :  05:39:51  Show Profile  Reply with Quote
Thanx lionofdezert.........!
Will you please send me the link of database administration videos.

Neel Ratna Singh
Go to Top of Page

lionofdezert
Aged Yak Warrior

Pakistan
885 Posts

Posted - 07/26/2012 :  05:43:30  Show Profile  Visit lionofdezert's Homepage  Send lionofdezert a Yahoo! Message  Reply with Quote
http://www.youtube.com/user/pinaldave
http://www.sqlshare.com/

Search more on youtube according to your interest

--------------------------
http://connectsql.blogspot.com/
Go to Top of Page

Lica
Starting Member

Afghanistan
1 Posts

Posted - 07/26/2012 :  07:25:03  Show Profile  Reply with Quote
If you to make my career in Database administration you have to aware with these points

Installation, configuration and upgrading of Database server software and related products.
Evaluate Database features and Database related products.
Establish and maintain sound backup and recovery policies and procedures.
Take care of the Database design and implementation.
Implement and maintain database security (create and maintain users and roles, assign privileges).
Database tuning and performance monitoring.
Application tuning and performance monitoring.
Setup and maintain documentation and standards.
Plan growth and changes (capacity planning).
Work as part of a team and provide 24x7 support when required.
Do general technical troubleshooting and give cons.
Database recovery.

unspammed
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000