Professional Microsoft® SQL Server® 2008 Administration

7.7. 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 make up the Unified Dimensional Model (UDM) and looking at the high-level architecture of Analysis Services, we reviewed important server and database administrative tasks such as setting server configuration settings and deploying your databases. Next, you 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 2008 provides.