Hi All, I'm working as a S/W support engineer. I would like to become a SQL DBA. I'v worked with Back-Up/Restore, DTS, Creating Databases in sql 2000 server. I'm planing to join SQL Server 2008 courses & certification. Pls advice on this.
asked Jan 08 '10 at 01:12 PM in Default
READ, READ, READ!
Read books, blogs, magazines, Books OnLine, and everywhere else. Immerse yourself in it.
Ask yourself a few questions.
Why does SQL interest you?
The big thing is to be sure that this is the path you want to follow and not a flavour-of-the-month pursuit. If you try you may find that it becomes incredibly rewarding, but it isn't for everybody. Sometimes the expectations will not match reality - be prepared for that.
Certification is a "nice to have" but it depends on your organization... and if you intend to stay there. As long as you approach certification as an I'm doing this for me instead of an I want a piece of paper exercise you are on your way. For me the knowledge and inner workings has always come first, the certification is just a nice by-product.
answered Jan 08 '10 at 02:11 PM
I second both Matt's and Kev's suggestions, those are some very good places to read. But there are a couple of things I think are worth emphasizing.
First, be careful about what courses you take. Some are certainly very good, but I think most of them are a waste of money. You are better off if you can find an experienced DBA to mentor you, but even if you can't a combination of reading books, reading internet articles (both http://www.sqlservercentral.com and http://www.simple-talk.com are fantastic), and most importantly testing things on your own is much better and much cheaper than taking a course.
Second, you probably will and should focus first on the practical aspects of learning how to use SQL such as learning actual T-SQL, SSMS, SSIS etc, but if you want to be good you should eventually go back and learn the theoretical underpinnings as well. It can be useful to know how the indexes work behind the scenes at times and even if you do not normalize to 3NF it is good to know what it is and how to do it if you need to.
And finally, learning another scripting language in addition to T-SQL can be very helpful. I am a big fan of Python (including IronPython) personally, but PowerShell is also popular and there are also many other fine choices. As an administrator, there are advantages to having a good scripting language handy.
..and apart from reading from the exellent sources suggested, install your own copy of SQL Server express, or the eval version, so that you can play around with it and test the things you read about. Atleast for me that helps with remembering what I read.
answered Jan 11 '10 at 06:26 AM