February 11, 2011 at 7:39 am
I recently accepted a SQL server Production DBA job. For my current job, I'm doing quite a few database integration, some database development, and some database admin.
But the new job will go deep into production server DBA and manage many more servers.
I guess most of the time will do trouble shooting and performance tuning and other everyday DBA maintainance jobs.
What should I start to prepare for that? Couldl everyone please suggest some best DBA books or resources? some senior level one too, or website?
Thanks a lot.
--------------------------------------------------------------------------------
February 11, 2011 at 7:45 am
It would depend a bit if it is 2005 or 2008 but I will recommend...
SQL Server 2008 Query Performance Tuning Distilled -- Fritchey
SQL Server 2008 Internals -- Delaney et al.
An exam review book for the version you are going to be working with.
SQL Server Team-based Development -- Factor, Fritchey, Kuznetsov, et al.
Defensive database programming -- Kuznetsov (helps you explain to your developers why not to do some stuff)
February 11, 2011 at 9:01 am
I'd absolutely go with the Internals book by Kalen Delaney.
After that, it really depends on what your primary problems are. Make sure you make use of this place. there are amazing people here who can figure out just about anything. for short, sharp questions, consider using ask.sqlservercentral.com. For really short questions, there's always the #sqlhelp hashtag on twitter.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 11, 2011 at 9:02 am
Henry Treftz (2/11/2011)
It would depend a bit if it is 2005 or 2008 but I will recommend...SQL Server 2008 Query Performance Tuning Distilled -- Fritchey
SQL Server 2008 Internals -- Delaney et al.
An exam review book for the version you are going to be working with.
SQL Server Team-based Development -- Factor, Fritchey, Kuznetsov, et al.
Defensive database programming -- Kuznetsov (helps you explain to your developers why not to do some stuff)
Thanks for the plugs!
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 11, 2011 at 9:13 am
Thanks all for your suggestions.
I will order the SQL server Internals and Trouble shooting right away.
I like sql server so much is because it seems there are so many learning reources on line, I can learn from others. But sometimes just not sure where to start. I'm glad that my career path will focus on DBA and but a little bit scared.
I will for sure learn a lot from this site.
Thanks again
February 11, 2011 at 9:16 am
I'd start with this: http://sqlskills.com/BLOGS/PAUL/category/Involuntary-DBA.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 11, 2011 at 9:37 am
Thank you.
I just did a search for Sql server internals, I got two books.
the Microsoft SQL Server 2008 Internals (Pro - Developer)
Does this mean a book for developer?
There is another one called SQL Server Internals and Troubleshooting.
What is the best one for a production DBA?
Thanks
February 11, 2011 at 10:22 am
Anna_SQL (2/11/2011)
Thank you.I just did a search for Sql server internals, I got two books.
the Microsoft SQL Server 2008 Internals (Pro - Developer)
Does this mean a book for developer?
There is another one called SQL Server Internals and Troubleshooting.
What is the best one for a production DBA?
Thanks
They are both very good, I couldn't choose so I bought both 🙂
Ignore the "pro-developer" on SQL 2008 Internals by Kalen Delaney, that is the book the previous posters we referring to.
It's probably worth you going through the "Look inside" feature on Amazon and seeing which one you think would benefit you most at this stage by looking atthe table of contents.
I would recommend having a look at this one too:
Here's a free e-book too by Brad McGehee, which is more general about being a good DBA rather than full of technical information :
http://www.sqlservercentral.com/articles/books/67441/
Good luck with the new job! I made the switch from dev to DBA just over a year ago and am much happier now, hope it works out the same for you
February 11, 2011 at 10:43 am
Thanks, Old Hands.
It is good to know that you are happy with your DBA jobs. I hope I like it too.
For the book, you said ignore pro-develop, not sure what you mean,
can you see for me is this the right book that I should buy?
http://www.amazon.com/Microsoft-SQL-Server-2008-Internals/dp/0735626243
thanks
February 12, 2011 at 3:14 am
Anna_SQL (2/11/2011)
For the book, you said ignore pro-develop, not sure what you mean,
I just meant ignore the fact that it says "developer" in the description.
It's a book that both developers and DBAs should read if they want to understand what SQL Server does on the inside
can you see for me is this the right book that I should buy?
http://www.amazon.com/Microsoft-SQL-Server-2008-Internals/dp/0735626243
thanks
Yes, that's the one
February 12, 2011 at 10:27 am
Thank you all
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply