Free Ebook Download | Microsoft SQL Server 2008 MDX Step by Step | This book is meant to follow examples step-by-step, which means the sample databases have to be installed first. The instruction tells you to take the CD, and install two samples. It goes in great detail explaining that C:drive letter may need to be changed to D: (repeated 4 times), but it does not give you a slightest hint that different processes of SQL Server use different autentication regardless of your login name, and you need to give these permissions to the sample source files.
After spending several hours googling and experimenting, I got thru with permissions; fixed the problem with the log file (the only one mentioned on-line for book support), managed to load the first database, and got stuck with all kind of error messages loading the analysis services database.
Without the source code the only option was to send an email
to Microsoft Support team. All I got back is auto-reply, so instead of studying the new language I spend days waiting.
Brian and Ryan presented a very simple and literally step by step way to understand the fundamental syntax of MDX. In addition, the examples are good starting points to be adventurous and to try other stuff. The chapters are arranged in a very logical manner. Each chapter builds upon the knowledge picked-up from the previous one.
However, do not let Chapter 1 discourage you from continuing to explore the rest of the book. The attempt to present the wealth of business intelligence, dimensional model and data warehouse terms and structure may get to be confusing. I agree with them when they wrote that a familiarity of the concept of data warehousing is recommended. To better appreciate the whole exercise of learning MDX, a basic knowledge of Analysis Services will go a long way.
DOWNLOAD NOW
0 comments: