May 27, 2008 at 9:05 am
Got an email Thursday that management wants book recommendations for VB, SQL Server, OS, Crystal Reports 11, etc. to buy before the budget freeze. So I have until this afternoon to put together a list! (was off Thursday and Friday).
Right now, we're solely SS 2000, but I'm hoping to go to 2005 next year, so I'm aiming for 2005 books. We're strictly OLTP currently, but DW may be lurking in the future. Right now I've got Kalen's series along with Vaughn's Hitchhiker's book and Microsoft's SS2000 Resource Kit and Administrator's Companion and Sack's SS 2000 Fast Answers. OS-wise, we're running XP but will probably have Vista slowly infiltrating, on the server side we're mostly 2003 probably with some 2007 coming in the door.
Any "must have" recommendations would be most welcome!
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
May 27, 2008 at 11:10 am
Adam Machanic's books are excellent: Expert SQL Server 2005 Development and Pro SQL Server 2005.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 27, 2008 at 11:16 am
Thanks, I came across his first book on Amazon while working on my list and added it. I'll look up the second and it'll probably also get added.
It's kind of a tough call because my boss wants VB books, which we are not VB programmers -- we just took a course in VB that was woefully inadequate, so now we run a high risk of buying crappy books. Same thing with HTML -- we had a good web admin, but he's gone and now we have a mainframe operator maintaining our web site!
*sigh* So much fun! But if it were easy, anyone could do it. Or something like that.
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
May 27, 2008 at 11:28 am
The inside SQL Server 2000 book and the Inside SQL Server 2005 series are excellent. Kalen Delaney, Itzik Ben-Gan and others
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
May 27, 2008 at 11:58 am
A few other suggested books are:
SQL for Smarties: Advanced SQL Programming
Author: Joe Celko
Publisher: Morgan Kaufmann Publishers
ISBN-13: 978-0123693792
The Data Modeling Handbook : A Best-Practice Approach to Building Quality Data Models
Authors: Michael C. Reingruber and William W. Gregory
Publisher: Wiley
ISBN-13: 978-0471052906
SQL = Scarcely Qualifies as a Language
May 27, 2008 at 12:27 pm
I'd say Ben-Gan's Inside SQL is a must for 2005.
The others are good, and any of the admin books will work.
May 27, 2008 at 2:27 pm
Yep, got Itzik's book on the list. I'm not too sure about the Celko's, though. I appreciate him from a theoretical level, but I think since my programmers have little education in "formal" database theory, I think it might be too far over their heads at this time. I'm also a little dissatisfied at the number of typos in Joe's books, they need a new and more skilled editor IMO.
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
May 27, 2008 at 2:29 pm
Carl Federl (5/27/2008)
A few other suggested books are:SQL for Smarties: Advanced SQL Programming
Author: Joe Celko
Publisher: Morgan Kaufmann Publishers
ISBN-13: 978-0123693792
http://www.amazon.com/Joe-Celkos-SQL-Smarties-Programming/dp/0123693799
The Data Modeling Handbook : A Best-Practice Approach to Building Quality Data Models
Authors: Michael C. Reingruber and William W. Gregory
Publisher: Wiley
ISBN-13: 978-0471052906
http://www.amazon.com/Data-Modeling-Handbook-Best-Practice-Approach/dp/0471052906
Thanks, Carl. I hadn't considered data modeling books, probably would be a good idea. I'm not sure about the Celko books, though. I mention my objections in another post.
FYI, you can shorten Amazon URLs by cutting them after the first set of numbers after the title.
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply