Microsoft SQL Server 2008 Analysis Services Unleashed 1st Edition
Use the Amazon App to scan ISBNs and compare prices.
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.
From the Back Cover
As the foundation of the Microsoft Business Intelligence Strategy, Microsoft SQL Server 2008 Analysis Services provides users with faster access to data and even more tools for managing and analyzing data across multidimensional objects (databases, dimensions, cubes).
Microsoft SQL Server 2008 Analysis Services Unleashed is the ultimate guide for anyone who is planning to use the latest version of Analysis Services. It gives readers insight into the way Analysis Services functions, and explains practical methods for designing and creating multidimensional objects. It also provides valuable insight into the reasons behind the design decisions taken by the product development team. The authors have been involved with Analysis Services from its earliest days. They have documented in detail the internal features of Analysis Services 2008, explaining server architecture, main data structures, data processing, and query resolution algorithms.
- Discover the new functionality introduced in Analysis Services 2008 including MDX enhancements and new DMV (dynamic memory views)
- Work with the Business Intelligence Development Studio, the new Dimension Editor, and Aggregation Designer interfaces
- Enjoy complete coverage of new Shared Scalable Databases scale-out infrastructure
- Learn the key concepts of multidimensional modeling
- Explore the multidimensional object model and its definition language
- Integrate multidimensional and relational databases
- Build client applications to access data in Analysis Services
- Unravel the inner workings of the server architecture, including main data structures, data processing, and query resolution algorithms
- Learn the main concepts of the MDX language and gain an in-depth understanding of advanced MDX concepts
- Gain a deeper understanding of the internal and external protocols for data transfer, including the XML/A protocol
- Discover how Analysis Services manages memory
- Explore the security model, including role-based security, code-access security, and data security
Category: Microsoft SQL Server
Covers: Microsoft SQL Server 2008 Analysis Services
User Level: Intermediate-Advanced
$59.99 USA / $65.99 CAN / £38.99 Net UK±
About the Author
Alexander Berger was one of the first developers to work on OLAP systems at Panorama, prior to their purchase by Microsoft. After the acquisition, Alexander led the development of Microsoft OLAP Server through all of its major releases prior to SSAS 2008. Currently, Alexander leads the Business Intelligence department for Microsoft adCenter. He is one of the architects of OLEDB for the OLAP standard and MDX language, and holds more than 30 patents in the area of multidimensional databases.
Edward Melomed is one of the original members of the Microsoft SQL Server Analysis Services team. He arrived in Redmond as part of Microsoft’s acquisition of Panorama Software Systems, Inc., which led to the technology that gave rise to Analysis Services 2008. He works as a program manager at Microsoft and plays a major role in the infrastructure design for the Analysis Services engine.
- Publisher : Sams Publishing; 1st edition (December 14, 2008)
- Language : English
- Paperback : 888 pages
- ISBN-10 : 0672330016
- ISBN-13 : 978-0672330018
- Item Weight : 2.91 pounds
- Dimensions : 7 x 1.8 x 9.1 inches
- Best Sellers Rank: #3,628,879 in Books (See Top 100 in Books)
- Customer Reviews:
Top reviews from the United States
There was a problem filtering reviews right now. Please try again later.
Something that is rarely appreciated is just how open Microsoft has always been with respect to this product in allowing such detailed information on its inner workings to be made publicly available. The chapters on internals are the most valuable compared to other information sources that are out there.
It is true as another reviewer complained that there exist an unnecessary number of grammatical, syntax and spelling errors (the only reason I don't give 5 stars), but they are and I hate to say it, minor irritants compared to the valuable information presented. The other negative reviews I just don't grock at all. If I have any complaint it is that many of the internals details are presented so matter-of-factly that they can slide right by you without your realizing their significance or implications. They also could have included more on how the workings that are revealed relate to the many server parameters you can adjust and the many performance monitor counters you can utilize in SQL Server Profiler and perfmon to gain deep insight into what is going on underneath.
If you aren't already conversant with Profiler, get a good book on it too, like Mastering SQL Server Profiler by Brad McGehee - it's focused on SQL Server counters but it all applies to AS also. Profiler and perfmon are your friends when to comes to deep diving AS performance.
I also appreciated the chapter on coding with ADOMD.NET, a topic that many MS AS practitioners never get close to even with years of experience - it's a great quick-start.
Mind you that if you are a newbie this may be a bit too overwhelming. However if you know the subject and want more detailed knowledge on inner workings of SSAS, then this book is a MUST READ.
Don't be too bothered about reviews on Amazon which say that this contains lot of XML based samples.... The XML samples are required, because the show how to use XMLA (Xml for Analysis Services).
All in all, this is the best book written on the subject.
I bought this book for one reason - it was the first one available. If you need one now, then get it. But be warned that it's not particularly good.
The key problem is that the authors are fascinated with XML. They use raw XML to explain a wide variety of concepts and tasks. For the authors and publishers, it has the benefit of wasting a lot of space. This fattens the book and makes it look like you are getting more for your money.
Unfortunately for the readers, the book is difficult to read and completely misses the point of the SSAS interface. XML is the underlying metadata structure of SSAS. That is the last place you should look to understand cube and dimensional structure, or for modifying how the cube works.
For a professional programmer (me), time is money and productivity is everything. First you should should use the graphical and tabular representation of metadata to manipulate the cubes and dimension. THEN, you write MDX functions when necessary. If all else fails, mess with the XML.
If you can wait a few weeks, there are two new books coming out for AS 2008. I believe either would a much better alternative to this book.
Don't waste your money buying this book like I did.