Summary

In this chapter, you’ve learned about the key features of Analysis Services and how to develop a basic database using the Dimension Wizard and the Cube Wizard. You also learned how to configure server properties, manage large databases through partitioning, keep databases up-to-date, secure Analysis Services databases, and monitor server performance. You should now have a good understanding of how Analysis Services works and how you might use this SQL Server component to expand the data management capabilities of your organization.

Get Microsoft® SQL Server™ 2005 Administrator's Companion now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.