Here’s a list of the books I’m currently lugging from pillar to post. I keep a box full of ‘em in the back of the car – very handy, given my nomadic working life. I’ll be updating this list over time, and am hoping to get round to writing some proper reviews. And I’ll be reclaiming my Prince2 books from a colleague and adding them to The Box soon.
Klein & Roggero, “Pro SQL Azure“, ISBN: 9781430229612. A slim (< 300 pages) introduction to SQL Azure, assumes knowledge of T-SQL & SQL DBA experience. Which, given the title, is reasonable. I’ve got most of the way through it, and it’s mostly familiar stuff, but does highlight the need to think carefully about database design for the Cloud.
SQL Server 2008
Horninger et al “The Real MCTS SQL Server 2008 Exam 70-432“, ISBN: 9781597494205 – a Prep Kit for the MCTS exams. I really must get round to getting myself certified (although there are that say that I am certifiable already…)
A battered and coffee-stained copy of Bolton, Langford, Ozar, Rowland-Jones & Wort’s seminal tome “Professional SQL Server 2008 Internals and Troubleshooting“, ISBN: 9780470484289. If you haven’t got this book and you’re a SQL Server DBA, then shame on you. It’s a very handy reference to the more interesting bits of SQL Server administration, and it’s written by Microsoft Certified Masters of the SQL Server dark arts. (Well, at least one MCM and *gasp* and MCA…)
Itzik Ben-Gan et al, “Inside Microsoft SQL Server 2008: T-SQL Querying“, ISBN: 9780735626034. I picked this one up at a SQL Server User Group meeting – it’s worth going to these things for the swag! Haven’t had a chance to go through it yet, but a quick flick through does show an amount of useful material on the newer features, which will come in handy.
SQL Server 2008 – SSIS/SSRS/SSAS etc
I have a quartet of books covering most of the “business intelligence” functionality within SQL Server. I picked them up while having a spot of difficulty with a SSIS/SSRS implementation recently, and between them they sorted me out. I’ve not really needed to refer to them since, so don’t ask for in-depth information about the contents.
“Delivering Business Intelligence with Microsoft SQL Server 2008“, by Larson, ISBN: 9780071549448. A useful summary covering the three aspects of BI.
“Professional Microsoft SQL Server 2008 Integration Services“, by Knight et al, ISBN: 9780470247952.
“Microsoft SQL Server 2008 Reporting Services“, by Larson, ISBN: 9780071548083. Follows on (in depth) from the “Delivering BI” book above.
“Microsoft SQL Server 2008 Analysis Services Unleashed”, by Gorbach, Berger & Melomed, ISBN: 9780672330018.
SQL Server 2008 & Powershell
My main reference is “Microsoft SQL Server 2008 Administration with Windows PowerShell“, ISBN: 9780470477281, by Muthusamy & Pan. Recommended by various people on Twitter after I asked. Contains lots of useful scripts for monitoring as well as administering.
SQL Server 2005
What, no SQL 2005 books? Strewth.
SQL Server 2000
The depressing things with these books are (1) how many SQL Server 2000 instances I still look after even in 2011, and (2) how cheap some of these books are now!
Kalen Delaney’s “Inside Microsoft SQL Server 2000“, ISBN: 0735609985. Why? Because I’m having to remember all sorts of SQL Server 2000 tricks that I’ve not had to use for a very long time, and this book is the largest reference I have on the subject.
As a side work to that, I also have Edward Whalen et al on “Microsoft SQL Server 2000 Performance Tuning“, ISBN: 0735612706. I’ve not yet made much reference to this this year, but I’ve got this horrible feeling I’ll be needing it in the next few months.
I also have a copy of Timothy Peterson’s “Microsoft SQL Server 2000 DTS“, ISBN: 0672320118. This came in handy when I was first using DTS a decade or so ago.
I have, somewhat carelessly in retrospect, lent my copy of Stanek’s excellent “Microsoft SQL Server 2000 Administrator’s Pocket Consultant” to a colleague who has been looking for a handy reference work to help him with the odd bit of SQL Server support he has to deal with. This is a very useful little book…
Non-specific SQL books
I have a couple of books from Red Gate Software. One thing that annoys me about Red Gate is the way they hide their books away from the main site – there’s no obvious link to find them!
“Defensive Database Programming“, ISBN: 9781906434496, by Alex Kuznetsov. This is covers off various ways of making your database more robust and protecting it against coding errors. Very handy, and should be compulsory reading for any SQL Server developer.
“SQL Server Team-based Development“, ISBN: 9781906434595, by “Phil Factor”, Grant Fritchey, Alex Kuznetsov and Mladen Prajdic. Includes tips on documentation and controlled releases, I wish that I had had this in my arsenal many years ago. This is another one that should be compulsory reading.
An autographed copy of “SQL in a Nutshell“, ISBN: 9780596518844, by Kline, Kline and Hunt. The first of those Klines is Kevin E Kline, of Quest Software. The book covers various dialects of SQL (as in the Structured Query Language) – MySQL, Oracle, PostgreSQL and SQL Server. Alas, no Informix. I suppose they want to keep the book relatively lightweight (or as light as any 550+page book can be), and concentrate on the most popular systems.
Thomas “SQL Rockstar” LaRock’s (blog|twitter) “DBA Survivor: Become a Rock Star DBA“. This is a slim volume, aimed at the new DBA, and is possibly the only DBA handbook that includes tips on nutrition and a section heading with added bacon.
Another volume I carry is Bob Walsh’s “Clear Blogging“, ISBN: 9781590596913. Bob is an ex-journalist, ex-micro-ISV and author of books on the Micro-ISV business. This “Clear Blogging” book is a look at professional blogging – keeping things clean and tidy – and presenting a suitable image through the blog. Bob has moved on now into consulting with smaller businesses to get a clear easy-to-use web presence. I should disclose that I was the technical reviewer for this book.
Finally, the somewhat heavy-going “IT Governance – A Manager’s Guide to Data Security & BS 7799/ISO 17799“, ISBN: 0749440783. This is an Open University course text for their “M886 – Information Security management” course that I studied once upon a time.