i am learnig sql server dba course plz can u guide me in proper way..
hello sir i am learning sql server 2008 dba can u guide me in proper way.. i know sql server 2005... 1) what kind of practice i need? 2)which topics i need concentrate more? 3)how it looks the real time environment?
Well darn @Grant Fritchey you didn't leave much for the rest of us to recommend. @sourav You stated that you already know SQL 2005. Going from SQL 2005 to 2008 is not a huge leap. There was a good learning curve from SQL 2000 to 2005 with Enterprise Manager and Query Analyzer changing to SSMS and the introduction of Surface Area Connection, database Mirroring, etc. From 2005 to 2008 there are not as many cosmetic changes. The Query Optimizer was enhanced, several new DMO's, etc. I would suggest picking up a book that covers the upgrades. Grants recommendation for "Beginning SQL Server Administration" is a great read as well as all his recommendations. Grant's advise for getting a copy of SQL 2008 Developer is a MUST. It is very inexpensive at $50 and you can purchase it online and download it. Your second question was which topics should you concentrate on. Well, to answer that we need to know your goals? What are you trying to achieve? Passing a certification, getting a job, learning 2008 more? Your third question was how does it look in real time, for me it looks just like 2005 with the exception of a few things that were in Surface Area Connection have been moved to a Facet. Your first question was about practice. You can only get practice from doing, so get that copy of developer and start playing with it.
To add to the great answers so far. Consider doing volunteer work, or search for a local user group and get involved there. If you can find a mentor who can show you the ropes, even better. Watch for possibilities at your current job. Do everything you can to take on any db related work, it sucks at the beginning, but you have to pay your dues. it also takes you out of the comfort zone and gets you thinking about new stuff. oh yeah, get involved here. You will learn a huge amount by participating. If you make a mistake, accept it, learn from it, move forward. Real questions and answers are worth their weight in gold IMO. Learning by doing gets you more than you'd think.