Buy used: $6.94

FREE delivery March 26 - 28. Details

Or fastest delivery March 20 - 22. Details

Select delivery location

Used: Very Good | Details

Sold by ThriftBooks-Seattle

Access codes and supplements are not guaranteed with used items.

Follow the author

Irina Gorbach

Follow

Microsoft SQL Server 2008 Analysis Services Unleashed 1st Edition

by Irina Gorbach (Author), Alexander Berger (Author), Edward Melomed (Author)

4.1 19 ratings

See all formats and editions

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±

ISBN-10

0672330016
ISBN-13

978-0672330018
Edition

1st
Publisher

Sams Publishing
Publication date

December 14, 2008
Language

English
Dimensions

7 x 1.8 x 9.1 inches
Print length

888 pages
See all details

Editorial Reviews

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

Irina Gorbach is a senior development lead at Microsoft. She joined the Analysis Services team soon after its creation over 11 years ago. During her work at Microsoft, Irina has designed and developed many features of the Analysis Services product, and was responsible for client subsystem: OLEDB and ADOMD.Net. Irina was in the original group of architects that designed XML for Analysis specification; she worked on the architecture and design of calculation algorithms and currently is working on scalability of Analysis Services.

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.

Product details

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: #5,310,090 in Books (See Top 100 in Books)
- #372 in Microsoft SQL Server
- #816 in Client-Server Networking Systems
- #1,055 in SQL

Customer Reviews:
4.1 19 ratings

Brief content visible, double tap to read full content.

Full content visible, double tap to read brief content.

Videos

Help others learn more about this product by uploading a video!

Upload your video

Important information

To report an issue with this product or seller, click here.

About the author

Follow authors to get new release updates, plus improved recommendations.

Irina Gorbach

Brief content visible, double tap to read full content.

Full content visible, double tap to read brief content.

Discover more of the author’s books, see similar authors, read author blogs and more

Customer reviews

4.1 out of 5

19 global ratings

How customer reviews and ratings work

Sort reviews by

Top reviews from the United States

There was a problem filtering reviews right now. Please try again later.

Abhishek Srivastava

Hands down .... the best book on Analysis services

Reviewed in the United States on July 4, 2009

Verified Purchase

I found this book to be extremely informative. I have read many other books on SSAS and I found that this book can tell you a lot about how SSAS really works. It also have an very wide and excellent coverage of topics which are seldom even discussed in many other SSAS books.

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.

5 people found this helpful

Helpful

Ron Davis

Everything worth knowing about SSAS 2008

Reviewed in the United States on February 7, 2009

Verified Purchase

OK, if you are a technologist and are inclined to write a book on a specific technology then read this most excellent book and see how it should be done. This explains everything about SSAS in finite details. I am writing a course on Microsoft BI and this is my reference of choice.

4 people found this helpful

Helpful

Animation Fan

Excellent if you want/need to really get under the covers

Reviewed in the United States on March 2, 2011

Verified Purchase

Don't get this book for any sort of introduction to Analysis Services, though it attempts to have sufficient breadth to have something for everyone. This book would be best for someone who has already worked extensively with Analysis Services for several years and wants or needs to take it to the next level, in terms of cube size and performance (both processing and querying), where you really need to understand what is going on in the engine under the covers.

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.

One person found this helpful

Helpful

Donald Schaeffer

Not very useful.

Reviewed in the United States on May 13, 2014

Verified Purchase

This book is all detail and no big picture. I didn't even find it useful as a reference. Save your money.

Reviewed in the United States on March 3, 2014

Verified Purchase

This was a great resource for my project. I looking forward to review other books on your list in the near future.

Helpful

Wayne Robertson

Must Have Reference for Analysis Services Experts

Reviewed in the United States on February 3, 2013

Verified Purchase

This book contains detailed insights into the internals of Analysis Services and is a must own for any Analysis Services professional.

Helpful

Boyan Penev

Exceptional In-Depth Information

Reviewed in the United States on February 17, 2011

If you think that you know SSAS 2008 and you haven't read this book, you should buy and read it. It is the best book on Analysis Services internals on the market.

All negative reviews here are either about it being too complicated or not well written. While to some extent this is correct, I think that the positive sides of this book completely outweigh the negative ones. It is important to understand who is the target audience. If you are learning SSAS from scratch or even if you are on an intermediate level there are other books which will suit you better. However, if you are on an advanced/expert level and want to know more about exactly how SSAS works you will not find any other book which speaks about SSAS in such detail.

Considering that the authors actually _make_ SSAS the material is 100% guaranteed to be accurate and complete.

A must buy for everyone who wants to understand SSAS in full.

2 people found this helpful

Helpful

Eric J. Lynch

Totally useless if you want to get any real work done

Reviewed in the United States on March 25, 2011

This book will not teach you what you need to do to make SSAS work for you. It will make you a PhD in what SSAS does under the hood. The author clearly hasn't used this tool in the real world, even though he is clearly smart enough to have built it. I mean, who really cares about the bit structure of how SSAS stores strings? He also spends a LOT of space showing you the DDL of the data structures you build in SSAS in XML format. Seriously? Wish I hadn't bought this book. It's totally worthless for those of us who have jobs and need to get some real work done.

To coin an analogy, if you were looking for a book on auto racing, this book won't teach you the first thing about winning races. But it'll teach you everything you ever wanted to know about the chemical make up of the metals that were used to cast your engine block. Hope this helps.

3 people found this helpful

Helpful

Top reviews from other countries

M. J. Swain

Highly recommended!

Reviewed in the United Kingdom on April 27, 2012

Verified Purchase

I've taught myself SQL from books, and managed to get involved with a project to create a large data warehouse and various cubes off of that.

The project has been fascinating, but I realised that while I'm enthusiastic and have taught myself a lot, Analysis Services is a very complex offering. Sure once you've created a data warehouse you can put together a cube relatively easily, but there's much more to Analysis Services.

It's a big text book, but it's also surprisingly readable. I've started working through it so that I have a comprehensive understanding of the systems I'm using, but it's also great for looking up specific things, and yesterday I used it to establish how to set up security which effectively creates "sub-cubes".

I would highly recommend this book for anyone who is or will be working with Analysis Services, with the only note being that it will be (very) heavy going if you have literally no knowledge of data warehousing or Analysis Services.

One person found this helpful

See more reviews