Summary

We have covered a lot of ground in understanding the various administrative functions related to Analysis Services. After getting a general introduction to the elements that compose the Unified Dimensional Model (UDM) and looking at the high-level architecture of Analysis Services, we reviewed important Server and Database administration tasks such as setting server configuration settings and deploying our databases. Next, we got some insight into performance monitoring and tuning. Then we turned our attention to storage administrative tasks such as configuring partitions or designing aggregations. Last, we reviewed the various security administration tasks such as creating database roles and assigning granular permissions to the roles. Now that you've learned about administering the Business Integration services, we'll move on in Chapter 8 to discussing how to administer the developer tools that SQL Server 2005 provides.