Site sponsored by: Idera Try Idera’s new SQL admin toolset
SQL Server Performance

  • Home
  • Articles
  • Forums
  • Tips
  • Quiz
  • FAQ's
  • Blogs
  • Software
  • Books
  • About Us
RSS Feeds
Sign in | Join


Write for Us

Share you SQL Server knowledge with others and raise your profile in the community More...
Latest Articles

Capture DDL Changes using Change Data Capture with SQL Server 2008 ...
Business Intelligence in Collaborative Planning, Forecasting and Replenishment
Inside SQL Server Cluster Setup and Troubleshooting Techniques - Part I ...
Configure and Manage Policy Based Management in SQL Server 2008 ...

More     
 
Latest FAQ's

Cannot Start SQL Server Service
Users are able to connect to report manager but not able ...
Errors when SQL Server Snapshot Replication is Running
How to Display Server Name or IP Address in a Reporting ...

More     
   
Latest Software Reviews

Spotlight on ApexSQL Doc 2008
ApexSQL Enforce
Embarcadero Change Manager
SQL Server DBA Dashboard

More     

books >> sql server 2000 books >> Professional SQL Server 2000 Data Warehousing with ...

Professional SQL Server 2000 Data Warehousing with Analysis Services


Feb 01, 2004

Book Review

Professional SQL Server 2000 Data Warehousing with Analysis Services
by Multiple Authors
Copyright 2001
Wrox Press

 

Professional SQL Server 2000 Data Warehousing with Analysis Services Find out more about this book,
or purchase it, from Amazon.com


There actually isn't a lot of material written on SQL Server 2000 data warehousing. I find this surprising because SQL Server 2000's data warehousing capabilities are first-rate, especially considering how little the software costs when compared to other data warehousing software. I don't know if this is due to a lack of SQL Server 2000 data warehousing professionals, or because book publishers don't see the potential of this product.

In any event, Wrox Press has come to the rescue with a solid book on how to use SQL Server 2000, along with its Analysis Services, to deal with data warehousing projects. While it is not a 100% comprehensive discussion of the subject, it covers all the basics, along with many advanced subjects, that you need to help learn this sometimes difficult and arcane subject.

Here's what the book covers:

  • Analysis Services in SQL Server 2000 -- An Overview

  • Microsoft Analysis Services Architecture

  • Analysis Services Tools

  • Data Marts

  • The Transactional System

  • Designing the Data Warehouse and OLAP Solution

  • Introducing Data Transformation Services (DTS)

  • Advanced DTS Topics

  • Building OLAP Cubes with Analysis Manager

  • Introduction to MDX

  • Advanced MDX Topics

  • Using the PivotTable Service

  • OLAP Services Project Wizard in English Query

  • Programming Analysis Services

  • English Query and Analysis Services

  • Data Mining -- An Overview

  • Data Mining: Tools and Techniques

  • Web Analytics

  • Securing Analysis Services Cubes

  • Tuning for Performance

  • Maintaining the Data Warehouse

What I really like about this book is its performance tuning content. Not only is there an entire chapter devoted to it, but performance is discussed in many other chapters. As I say over and over again on this website, it is important for beginner's to learn about the importance of performance at the very beginning, so that they are always thinking about it when the administer SQL Server, or if they are developing SQL Server-based applications. By providing this information, the book helps to get data warehousing novices thinking about performance considerations early in the game.

If you are new to data warehousing and want to get a good introduction to this subject, I recommend that you check out this book.


        








Home | Peformance Articles | Audit Articles | Business Intelligence Articles | Clustering Articles | Developer Articles | Reporting Services Articles | DBA Articles | ASP.NET / ADO.NET Articles | DBA FAQ's | Developer Peformance FAQ's | DBA Peformance FAQ's | Developer FAQ's | Clustering FAQ's | Error Messages | Audit Tool Reviews | Backup Tool Reviews | Coding Tool Reviews | Compare Tool Reviews | Documentation Tool Reviews | Design Tool Reviews | Monitoring Tool Reviews | Log Tool Reviews | Reporting Tool Reviews | Clustering Tool Reviews | Security Tool Reviews | Change Management Tool Reviews | Remote Access Tool Reviews | Book Reviews | Security Tool Reviews | QDPMA Performance Tuning | ADO.NET / ASP.NET | Administration | Analysis/OLAP Services | Application Development | Configuration | Components | ETL | Hardware | High Availability | Hints | Index | Misc | Operating Systems | Performance Tuning | Replication | T-SQL | Views


              © 1999-2008 by T10 Media. All rights reserved