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 |
|
learntsql
524 Posts |
 Posted - 2011-07-01 : 08:05:46
|
| Hi All,I am working as SQL Server and SSRS developer.i want to change my job and continue as a SQL DBA.I have just entry level knowledge in Administration.Could you please guide me how to start preperation subject and interview orientation.Please sugest some useful links for DBA learning.What are the core concepts required to get enter into DBA proffession.I have total 4+ yrs of experience and have some entry level knowledge in SSAS and SSIS.Please Guide me.TIA. |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-07-01 : 08:17:57
|
| SSAS and SSIS are both applications. They just happen to be bundled with sql server but aren't really anything to do with it.You need to know sql and relational theory.Apart from that it's mainly experience.Play around with a copy of sql server, see what affect things have on system tables, use sql to do everything so you know what is happening even if the gui is easier - make sure you have the ability to script anything you do.Set up replication and clusters so you can play with them and test - especially replication, I see a lot of people doing things that they think will work or have worked without realising the affect it has.Know about and test backaups and restoring/copying/recovering a system.Make sure you know what is involved in user security and the object hierarchy and mappings.Get familiar with the profiler and query plans.These would probably cover the majority of your day to day tasks.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Guide me in Change of job and technology