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.
| Author |
Topic |
|
ajaxneil
Starting Member
5 Posts |
 Posted - 2012-07-26 : 05:00:17
|
| 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
885 Posts |
Posted - 2012-07-26 : 05:10:23
|
| 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/ |
 |
|
|
ajaxneil
Starting Member
5 Posts |
Posted - 2012-07-26 : 05:39:51
|
| Thanx lionofdezert.........!Will you please send me the link of database administration videos.Neel Ratna Singh |
|
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2012-07-26 : 05:43:30
|
| http://www.youtube.com/user/pinaldavehttp://www.sqlshare.com/Search more on youtube according to your interest--------------------------http://connectsql.blogspot.com/ |
|
|
|
Lica
Starting Member
1 Post |
Posted - 2012-07-26 : 07:25:03
|
| If you to make my career in Database administration you have to aware with these pointsInstallation, 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 |
|
|
|
|
|
|
|
|
Suggest me....!