Accelerated SQL Server 2008 (Expert's Voice) [Paperback]

Rob Walters (Author), Michael Coles (Author), Fabio Claudio Ferracchiati (Author), Robert Rae (Author), Donald Farmer (Author)

Book Description

ISBN-10: 1590599691 | ISBN-13: 978-1590599693 | Publication Date: May 23, 2008 | Edition: 1

Accelerated SQL Server 2008 is a fast introduction to SQL Server 2008 for experienced database professionals. The book appeals to readers who are smart, who learn fast, and who do not want to wade through a large amount of introductory material. The goal is to impart the essentials of using SQL Server 2008 as quickly as possible.

Editorial Reviews

About the Author

Rob Walters is a program manager in the SQL Server group of Microsoft. He has seven years of experience in software development and relational databases.

Robin Dewson has been hooked on programming ever since he bought his first computer, a Sinclair ZX80, in 1980. He has been working with SQL Server since version 6.5 and Visual Basic since version 5. Robin is a consultant mainly in the city of London, where he has been for nearly eight years. He also has been developing a rugby-related website as well as maintaining his own site at www.fat-belly.com.

Jan D. Narkiewicz is chief technical officer of Software Pronto, Inc. His areas of expertise include Microsoft technologies, Oracle, and DB2. Jan also write books for Apress and serves as academic coordinator for U.C. Berkeley Extension’s .NET/Windows program. His clients include E*Trade, Visa, eBay, and Oracle.

Other author bios not yet available

Product Details

• Paperback: 816 pages
• Publisher: Apress; 1 edition (May 23, 2008)
• Language: English
• ISBN-10: 1590599691
• ISBN-13: 978-1590599693
• Product Dimensions: 9.3 x 7.1 x 1.6 inches
• Shipping Weight: 2.9 pounds (View shipping rates and policies)
• Average Customer Review: 3.6 out of 5 stars  See all reviews (8 customer reviews)
• Amazon Best Sellers Rank: #484,895 in Books (See Top 100 in Books)

Customer Reviews

Most Helpful Customer Reviews

10 of 10 people found the following review helpful:

4.0 out of 5 stars What I needed, when I needed it.., March 20, 2009

By 

Mark L. McHugh "dbaMark" (Atlanta) - See all my reviews
(REAL NAME)   

This review is from: Accelerated SQL Server 2008 (Expert's Voice) (Paperback)

In support of a current project, I was searching for whatever books I could find to help me with SQL Server 2008. This is one of the first available "credible" books I found. Credible since I have a number of other APRESS technical books that I found useful, and credible since the authors list certainly fit the lead-in on the cover - "The Experts Voice in SQL Server".

I found this book to be exactly what the title says (Accelerated) and exactly what I needed for my project effort. Let me explain - I have a significant background in database administration, and had worked on literally hundreds of SQL Server 2000 related projects. But due to job focus on other responsibilities, my exposure to SQL Server 2005 was limited to a couple of projects. So when this high profile SQL 2008 project came along, I really needed something to quickly jumpstart my learning.

As I went through the installation and the configuration of the database engine, analysis services, reporting services, and integration services in my environments, I used all the associated chapters in this book. It gave me the pertinent information, the important differences and improvements, without bogging me down in the basic things I felt I already knew.

I felt that the first 13 chapters covering primarily the database engine and associated features - Installation, Policy, Availability, Performance, Security, Monitoring, Service Broker, Full Text Search, and TSQL enhancements were very complete and excellent resource for someone with experience looking for a jumpstart. I don't see myself buying another book to supplement this knowledge - forums and whitepapers will probably be all that I will need - in the short term at least.

I admit that I skimmed the chapter or two on .Net integration and programming assemblies - but I will be back to it in a couple of weeks to be sure.

Since this current project requires a good deal of XML based data integration between our existing world and this new application - the chapters on XML and XQuery were of particular interest to me. I found them a valuable and complete introduction. The next few months of the project will show how valuable this really was, but I came away feeling pretty good about what we might be able to do to leverage this.

Because my work for the past couple of years has been focused on BI, I went through those last three chapters covering Business Intelligence (analysis server, reporting services, integration services) multiple times. First to do the installation and configuration, second to see what I was that I missed, and a final time to understand what I thought the authors had missed. This section provides a good basic intro to the products, and gives you what you need to get them setup and functional. To exploit them however, you will need to look for further resources.

You can look at this book as a focused set of expert recommendations, advice, and key bullet points around its 3 major divisions - the Enterprise data platform (I rate it excellent in that coverage), development in SQL Server (I'd rate it good, but I know I need to read it again), and Business Intelligence (I'd rate it useful, but basic in the coverage).

What this book is not, is an in-depth and complete coverage of all the specifics of each of the SQL 2008 vertical product features. If your primary interest is in one of those features outside the database engine itself - Reporting Services or Analysis Services, you will need to follow this book up with one of the detailed and targeted books.

At the end of the day - this book gave me exactly what I needed, when I needed it. That makes it a good book in my view, a keeper for my top bookself, and one I can recommend to others in similar circumstances.

6 of 6 people found the following review helpful:

4.0 out of 5 stars I just expected better..., September 21, 2008

By 

Rob Farley - See all my reviews

This review is from: Accelerated SQL Server 2008 (Expert's Voice) (Paperback)

I saw this book come out, and had high expectations. The authors are all great guys who really know their stuff. What's more, Donald Farmer is _the_ guy for Data Mining, so I was hoping for a big section about the improvements in that area for SQL 2008.

Looking through it though, it feels like a book that was written for SQL 2005 that just got updated a little for SQL 2008, and that wasn't what I was wanting. And to boot, there are things that are just plain missing. There's not a single page on Data Mining, and some of my favourite features just don't appear. For Xmpl, in the FOR XML section, there's no mention of FOR XML PATH at all - which has to be the best way of using FOR XML.

However, I will still recommend this book. I will recommend this book to people who are moving from SQL 2000 and want to know what's new in both SQL 2005 and 2008, but there is a better reason again:

It's really honest! It's written by Microsoft guys, and they give really frank opinions about things. There are times when they happily point out that one feature or another isn't really as useful as it sounds. It's the kind of thing that more books need.

10 of 12 people found the following review helpful:

4.0 out of 5 stars Very misleading title!, June 18, 2008

By 

Mr. Ian W. Stirk (London) - See all my reviews
(REAL NAME)   

This review is from: Accelerated SQL Server 2008 (Expert's Voice) (Paperback)

I've just finished reading the "Development in SQL Server" section of this book (i.e. 40% of the total book).

I assumed the book related solely to SQL Server 2008. The book's introduction, forward, back cover content, and free downloadable chapter 1 led me to that belief.

However, the book relates to both 2005 and 2008, and frustratingly it typically does not say what features belong to which database version.

I wanted a book that showed me what was new in SQL Server 2008, I know what is in 2005, I have several books on it! I think the publishers etc have been very misleading with this book's title.

That said, the content of the book is very good.

The book is large (784 pages) and heavy. A book containing SQL Server 2008 only content would perhaps contain only 300 pages, and be more convenient to read and carry.

The book's real title is "Accelerated SQL Server 2005 and 2008"