- Series: Developer Reference
- Paperback: 800 pages
- Publisher: Microsoft Press; 1 edition (February 4, 2009)
- Language: English
- ISBN-10: 0735625808
- ISBN-13: 978-0735625808
- Product Dimensions: 7.4 x 2 x 9 inches
- Shipping Weight: 3.4 pounds (View shipping rates and policies)
- Average Customer Review: 12 customer reviews
- Amazon Best Sellers Rank: #2,179,538 in Books (See Top 100 in Books)
Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008 (Developer Reference) 1st Edition
Use the Amazon App to scan ISBNs and compare prices.
All Books, All the Time
Read author interviews, book reviews, editors picks, and more at the Amazon Book Review. Read it now
Frequently bought together
Customers who bought this item also bought
About the Author
Lynn Langit is a developer evangelist for Microsoft in Southern California. She's published three books on SQL Server Business Intelligence and has created a set of courseware to introduce children to programming at TeachingKidsProgramming.org. Read her blog at blogs.msdn.com/b/SoCalDevGal.
Top customer reviews
This book would be a good manual if you do not understand some of the key concepts (Dimension vs Measure, Star schema vs Snowflake etc). If you want to actually implement a Snowflake schema, SSIS, and customize the results, the book was lacking. In other words, the book does not focus on the nuts and bolts of SQL 2008 BI. It gives you more of a 5000 ft overview.
It doesn't help that the book has a writing style similar to a college math textbook. You may need to read many paragraphs more than once to obtain the golden nuggets of information. In books such as this, you want writers to be blunt and forthright and not meander using sophisticated prose. The book certainly could be shorter than the 700+ pages.
The writers seem to possess strong technical knowledge of SQL 2008 BI. They have much to offer in terms of key knowledge and concepts. To put it into an analogy, this is like a book that describes how a car battery works but lacks information on how to properly change the car battery.
I work for a small business (currently ~65 employees), and right now our IT Team has three members: 1 system admin, 1 full-time developer, and me (my time is split half and half between software and business management). None of us had any experience with OLAP, SQL Server Integration Services (SSIS), or SQL Server Analysis Services (SSAS) ... although I had sat through a few sessions/workshops over these topics at conferences. Although it is counter-intuitive (especially to someone who is a developer at heart), I have come to believe in the notion that the sooner you start coding the longer it will take. So, I knew I needed to get some more in-depth expertise in these areas before we started the project, which is why I ordered this book.
Before I even created the first prototype, I forced myself to sit down away from the computer and read the first two parts of the book (~400 pages). It it was eerie how much the content seemed custom-tailored to my current situation. It was targeted at a more technical audience, so the detail and depth used was spot on, and it assumed you had some working knowledge of OLTP relational databases so it didn't have to go over all the basics.
The book covers a ton of best practices that the authors have learned "the hard way" while implementing a ton of business intelligence solutions on the SQL Server framework, and most of them were not entirely obvious. The whole business intelligence area is still in its early phases, and there are a lot of gotchas. SQL Server 2008 has made some significant improvements over past implementations to help guide you to best practices, but there are still a lot of gotchas. The authors also demostrate an in-depth knowlegde on the new features SQL Server 2008 offers, plus then explain when/how you might use them.
At 624 pages, this book may seem a little overwhelming ... but I think it is worth its weight in gold. It is almost like you have an experienced consultant sitting beside you. If you are considering implementing a business intelligence solution, there are tips in this book will save you time, effort, and you will end up with a better solution for your business in the end.
To view the full review or see more reviews on technical books like this, visit: [...]
have to say, the theory is great, and help to picture what things can be achived, it smoothly says what can be done, but when the time comes to actually build a solution, it's confusing. Makes me feel the author said, "ok, let's move on, they will figure out the details, it's part of the fun", but not too much fun (for me) to be honest. bottom line, I bought another book, and this one is not in the shelf...
I purchase about 8 - 9 technical specific books a year and this is one of the best I've purchased in the last two years.