O'Reilly logo

Professional Microsoft® SQL Server® 2008 Administration by Steven Wort, Ross LoForte, Wayne Snyder, Ketan Patel, Brian Knight

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required